ST18: Time Series & Moving Averages
Learn how to identify trends and seasonal variation, calculate 4-point moving averages, determine mean seasonal variation, and make predictions for GCSE Statistics.
Time Series & Moving Averages
Learn how to identify trends and seasonal variation, calculate 4-point moving averages, determine mean seasonal variation, and make predictions for GCSE Statistics.
Key Fact: A time series is a sequence of data values collected at regular time intervals (e.g. monthly sales, quarterly temperatures).
Key Fact: The trend is the long-term general direction of the data, ignoring short-term fluctuations; it can be increasing, decreasing, or stationary.
Key Fact: Seasonal variation is a regular, repeating pattern that occurs at fixed periods within a year (e.g. higher ice cream sales in summer).
Key Fact: Cyclical variation is a longer-term pattern that repeats over more than one year (e.g. economic boom and bust cycles); it is harder to predict than seasonal variation.
Key Fact: A moving average smooths out short-term fluctuations to reveal the underlying trend; it is calculated by averaging overlapping groups of consecutive data values.
Key Fact: A 4-point moving average is used for quarterly data; each average covers four consecutive quarters and is centred between the middle two quarters.
Key Fact: Because a 4-point moving average falls between two time periods, a second set of 2-point moving averages (centred moving averages) is needed to align with actual time periods.
Key Fact: To calculate a centred 4-point moving average: first find the 4-point totals, then find the mean of each pair of consecutive 4-point averages.
Key Fact: The seasonal variation for a quarter = actual value – trend value (from the centred moving average); positive means above trend, negative means below trend.
Key Fact: The mean seasonal variation for each quarter is found by averaging all the seasonal variations for that specific quarter across different years.
Key Fact: To make a prediction: estimate the trend (e.g. by extending the moving average line), then add the appropriate mean seasonal variation for the quarter.
Key Fact: Predictions based on time series assume that past patterns will continue; they become less reliable the further into the future they are made.
📋 Key Vocabulary and Concepts
For Time Series & Moving Averages, you must know:
- Time series: Data collected at regular time intervals, such as monthly or quarterly, which can be analysed for trends and seasonal patterns.
- Trend: The long-term general direction of a time series, found by smoothing out short-term fluctuations using a moving average.
- Seasonal variation: A regular, repeating pattern in a time series that occurs at fixed periods within a year (e.g. higher sales each December).
- Moving average: An average calculated from overlapping groups of consecutive data values, used to smooth out short-term fluctuations and reveal the trend.
- 4-point moving average: A moving average calculated from four consecutive time periods, commonly used for quarterly data; it must be centred to align with time periods.
- Mean seasonal variation: The average of all seasonal variation values for a particular quarter, used to adjust trend-based predictions for seasonal effects.
❓ Practice Questions
Q: What is the purpose of calculating a moving average for a time series?
Q: Why does a 4-point moving average need to be centred?
Q: The actual value for Q3 is 240 and the trend value is 200. What is the seasonal variation for Q3?
Q: The mean seasonal variations are: Q1 = –20, Q2 = +10, Q3 = +40, Q4 = –30. The predicted trend value for Q1 next year is 210. Predict the actual value.
Q: Why might a prediction made using a time series model be unreliable?
✅ Answers
- A moving average smooths out short-term fluctuations and seasonal variation, revealing the underlying long-term trend.
- A 4-point average falls between two time periods (between Q2 and Q3 for quarterly data). Centring aligns the average with an actual time period.
- Seasonal variation = 240 – 200 = +40. This means Q3 values are typically 40 above the trend.
- Predicted value = trend + mean seasonal variation = 210 + (–20) = 190.
- Predictions assume past patterns will continue, but trends may change and seasonal patterns may shift due to external factors, making long-term predictions less reliable.
🎯 Exam Tips
- When calculating a 4-point moving average, always show the 4-point totals and the centring step separately to gain full method marks.
- In exam questions, always calculate the mean seasonal variation for each quarter to 1 decimal place unless told otherwise.
- When predicting future values, state the trend estimate first, then add the mean seasonal variation, and show the calculation clearly.
- Always comment on the reliability of predictions — short-term predictions are more reliable than long-term ones, and they assume patterns continue.
- When describing a time series, use the terms 'increasing trend', 'seasonal variation', and quote specific values from your calculations.
📝 Exam Technique
GCSE Statistics Exam Tips — Time Series & Moving Averages:
1. For Time Series & Moving Averages questions, show every step of your working clearly — method marks count even if the final answer is wrong
2. Check your answer makes sense in context (estimation, units, reasonableness)
3. Use correct mathematical notation and state formulae before substituting values
4. If a Time Series & Moving Averages question asks you to 'prove' or 'show', write a logical chain of reasoning with a conclusion line
5. For problem-solving, identify the topic first, then recall the relevant method
1. For Time Series & Moving Averages questions, show every step of your working clearly — method marks count even if the final answer is wrong
2. Check your answer makes sense in context (estimation, units, reasonableness)
3. Use correct mathematical notation and state formulae before substituting values
4. If a Time Series & Moving Averages question asks you to 'prove' or 'show', write a logical chain of reasoning with a conclusion line
5. For problem-solving, identify the topic first, then recall the relevant method
⚠️ Common Errors
✗ Forgetting to centre a 4-point moving average ✓ A 4-point moving average falls between two time periods; you must calculate a second set of 2-point averages of consecutive 4-point averages to centre them.
✗ Using the seasonal variation instead of the mean seasonal variation for predictions ✓ Use the MEAN seasonal variation (average of all variations for that quarter), not a single year's value, as it is more reliable.
✗ Adding the mean seasonal variation to the wrong trend estimate ✓ Ensure the trend estimate corresponds to the correct quarter before adding the mean seasonal variation for that specific quarter.
✗ Assuming a prediction is certain because it is calculated from a model ✓ All predictions are estimates; state that they assume past trends and seasonal patterns will continue, and that they become less reliable further into the future.
✍️ Model Answer
Full-Mark Response
A shop records its quarterly sales (£thousands) over two years. Calculate the 4-point centred moving averages and the mean seasonal variations. Q1: 12, Q2: 18, Q3: 25, Q4: 15, Q1: 14, Q2: 20, Q3: 27, Q4: 17
Step 1: Calculate 4-point moving totals and averages: Q1–Q4: 12+18+25+15 = 70, average = 17.5 (centred between Q2 and Q3) Q2–Q5: 18+25+15+14 = 72, average = 18.0 Q3–Q6: 25+15+14+20 = 74, average = 18.5 Q4–Q7: 15+14+20+27 = 76, average = 19.0 Q5–Q8: 14+20+27+17 = 78, average = 19.5 Step 2: Centre the averages: Q3 Y1: (17.5+18.0)÷2 = 17.75 Q4 Y1: (18.0+18.5)÷2 = 18.25 Q1 Y2: (18.5+19.0)÷2 = 18.75 Q2 Y2: (19.0+19.5)÷2 = 19.25 Step 3: Calculate seasonal variations (actual – trend): Q3 Y1: 25 – 17.75 = +7.25 Q4 Y1: 15 – 18.25 = –3.25 Q1 Y2: 14 – 18.75 = –4.75 Q2 Y2: 20 – 19.25 = +0.75 Step 4: Mean seasonal variations (average same quarters — only one year of centred data here, so use available values): Q1: –4.75, Q2: +0.75, Q3: +7.25, Q4: –3.25 These show Q3 is the peak season (sales £7,250 above trend) and Q1 is the low season (£4,750 below trend).
📊 AO Deep Dive
Assessment Objective Analysis
AO1 (Knowledge & Understanding): Demonstrate knowledge and understanding of time series & moving averages, including data collection, presentation and calculation techniques relevant to Edexcel 1ST0 & AQA 8382.
AO2 (Application): Apply knowledge and understanding of time series & moving averages to interpret data, reason statistically and draw conclusions in context.
AO3 (Evaluation): Evaluate statistical methods and conclusions, assessing appropriateness, reliability, validity and bias through the statistical enquiry cycle.
📝 Exam Questions by Topic
- AQA Past Papers - Topic Questions -- AQA
- Edexcel Past Papers - Topic Questions -- Edexcel
- CCEA Past Papers - Topic Questions -- CCEA
🎬 Video Resources
Ready to ace your GCSE Statistics exams?
Get the best revision books and guides to boost your grades.