Radioactive decay analysis spreadsheet

A spreadsheet that can be used to analyse the data obtained in the experiment to determine the decay constant of an isotope like in this video.

The spreadsheet automatically calculates the decay constant and initial activity from inputted time and activity readings using a natural log analysis. 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 the decay constant is calculated by using the gradient. This spreadsheet is perfect for rapidly analysing experimental data.

The initial activity is calculated by using the y-intercept, this is a useful indicator of the accuracy of the final value.

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 physics specifications that cover nuclear physics.