E7c — AQA GCSE Statistics
Test yourself on E7c with AQA GCSE practice questions.
7 days Premium · Then free forever · No card, no charge
Your focus
- Use different types of index numbers in context, including but not limited to retail price index, consumer price index and gross domestic product.
E7c exam tips
Quick Revision Summary (Key Takeaway)
AQA GCSE Statistics topic E7c covers seasonal variation and forecasting using time series data and moving averages. Students learn to calculate seasonal variations, determine the mean seasonal variation, and extrapolate the trend line to generate reliable short-term predictions.
Topic Overview
Topic E7c focuses on using time series analysis to identify seasonal variation and generate forecasts for future time periods. By combining moving averages to establish an underlying trend with seasonal components, students learn how cyclical patterns can be quantified and projected.
Mastering this topic is essential for AQA GCSE Statistics as it links graphical data interpretation with practical business and economic modelling. It equips students to evaluate the validity of statistical predictions critically, distinguishing sound short-term interpolation from risky long-term extrapolation.
Key Concepts
- →Additive Time Series Model: Expresses actual values as the sum of the underlying trend and seasonal variation: Actual = Trend + Seasonal Variation.
- →Seasonal Variation: The difference between the actual observation and the corresponding trend value (moving average) at that point in time.
- →Mean Seasonal Variation: The arithmetic mean of all calculated variations for a specific season across multiple cycles.
- →Forecasting: Estimating a future value by extending the linear trend line and adding the relevant mean seasonal variation.
- →Reliability and Extrapolation: Assessing forecast accuracy based on how far ahead the projection is made and whether historical conditions remain constant.
Examiner Tips
- 💡Show all working clearly when calculating the mean seasonal variation; write out the summation and division explicitly to secure method marks.
- 💡When reading trend values off a graph, draw dotted construction lines on the grid to demonstrate your method to the examiner.
- 💡Always check whether the total sum of mean seasonal variations across all seasons in a complete cycle is approximately zero, as this confirms mathematical consistency in an additive model.
Common Mistakes
- Subtracting a negative mean seasonal variation instead of adding it algebraically, resulting in an incorrect sign flip.
- Averaging the raw data values of a season across years instead of averaging the seasonal variations (actual minus trend).
- Assuming that extending a trend line gives a guaranteed exact future value rather than a statistical estimate subject to uncertainty.
Revision Plan
- 1Day 1-2: Consolidate calculating seasonal variations using the formula Variation = Actual - Trend across past exam tables.
- 2Day 3-4: Practice calculating the mean seasonal variation for quarterly and monthly cycles, ensuring correct treatment of signs.
- 3Day 5-6: Draw trend lines of best fit through moving average points and practice predicting future values using the additive model.
- 4Day 7: Work through 4-mark and 6-mark contextual questions focusing on commenting on the reliability and limitations of forecasts.
Exam Question Types
- 📋Calculation of Mean Seasonal Variation: Students are given tables of actual and moving average values and asked to find the average variation for a given quarter or month.
- 📋Graphical Forecasting: Extending a plotted trend line to a future time point and combining it with calculated variation to predict a future figure.
- 📋Evaluative Discussion: Contextual questions asking students to discuss the appropriateness and reliability of forecasts made using extrapolation.
Command Word Expectations (AQA)
Perform mathematical operations to find a numerical value. Full working must be shown to earn method marks even if the final figure is incorrect.
Use the trend line and relevant mean seasonal variation to determine an expected future value, stating units and showing the addition clearly.
Provide an evidence-based interpretation within the given context, considering factors such as sample range, time distance of extrapolation, and external shocks.
How Students Lose Marks (Examiner Pitfalls)
Step-by-Step Worked Solutions
Question: The quarterly sales of coats (in thousands) for an outdoor clothing retailer show a linear trend. For Quarter 1 of 2025, the trend line value is predicted to be 185. The seasonal variations for Quarter 1 over the previous three years are +24, +28, and +26. Calculate the predicted sales for Quarter 1 of 2025.
- 1.Step 1: Calculate the mean seasonal variation for Quarter 1 by finding the arithmetic mean of the given variations: Mean = (24 + 28 + 26) / 3 = 78 / 3 = +26.
- 2.Step 2: Identify the predicted trend line value for the target time period from the question: Trend = 185.
- 3.Step 3: Apply the forecasting formula: Predicted Value = Trend Value + Mean Seasonal Variation = 185 + (+26) = 211.
- 4.Step 4: Include context and correct units: 211 thousand coats (or 211,000 coats).
Question: A hotel records quarterly guest numbers. For Quarter 4 of 2024, the actual guest count was 310 and the corresponding centered moving average trend value was 345. (a) Calculate the seasonal variation for this quarter. (b) If the mean seasonal variation for Quarter 4 is -32 and the trend line estimate for Quarter 4 of 2025 is 360, calculate the forecast for Quarter 4 of 2025.
- 1.Step 1: Use the additive model formula to find the seasonal variation: Seasonal Variation = Actual Value - Trend Value.
- 2.Step 2: Calculate variation for Q4 2024: 310 - 345 = -35.
- 3.Step 3: For part (b), apply the forecasting formula: Forecast = Trend Value + Mean Seasonal Variation.
- 4.Step 4: Calculate the forecast for Q4 2025: 360 + (-32) = 328 guests.