Is anyone killer with physics? I think this is. I am using excel and need to enter a formula. Help?

Question

Consider the following data that show temperature of a 1,000 g sample of water at normal atmospheric pressure as a function of heat supplied. A kJ can simply be thought of a unit of heat.


Temperature Heat Supplied
0 oC 0 kJ
10 oC 42 kJ
30 oC 126 kJ
50 oC 209 kJ
80 oC 335 kJ
99 oC 414 kJ
100 0C 420 kJ

Based on these data, please supply the following:
1. Provide a graph of the data. Is the graph sufficiently linear to allow prediction of heat supplied versus temperature in the range of 0–100 oC?
2. If so, use Microsoft Excel to provide an equation that relates heat, y, supplied to temperature, x, in the range of 0–100 oC.
3. Are the results consistent with the expected equation, heat = (1.00 cal/g oC) * mass in grams * (final temperature – initial temperature)?

Can anyone help me with this? I have no idea what to enter as the equation to get Excel to have something to work with.

Answer 1

you don't need an equation. put the data in columns, oC in one, kJ in another. select it all, then make a graph of it. after you have the graph, make sure you show the equation

Answer 2

You don't have to enter the equation, Excel will give you the equation.
Enter in cell A1 the heading "Temperature". Enter in cell B1 the heading "kJoules".
Enter your independent variable data (X data) in the A column(A2 - A8)
Enter your dependent variable data (Y data) in the B column (B2 - B8).
Highlight your data (with the labels).
Click on Insert > Chart > X-Y (Scatter) > Choose 2nd choice (line with markers) > Next > Data Range: A1:B8 (Include labels) > Next > Enter appropriate titles and labels > Next > Finish
Delete the legend box because you have only on dependent variable (Y-Data)
Click on Chart (top menu) > Add trendline > Options > Check box for Display equation on chart > OK
You should see your straight line equation on the chart.
The data fits so perfectly that it is probably not the result of an experiment.

Answer 3

i'm not going to give you any legitimate answers since this is obviously homework or some sort of assignment.

you need 2 columns in excel, 1 for temp(C), one for heat(kJ)

then you create a graph for this data (scatter plot is probably best)

You can then use excel to create a line of best fit (they call it a trendline) by right clicking on any point of your graph

from there you could use that equation to determine if number 3 is true

Answer 4

it particularly is basically a count number of determination quite. while you're working in a rfile it particularly is on say cellular A5/1253 and you want the addition of the totals on a cellular which you do no longer even undergo in strategies the place it particularly is, you may desire to in simple terms scroll up and click on the cellular instead of scrolling up, remembering the region, scrolling bypass into opposite, and typing it in. i come across it greater handy to in simple terms click on the cellular i want. I not often pay interest to what the region is.