Tooltip
These resources have been reviewed and selected by STEM Learning’s team of education specialists for factual accuracy and relevance to teaching STEM subjects in UK schools.

Standard Deviation

This is a series of interactive excel sheets that explore the different methods for calculating standard deviation.

The first sheet helps demonstrate the method for finding the standard deviation from population data by summing the squared deviations from the mean. The second sheet shows the alternative method of summing the squares of the data instead.

The third sheet calculates the standard deviation from a frequency distribution by summing the squared deviations from the mean. The second sheet shows the alternative method of summing the squares of the data from the frequency distribution instead.

The next sheet calculates the standard deviation by summing the squares of the data for a grouped frequency distribution.

The following four sheets calculate the standard deviation from sample data. The first sums the squared deviations from the mean, the second sheet takes the sum of the squares of the data. The third sheets sums the squared deviations from the mean from a frequency distribution, the forth sheet sums the squares of the data from a frequency distribution.

The final sheet shows how coding can be used to help calculate the standard deviation when summing the squares using sample data.

Note the formulae used in each method can be revealed at the side of each page. New examples can be made each time at the click of a button.

Note
This program was designed by be viewed on a screen with a resolution of 1024 x 768. Users may have to adjust the resolution of their screen for the pages to display as was originally intended. The program uses macros which need to be enabled on users’ machine.

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.

Downloads

Show downloads

Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.

Lists that tag this content