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.

 

Read

AH LO3

You completed the practical aspect of your LO3 task today.

For next week, please process your data so you can show me

  • complete table of results
  • a graph of centripetal force vs the square of angular velocity
  • sample calculations for your uncertainties.

This will probably be easier to complete if you use a spreadsheet program such as Excel or OpenOffice.  You will need diagrams for the procedure section of your LO3 report.  Scanned images of the apparatus are available here.