Get Excel to provide equation for my x and y

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hasargent - 05 Dec 2007 00:37 GMT

I am doing an assignment on how hot water gets in degrees celcius when so
many kilojoules are supplied to it. i have a graph, with data provided to me
for this function. kilojoules is my y, and degrees celcius is my x. i need to
get excel to provide an equation that relates heat, y supplied to temp., x,
in the range of 0-100 degrees celcius.

Reply to this Message

Bernard Liengme - 05 Dec 2007 01:43 GMT

In A1 type the word temperature; in B1 the word kilojoules
Under these enter your data
Put the mouse pointer anywhere with in the data; use the Chart Wizard on the
toolbar to make an XY chart with just markers (no line)
When you have the chart, right click a marker in the chart; use Insert
Trendline; specify Linear trendline and in the Options check the Display
Formula
If the fit is not good, right click the trendline in the chart; use Format
Trendline and change it to a second order polynomial
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I am doing an assignment on how hot water gets in degrees celcius when so
> many kilojoules are supplied to it. i have a graph, with data provided to
[quoted text clipped - 4 lines]
> x,
> in the range of 0-100 degrees celcius.

Reply to this Message

scubadiver - 06 Dec 2007 12:01 GMT

Your first sentence tells me the temperature is the dependent variable so
strictly, celsius should by Y and kilojoules should be X.

If your data is set out as you have explained it then you should get what
the teacher is expecting but be aware the equation could be wrong if you have
the axis the wrong way round (I think!)

Just a warning

> I am doing an assignment on how hot water gets in degrees celcius when so
> many kilojoules are supplied to it. i have a graph, with data provided to me
> for this function. kilojoules is my y, and degrees celcius is my x. i need to
> get excel to provide an equation that relates heat, y supplied to temp., x,
> in the range of 0-100 degrees celcius.

Reply to this Message

Rate this thread: