Light intensity and distance analysis spreadsheet

A spreadsheet that can be used to analyse the data obtained in the experiment to investigate light intensity and distance like in this video.

The spreadsheet automatically calculates the power of the light source and percentage difference with the manufacturer’s rating from inputted distance and light intensity data. The data plots are added to a carefully formatted graph. A line of best fit is automatically plotted. The gradient of the line is automatically calculated from the data plots and the value of the source power is calculated by using the gradient. This spreadsheet is perfect for rapidly analysing experimental data.

A second table calculates proportionality constants so that the user can very quickly check if their data obeys an inverse square law.

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.