Time Series and Moving Averages
A time series is a set of data values recorded at successive, evenly spaced points in time, such as monthly sales or yearly temperatures, and it is plotted as a line graph to show trends. A moving average smooths out short-term fluctuations and seasonal variation by averaging a fixed number of consecutive data points, making the underlying trend easier to see.
Method
- Plot the time series data as a line graph with time on the horizontal axis, in order.
- Decide the length of the moving average from the pattern in the data, for example a 4-point moving average for quarterly data with 4 seasons a year.
- Calculate the first moving average by finding the mean of the first set of consecutive points.
- Find the next moving average by dropping the earliest point in the previous set and adding the next point, then finding the mean again.
- Repeat this process, sliding along the data one point at a time, to get the full sequence of moving averages.
- Plot the moving averages on the same graph and draw a trend line through them to see the underlying direction of the data.
Common mistakes
MistakeUsing non-consecutive values in a moving average, or dropping a value without adding the next value in the time order.
InsteadKeep the fixed window length and slide it one observation at a time: remove only the earliest value, add the next value, and divide the new total by the same number of values.
MistakeRounding each moving average before using it to describe the trend, which can make small changes appear larger or disappear.
InsteadKeep the exact total or full calculator value during the calculation, round the displayed moving averages at the end, and base the trend on the unrounded results.
MistakeTreating a moving average as an original observation and claiming that it is the actual value recorded at that time.
InsteadCall it a smoothed estimate made from several consecutive observations. It reveals the underlying direction but does not replace the original time series data.
Worked examples
Example 1
A cafe's quarterly ice cream sales (in tens of pounds) are: 20, 35, 50, 25, 22, 38. Calculate the first three 4-point moving averages.
- First moving average = mean of the first 4 values = (20+35+50+25)/4 = 130/4 = 32.5.
- Second moving average = mean of values 2 to 5 = (35+50+25+22)/4 = 132/4 = 33.
- Third moving average = mean of values 3 to 6 = (50+25+22+38)/4 = 135/4 = 33.75.
Example 2
Monthly online orders at a small shop were: 142, 118, 155, 171, 149, 184, 201, 176. Calculate every 3-point moving average and state the overall trend, giving moving averages to 2 decimal places.
- First moving average = (142 + 118 + 155) / 3 = 415 / 3 = 138.333... .
- Second moving average = (118 + 155 + 171) / 3 = 444 / 3 = 148.
- Continuing the same sliding window gives (155 + 171 + 149) / 3 = 158.333... and (171 + 149 + 184) / 3 = 168.
- The last two are (149 + 184 + 201) / 3 = 178 and (184 + 201 + 176) / 3 = 187.
- Final answer: the 3-point moving averages are 138.33, 148.00, 158.33, 168.00, 178.00 and 187.00 orders, showing an increasing trend (all to 2 d.p.).
Example 3
A fictional stall records weekly orders over eight weeks: 12, 18, 15, 21, 24, 18, 27, 30. Find the centred 4-point moving averages and state which periods have no centred average.
- First calculate the five consecutive 4-point averages: (12+18+15+21)/4 = 66/4 = 16.5; (18+15+21+24)/4 = 78/4 = 19.5; (15+21+24+18)/4 = 78/4 = 19.5; (21+24+18+27)/4 = 90/4 = 22.5; (24+18+27+30)/4 = 99/4 = 24.75.
- A 4-point average is centred halfway between the middle two weeks because the window has an even number of values. The five averages therefore sit between weeks 2 and 3, 3 and 4, 4 and 5, 5 and 6, and 6 and 7.
- To centre on a single week, average each adjacent pair of these 4-point averages: week 3 = (16.5+19.5)/2 = 18; week 4 = (19.5+19.5)/2 = 19.5; week 5 = (19.5+22.5)/2 = 21; week 6 = (22.5+24.75)/2 = 23.625.
- Each centred value uses two neighbouring 4-point windows, so it needs observations on both sides of its week. The first pair centres on week 3 and the last on week 6; weeks 1, 2, 7 and 8 have no centred average because a full pair of windows cannot be placed around them.
- Final answer: the centred 4-point moving averages for weeks 3 to 6 are 18, 19.5, 21 and 23.625 orders. Weeks 1, 2, 7 and 8 have no centred average.
Practice questions
Q1[2 marks]Find the 3-point moving average of 10, 14, 18.Show answer
Answer: 14
Q2[2 marks]Find the 3-point moving average of 14, 18, 20.Show answer
Answer: 17.33 (2 d.p.)
Q3[2 marks]Find the 4-point moving average of 8, 12, 16, 20.Show answer
Answer: 14
Q4[2 marks]Find the 4-point moving average of 12, 16, 20, 10.Show answer
Answer: 14.5
Q5[2 marks]What does a moving average smooth out in seasonal data, and what does the result reveal?Show answer
Answer: It smooths out seasonal fluctuation, revealing the underlying trend.
Q6[2 marks]A series of 4-point moving averages is 45, 48, 52, 55. Describe the trend shown by these values.Show answer
Answer: An increasing (upward) trend over time.
Exam-style questions
Written in the style of a GCSE Statistics exam paper, with a full mark scheme.
Exam tips
- Write the observations in time order and show each consecutive window before dividing, so it is clear which values contribute to every average.
- Use the stated window length consistently, and keep extra calculator digits until the final moving averages are rounded.
- Describe the direction of the moving averages over time, then explain that smoothing reduces short-term fluctuation rather than removing the original data.
Q1[2 marks]State two reasons why a business might use moving averages when analysing sales data.Show mark scheme
Tick each line you got.
Nothing ticked yet - 2 available
Q2[4 marks]A restaurant's quarterly takings (in hundreds of pounds) for 6 quarters are: 40, 55, 70, 45, 42, 58. Calculate the first three 4-point moving averages.Show mark scheme
Tick each line you got.
Nothing ticked yet - 4 available
Q3[5 marks]Quarterly electricity bills, in pounds, for a household over 5 quarters are: 80, 120, 95, 60, 90. (a) Calculate the two 4-point moving averages that can be found from this data. (b) State whether the trend is increasing or decreasing.Show mark scheme
Tick each line you got.
Nothing ticked yet - 5 available
See real GCSE Statistics past-paper questions, with official mark schemes
This topic in real past papers
We have tagged some boards' past papers question by question (not every board or year yet). This topic comes up in:
- AQA GCSE Statistics past papers: 4 questions across 4 papers, latest tagged June 2023
- Edexcel GCSE Statistics past papers: 3 questions across 3 papers, latest tagged June 2022
Free printable worksheet
Want more practice on paper? Download the Time Series and Moving Averages worksheet pack - 40 pages of exam-style questions with a full mark scheme. Free to download, no card or account. Print it for personal and classroom use.
This topic is chapter 11 of GCSE Statistics Foundation Essentials 2 and chapter 14 of GCSE Statistics Higher Essentials 2, the whole course as one free printable PDF. Its worksheet is also chapter 3 of GCSE Statistics Foundation Topic Workbook 5 and chapter 6 of GCSE Statistics Higher Topic Workbook 6, free printable practice books.
Other versions of this worksheet: