Comments (0)

By mrmackenzie, September 27, 2011 10:18 am

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.

eBook Download (77)

Comments (0)

By mrmackenzie, September 18, 2009 10:01 pm

Those of you working on your LO3 report this weekend might like to see what another physics teacher, Mr Hood, has to say about this aspect of your course work.  Read his blog post here.  He’s also kindly provided more detailed help in the form of an audio podcast.  Click the link below to listen.

Standard Podcast [ 17:39 ] Play Now | Play in Popup | Download