Acceleration of Free Fall - Analysis Spreadsheet

Copy of the spreadsheet I used to analyse the experiment to determine the acceleration of free fall in this video.

The spreadsheet automatically calculates final velocity of the weighted card from inputted electronic timer readings. The data plots are added to a carefully formatted graph. A line of best fit is automatically plotted. The gradient and y-intercept of the line are automatically calculated from the data plots and the value of acceleration of free fall is calculated from the gradient. This spreadsheet is perfect for rapidly analysing experimental data.

This is a Numbers spreadsheet. It is possible to convert Numbers spreadsheets to Excel files but I cannot guarantee an easy to use output since the tables may be converted to separate worksheets in the Excel file.

Suitable for most A-Level Physics specifications.