Estimate Planck's Constant - Analysis Spreadsheet

Copy of the spreadsheet I used to analyse the experiment to estimate Planck’s constant in this video.

The spreadsheet automatically calculates photon energy from inputted potential difference 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 estimate for the Planck constant 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.