Saturday, 12 November 2011

Graphing

As we all know : Density = mass/volume
In order to draw a " mass vs volume " graph, we have to consider volume as the dependent variable and mass is the independent one.
So , the x axis contains volume and y contains mass.
The slope of an straight line = rise / run = y / x = volume / mass
If we are to find the density , density will equal to 1/ slope = mass / volume

Here's how to make a graph by Microsoft Excel to save more times.
1. Open Excel then click on INSERT tab


2. Choose Scatter graph ( scatter with only markers )
3. Then the graph panel appears, right click on the graph, choose " Select Data"

4. Click " Add"

5. Enter the value for X and Y then click OK
6. Here we have a graph
7. Click on " Layout " tab then choose trendline --> then choose linear trendline to get the line of best fit
8.If you want to have the computer calculated the line's slope, click on trendline button again --> trendline option --> tick on the " Display Equation on chart " in the bottom of the panel.
9.Now we have finished the mass vs. volume graph! As I mentioned on top, density = 1/slope

No comments:

Post a Comment