Skip to topic
    ← Back to course topics

    E7c — AQA GCSE Statistics

    Test yourself on E7c with AQA GCSE practice questions.

    Start free

    7 days Premium · Then free forever · No card, no charge

    Your focus

    1. 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
    1. 1Day 1-2: Consolidate calculating seasonal variations using the formula Variation = Actual - Trend across past exam tables.
    2. 2Day 3-4: Practice calculating the mean seasonal variation for quarterly and monthly cycles, ensuring correct treatment of signs.
    3. 3Day 5-6: Draw trend lines of best fit through moving average points and practice predicting future values using the additive model.
    4. 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)
    Calculate

    Perform mathematical operations to find a numerical value. Full working must be shown to earn method marks even if the final figure is incorrect.

    Estimate / Predict

    Use the trend line and relevant mean seasonal variation to determine an expected future value, stating units and showing the addition clearly.

    Comment on

    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)
    Pitfall: Forgetting to apply the sign of the mean seasonal variation or miscalculating the trend value at the target period.
    ❌ Weak Answer (Loses Marks):The trend line is at 450 and variation is -30 so the answer is 480.
    Example improved answer:Predicted value = Trend line estimate + Mean seasonal variation = 450 + (-30) = 420 units.
    Examiner Tip: Always read the trend line value accurately at the specified quarter or period, and carefully preserve the positive or negative sign of the mean seasonal variation when adding it to the trend value.
    Pitfall: Failing to evaluate the reliability of an extrapolated forecast in contextual evaluation questions.
    ❌ Weak Answer (Loses Marks):The prediction is reliable because we used the formula.
    Example improved answer:The prediction is only an estimate and assumes the past linear trend and seasonal patterns continue unchanged. Furthermore, predicting too far into the future (extrapolation) reduces reliability due to unforeseen external economic and environmental factors.
    Examiner Tip: When asked to comment on the reliability of a forecast, state two distinct points: whether the prediction relies on extrapolation and whether seasonal patterns can realistically be assumed to remain constant.
    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. 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. 2.Step 2: Identify the predicted trend line value for the target time period from the question: Trend = 185.
    3. 3.Step 3: Apply the forecasting formula: Predicted Value = Trend Value + Mean Seasonal Variation = 185 + (+26) = 211.
    4. 4.Step 4: Include context and correct units: 211 thousand coats (or 211,000 coats).
    Final Answer: The predicted sales for Quarter 1 of 2025 are 211,000 coats (or 211 thousand 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. 1.Step 1: Use the additive model formula to find the seasonal variation: Seasonal Variation = Actual Value - Trend Value.
    2. 2.Step 2: Calculate variation for Q4 2024: 310 - 345 = -35.
    3. 3.Step 3: For part (b), apply the forecasting formula: Forecast = Trend Value + Mean Seasonal Variation.
    4. 4.Step 4: Calculate the forecast for Q4 2025: 360 + (-32) = 328 guests.
    Final Answer: (a) Seasonal variation = -35; (b) Forecast for Quarter 4 2025 = 328 guests.
    Active Recall Memory Test
    What is the formula to calculate seasonal variation for a given time period?
    Key Fact: Seasonal Variation = Actual Value - Trend Value (Moving Average).
    How do you calculate a predicted future value using the additive time series model?
    Key Fact: Predicted Value = Estimated Trend Value (from trend line) + Mean Seasonal Variation.
    What should the sum of all mean seasonal variations in a complete cycle roughly equal?
    Key Fact: The sum should be approximately zero.
    Why is a forecast made for five years ahead less reliable than one made for next quarter?
    Key Fact: Long-term forecasts involve distant extrapolation, assuming trends and seasonal factors remain unchanged, which is unlikely over extended periods.
    Frequently Asked Questions
    What is the difference between seasonal variation and mean seasonal variation?
    Seasonal variation is the specific deviation of a single observed value from its trend value at one specific point in time (Actual minus Trend). Mean seasonal variation is the average of these individual variations for the same season across several years, smoothing out individual anomalies to represent the typical seasonal effect.
    Why do seasonal variations sometimes sum to a number slightly different from zero?
    In theory, variations around a trend in an additive model balance out to zero. In practice, slight rounding errors in moving averages or small sample sizes over only a few years can cause the sum of the mean seasonal variations to differ slightly from zero.
    How do I read the trend value if there are no moving averages calculated for future periods?
    You must draw a line of best fit through the existing plotted moving average points on your time series graph and extend (extrapolate) this straight line into the future. Then read off the value on the vertical axis corresponding to the target time period on the horizontal axis.
    Can a mean seasonal variation be negative?
    Yes, mean seasonal variations are frequently negative. A negative variation simply indicates that during that particular season (such as ice cream sales in winter), figures are typically below the overall annual average trend.
    What is the additive model vs the multiplicative model in GCSE Statistics?
    In AQA GCSE Statistics, the standard syllabus assesses the additive model, where Actual = Trend + Variation. The multiplicative model expresses variation as a percentage or proportion of the trend (Actual = Trend * Variation factor); at this level, unless specified otherwise, always assume the additive model.