Skip to content

Time series and moving averages

GCSE Statistics revision notes, key terms and practice questions.

In short

A time series is data recorded at regular intervals over time, such as monthly sales. Plot it with time on the horizontal axis and join the points with straight lines.

For GCSE students in Years 10 and 11, on the AQA and Edexcel Statistics courses.

Time series graphs

  • A time series is data recorded at regular intervals over time, such as monthly sales. Plot it with time on the horizontal axis and join the points with straight lines.
  • The trend is the general direction over time. Seasonal variation is a pattern that repeats, such as higher ice cream sales every summer. Random variation is unpredictable.

Moving averages

  • Moving averages smooth out seasonal variation to show the trend. Use the same number of points as the length of the pattern: 4 points for quarterly data and 12 for monthly data.
  • Example: quarterly sales 10, 14, 12, 16, 18. The first 4-point moving average is (10 + 14 + 12 + 16) ÷ 4 = 13. The next is (14 + 12 + 16 + 18) ÷ 4 = 15.
  • Plot each moving average at the middle of the time period it covers, then draw a trend line through them.

Seasonal variation and predictions

  • Seasonal variation for a point = actual value − trend value.
  • The mean seasonal variation for a season (such as quarter 1) is the average of all its seasonal variations.
  • To predict: read the trend line forward, then add the mean seasonal variation. If the predicted trend for next quarter 3 is 40 and its mean seasonal variation is −5, the prediction is 35.

Key terms

Time series
Data recorded at regular intervals over time.
Trend
The general direction of data over time.
Seasonal variation
A pattern that repeats over a regular period.
Moving average
An average of a set number of consecutive values, moved along one at a time.
Trend line
A line drawn through the moving averages to show the trend.
Mean seasonal variation
The average difference between actual values and the trend for one season.

Quick questions on Time series and moving averages

What does a moving average do?
Smooths out seasonal variation to show the trend: It averages out repeating patterns.
How many points should a moving average use for quarterly data?
4: One for each quarter of the year.
Sales are 10, 14, 12 and 16. What is the 4-point moving average?
13: 52 ÷ 4 = 13.
What is seasonal variation?
A pattern that repeats over a regular period: Such as higher sales every December.
The actual value is 42 and the trend value is 38. What is the seasonal variation?
4: 42 − 38 = 4.
Where do you plot a moving average?
At the middle of the time period it covers: It represents the whole period.
Trend prediction is 40 and the mean seasonal variation is −5. What is the prediction?
35: 40 + (−5) = 35.
What is the trend?
The general direction of the data over time: Up, down or level.

Time series and moving averages: questions and answers

What is the 3-point moving average of 21, 24 and 30?
75 ÷ 3 = 25.
For monthly data with a yearly pattern, how many points should a moving average use?
12. Twelve months in the pattern.

Practise Time series and moving averages: 10 questions

Download these notes as a PDF

Previous topic: Lines of best fit, interpolation and extrapolationNext topic: Index numbers and rates

More in Processing, representing and analysing data

LycoLearn is still loading…

This can take a little longer on a busy school or home network. If nothing happens, try refreshing the page.

LycoLearn didn’t load properly

Part of it didn’t arrive. Try refreshing the page in a minute, or open LycoLearn in another browser.