For each set of data, at what temperature would the volume of the gas become zero? If you could do both it would be appreciated ALTHOUGH one would be good enough. Thank you so much for all your help, I'm entirely lost.
Data #1:
Temperature (Degrees Celsius) Volume (Liters)
195 --> 276.92
160 --> 237.76
100 --> 215.51
65 --> 195.99
0 --> 156.76
-25 --> 143.09
Data #2:
Temperature (Degrees Celsius) Volume (Liters)
195 --> 263.92
160 --> 249.3
100 --> 219.58
65 --> 194.84
0 --> 157.45
-25 --> 135.19
Data #1:
Temperature (Degrees Celsius) Volume (Liters)
195 --> 276.92
160 --> 237.76
100 --> 215.51
65 --> 195.99
0 --> 156.76
-25 --> 143.09
Data #2:
Temperature (Degrees Celsius) Volume (Liters)
195 --> 263.92
160 --> 249.3
100 --> 219.58
65 --> 194.84
0 --> 157.45
-25 --> 135.19
-
enter the data in an excel spreadsheet
do a linear regression to find the equation of the best fit line through the data
plug in 0 for V and solve for T
like this
******
setup the data like this
http://i42.tinypic.com/vo3hvl.png
mouse to A3
left click and HOLD
mouse to B8 to highlight the first 2 columns of data like this
http://i43.tinypic.com/2a8jpmv.png
mouse to and left click on the menu item INSERT
mouse to and left click on SCATTER under charts
mouse to and left click on the upper left plot (the one with just dots.. no lines
you should now see a plot
mouse to and right click on any data point on that plot
left click on add trendline
check the boxes for "display equation on chart" and "display r-squared"
close.
you should now have this plot
http://i39.tinypic.com/2crx93o.png
notice the equation?
y = 0.5741x + 156.98
Y in this case is volume in L
X in this plot is temperature in °C
so..
V = (0.5741 L/°C) x T + 156.98 L
if you want to know T when V = 0
0 = (0.5741 L/°C) x T + 156.98 L
T = -156.98 L / ((0.5741 L/°C) = -273.44°C
*******
same thing for the 2nd data set... but you need to know how to highlight the data correctly.
mouse to A3
left click and hold to A8
press and hold button
release mouse button... still holding
mouse to B3
left click and hold
mouse to B8
add the plot and trendline and you should get this
http://i41.tinypic.com/73jw9f.png
and in a similar fashion
T = -155.33 L / ((0.5825 L/°C) = -266.66°C
******
what gases where you testing?
do a linear regression to find the equation of the best fit line through the data
plug in 0 for V and solve for T
like this
******
setup the data like this
http://i42.tinypic.com/vo3hvl.png
mouse to A3
left click and HOLD
mouse to B8 to highlight the first 2 columns of data like this
http://i43.tinypic.com/2a8jpmv.png
mouse to and left click on the menu item INSERT
mouse to and left click on SCATTER under charts
mouse to and left click on the upper left plot (the one with just dots.. no lines
you should now see a plot
mouse to and right click on any data point on that plot
left click on add trendline
check the boxes for "display equation on chart" and "display r-squared"
close.
you should now have this plot
http://i39.tinypic.com/2crx93o.png
notice the equation?
y = 0.5741x + 156.98
Y in this case is volume in L
X in this plot is temperature in °C
so..
V = (0.5741 L/°C) x T + 156.98 L
if you want to know T when V = 0
0 = (0.5741 L/°C) x T + 156.98 L
T = -156.98 L / ((0.5741 L/°C) = -273.44°C
*******
same thing for the 2nd data set... but you need to know how to highlight the data correctly.
mouse to A3
left click and hold to A8
press and hold
release mouse button... still holding
mouse to B3
left click and hold
mouse to B8
add the plot and trendline and you should get this
http://i41.tinypic.com/73jw9f.png
and in a similar fashion
T = -155.33 L / ((0.5825 L/°C) = -266.66°C
******
what gases where you testing?