AH – help using Excel

This tutorial will help you with adding a line of best fit to your LO3 graph.  If you use the linest function, you can extract useful information on gradient and intercept of the line.  There are also screenshots to show how error bars can be added to individual points.

Excel Tutorial: Using LINEST function, Plotting a graph, Adding Error Bars

I have added a download link to a short pdf on the use of linest.

 

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.