Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Get Excel to provide equation for my x and y
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Get Excel to provide equation for my x and y
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 -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "hasargent" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Get Excel to provide equation for my x and y
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 "hasargent" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Provide Excel format for architectural units: ft-inches-fractions | Excel Discussion (Misc queries) | |||
Please provide Page Layout View in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel should provide the facility to compare two spreadsheets | Excel Discussion (Misc queries) | |||
Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
Excel 2003-provide feedback with sound | Excel Discussion (Misc queries) |