Data analysis

A question about data analysis appears below. Data is provided in a text field. Copy this data into a spreadsheet program to calculate the answers to the question. There is a link to a webform that can be used to calculate average and the standard deviation of a single column of numbers. You can either use this form or your spreadsheet program to calculate the average and standard deviation.

Acceleration of gravity at earth's surface, $g\approx 9.81$ m/s², can be measured in a simple experiment with a pendulum. If the angle that the pendulum makes to vertical is small, the period is,

$\large T\approx 2\pi\sqrt{\frac{L}{g}}.$

Five hundred students make pendula using string of different lengths and measure the period. Their results are given in the table below.

 $L$ [m]   $T$ [s]

Use a spreadsheet to calculate the value of $g$ obtained by each student. What is the average value of $g$ measured by the students? What is the standard deviation?

Calculate mean and standard deviation.