## using linest to obtain a gradient and uncertainty

The period T of a simple pendulum can be calculated using

$T=2 \pi \displaystyle \sqrt{l \over g}$

where l is the pendulum length and g is the gravitational field strength.

Using a single value of length and period, we can determine the acceleration due to gravity.  However, it would be better experimental practise to vary the length of the pendulum and plot a graph of $T^2$ against length, determining g from the gradient of the line of best fit.

You’re going to spend the next few periods analysing your simple pendulum data.  The attached pdf will walk you through the steps.  It would be better if you used your own results but I’ve put some sample data on the first page if you’ve forgotten to bring yours.

If you are using your chromebook, there may be subtle differences from the Excel instructions I have provided.  Let me know if anything doesn’t work and I’ll try to help.

Note that if you are using your own data, there will be no random uncertainty as measurements were not repeated.

## referencing guide for AH project report

You should be thinking about getting some of your project report finished so there is less to do when the deadline approaches.  You can start writing up your underlying physics section and sort out the references you will include at the end of the report.  I’ve attached a guide on referencing in the Vancouver style.  Get back to me if you have any questions.

Thanks to Imperial College London for producing this booklet.

## using Excel’s LINEST function

The period T of a simple pendulum can be calculated using

$T=2 \pi \displaystyle \sqrt{l \over g}$

where l is the pendulum length and g is the gravitational field strength.

Using a single value of length and period, we can determine the acceleration due to gravity.  However, it would be better experimental practise to vary the length of the pendulum and plot a graph of $T^2$ against length, determining g from the gradient of the line of best fit.

We’re going to spend the next three periods analysing your simple pendulum data in the library.  The attached pdf will walk you through the steps.  It would be better if you used your own results but I’ve put some sample data on the first page if you’ve forgotten to bring yours.