Topic 1: Time series analysis - how do we describe patterns over time and smooth out short-term fluctuation?
Construct and interpret time series plots, identify trend, seasonality, cyclical and irregular variation, smooth a series using moving averages, calculate and apply seasonal indices to deseasonalise data, and fit a trend line to forecast future values
A focused answer to the QCE General Mathematics Unit 3 dot point on time series. Covers time series plots, the four components of variation, moving-average smoothing including centred averages, seasonal indices and deseasonalising, and fitting a trend line to forecast, with arithmetic-verified worked examples for IA2 and the external assessment.
Reviewed by: AI editorial process; not yet individually human-reviewed
Have a quick question? Jump to the Q&A page
What this dot point is asking
QCAA wants you to handle data collected over time: plot it, name the patterns you see, smooth out the noise, remove the seasonal swing, and then forecast. Time series is the second half of Unit 3 Topic 1. It rewards careful, methodical arithmetic rather than clever insight, which makes it reliable marks in IA2 and the external assessment if you keep your steps tidy.
The answer
The time series plot and its components
A time series plot graphs the variable against time, with consecutive points joined by line segments. You describe the behaviour using four components.
- Trend. The long-term upward or downward movement.
- Seasonality. A pattern that repeats over a fixed, known period (for example every four quarters or every twelve months).
- Cyclical variation. Longer-term rises and falls with no fixed period (for example a business cycle).
- Irregular (random) variation. Unpredictable short-term fluctuation left over once the other components are accounted for.
Smoothing with moving averages
A moving average replaces each value with the average of itself and its neighbours, smoothing out irregular variation to reveal the trend. For an odd number of points (for example a -point or -point moving average) the smoothed value lines up directly with the middle time period.
For an even number of points (a -point moving average for quarterly data) the average falls between two periods, so you apply centring: take a further -point average of consecutive moving averages to realign the smoothed value with an actual time period.
Seasonal indices and deseasonalising
A seasonal index measures how a particular season compares with the average season. An index of means that season runs percent above the yearly average; an index of means percent below. The seasonal indices for one full cycle always add to the number of seasons (so four quarterly indices sum to ).
To deseasonalise a value, divide by its seasonal index:
To reseasonalise (turn a trend forecast back into an actual forecast), multiply by the seasonal index.
Fitting a trend line and forecasting
Once the series is deseasonalised, fit a least-squares trend line of deseasonalised value against the time period number . To forecast a future actual value:
- Substitute the future into the trend line to get a deseasonalised forecast.
- Multiply by that season's seasonal index to reseasonalise.
This produces a forecast that carries both the underlying trend and the expected seasonal swing.
Exam-style practice questions
Practice questions written in the style of QCAA exam questions on this dot point, with worked answer explainers. The year tag is the paper they imitate, not the source.
2022 QCAA4 marksThe graph shows the amount of rainfall (in mm) for each quarter from 2016 to 2021. a) Describe the long-term trend and seasonality of the time series data. [2 marks] b) A least-squares line was fitted to the data, with y representing the amount of rainfall and x the number of quarters since the beginning of 2016 (e.g. x = 5 for the first quarter of 2017). y = 1.763x + 156.5. Interpret the y-intercept and slope of the fitted line. [2 marks]Show worked answer →
Four marks, one per required statement.
a) Trend (1 mark): the long-term trend is positive, because the amount of rainfall generally increases as time increases. Seasonality (1 mark): the data is seasonal, with a regular peak in the 4th quarter of every year.
b) y-intercept (1 mark): when x = 0 the model gives y = 156.5, so it predicts about 156.5 mm of rainfall in the 4th quarter of 2015 (the quarter just before x = 1). Slope (1 mark): the slope 1.763 means that, on average, rainfall increased by about 1.763 mm per quarter.
Markers want the trend and the seasonality named separately, and both the intercept and slope interpreted in context (mm and quarters), not just restated as numbers.
2022 QCAA4 marksThe table shows a swimwear company's seasonally adjusted swimsuit sales (in thousands): Spring 33.3, Summer 34.8, Autumn 36.4, Winter 35.8. The long-term seasonal indices for spring, summer and winter are 1.11, 1.42 and 0.62 respectively. Determine the actual swimsuit sales for autumn.Show worked answer →
Step 1 - find autumn's seasonal index (1 mark). The four seasonal indices must sum to 4 (one per season per cycle), so autumn's index is 4 - (1.11 + 1.42 + 0.62) = 4 - 3.15 = 0.85.
Step 2 - choose the method (1 mark). The figures given are seasonally adjusted (deseasonalised) values, so to recover the actual value you multiply by the seasonal index: actual = deseasonalised value x seasonal index.
Step 3 - compute (1 mark): actual = 36.4 x 0.85 = 30.94 (thousand).
Step 4 - state in context (1 mark): autumn had actual sales of about 30 940 swimsuits.
The common trap is dividing instead of multiplying. You divide to deseasonalise an actual figure; here the figure is already deseasonalised, so you multiply.
2023 QCAA4 marksBuffalo fly bites cause skin wounds on cattle. The table shows the average number of skin wounds per animal in a herd for two years. 2021: Autumn 285, Winter 28, Spring 195, Summer 460. 2022: Autumn 276, Winter 22, Spring 170, Summer 392. Deseasonalise the data.Show worked answer →
Step 1 - seasonal averages (1 mark). With two years of data, average each season across both years: Autumn (285 + 276)/2 = 280.5, Winter (28 + 22)/2 = 25, Spring (195 + 170)/2 = 182.5, Summer (460 + 392)/2 = 426. The grand mean is (280.5 + 25 + 182.5 + 426)/4 = 228.5.
Step 2 - seasonal indices (1 mark): index = season average / grand mean. Autumn 280.5/228.5 = 1.228, Winter 25/228.5 = 0.109, Spring 182.5/228.5 = 0.799, Summer 426/228.5 = 1.864 (these sum to 4).
Step 3 - deseasonalise 2021 (1 mark): deseasonalised value = actual / seasonal index. Autumn 285/1.228 = 232.2, Winter 28/0.109 = 255.9, Spring 195/0.799 = 244.2, Summer 460/1.864 = 246.7.
Step 4 - deseasonalise 2022 (1 mark): Autumn 276/1.228 = 224.8, Winter 22/0.109 = 201.1, Spring 170/0.799 = 212.8, Summer 392/1.864 = 210.3.
The deseasonalised series is far flatter than the raw data, which is the whole point of removing the seasonal swing.