Wednesday, 2 November 2011

Graphing

Today, we did some graphing using Excel. It is a very useful tool. You can alter the graph, making it as large as you want, labelling the axis, changing the colours and styles, as well as many other things. You can also choose to put a line-of-best-fit as well as displaying the equation. Using these tools, you can figure out if the numbers are linear or not.
An example of a linear relationship is:                                              


An example of a non-linear relationship is:

















Plotting data makes it easier to read. For substances, for example, you can determine their melting point, boiling point, etc. It is also easy to determine which data is reliable, and which aren't on the line-of-best-fit and may have been a mistake or inaccurately measured.

No comments:

Post a Comment