Averages and Moving Averages

Rate this resource

This resource contains two excel files dealing with measures of central tendency, trend and spread for sets of discrete data.

Averages and Range
The first interactive sheet shows a set of nine data items which can be shown sorted into ascending order. The values of mean, median, mode, range, quartiles and inter-quartile range can be revealed.

The next two sheets deal with sets of 10 and 20 items of data in the same way.

The final sheet shows sets of five data items and students either need to calculate mean, median and range or use one of those statistics in order to find the missing data items.

There are five more sheets of questions which may be suitable for use in the classroom.

Moving Averages
The first interactive sheet generates sets of 12 data items which are shown on a graph in the form of a time series. The 3 point moving averages are calculated and plotted on the same diagram and the trend line can be superimposed. The next sheets deal with 4 and 5 point moving averages in the same way.


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' machines.

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.

Published by


Share this resource