Graphing the Density of Water

Today we had a short at the beginning of class on the lab that we preformed last day.
Then we went into the computer room and started graphing data that ms. Chen collected during our quiz.

How to Graph Data
Open excel and create a two columns, one for mass and the other for volume.
Then adjust the values so they are correct.
Then highlight the values for your graph and click create graph.
Select scatter (x,y) graph
Edit the special options such as the title, axis and legend (you can also change the colours!)
Right-click one of the data points and select create trend line. A line of best fit will appear
Now highlight the trend line and select show formula. The formula for the trend line will appear.

Our Results:
Using this method we compared the density of cold water to the density of hot water. We found that cold water had a density of 1.34g/cm3 and that hot water had a density of 1.04g/cm3.
Hot water has a lesser density than cold water because the particles are more spread out due to more energy in the substance.


The blue is cold water which is more dense so it stays at the bottom. The red is hot water which is less dense so it floats near the top


Here is a really good video explaining water density
http://www.youtube.com/watch?v=Ak9CBB1bTcc


KP