Tuesday, November 15, 2011

Drawing and Interesting Graphs Using MS EXCEL --- by Ria Park

Since a graph represents the relationship between variables, sometimes a graph helps us to solve the density problem.

Density = Mass/Volume

Because a slope is equal to y/x(Rise-y over Run-x), the volume should be on x-axis. On the other hand, the mass should be on y-aixs.

We did the graphing with MS Excel. It was easy to make a graph and we can get the ideas easily.

Steps
- Open the MS Excel program and complete the table
- Click 'Insert', select 'scatter', then the graph will come out.
- Click anyone of the points and choose "Add Trendline" -> "Linear" or "Polinomial"
- Display Equation on the Chart
- Make it pretty!


And here are three graphs that we did in the class.





This is a video that demonstrates how to make a graph on excel.

http://www.youtube.com/watch?v=8B8kFVNzlQ8