Seasonal indices and deseasonalising in WACE Mathematics Applications Unit 4
“Calculate seasonal indices, deseasonalise and reseasonalise a time series, and interpret seasonal indices in context.”
A seasonal index measures how a particular season typically compares with the average: an index of means that season runs above average, means below. Indices for one cycle sum to the number of seasons (so for quarters, for months). Deseasonalise by dividing the actual value by its index; reseasonalise by multiplying. Deseasonalised data lets you compare periods fairly and fit a trend line.
Jump to a section
What this dot point is asking
You must calculate seasonal indices, deseasonalise and reseasonalise, and interpret indices in context.
What a seasonal index is
A seasonal index captures the repeating effect of a season (a quarter, month or day) relative to the average.
A seasonal index of means a season is exactly average. Above means above average (a peak season); below means below average (a quiet season). The indices for one full cycle add to the number of seasons in the cycle.
So four quarterly indices sum to (averaging ), and twelve monthly indices sum to . This summing rule lets you find a missing index.
Interpreting an index
An index minus , as a percentage, is the seasonal effect. An index of means above average; means below average. Always interpret in the context of the data: "December sales are typically above the monthly average".
An index greater than is a high (above-average) season; less than is a low season. The further from , the stronger the seasonal effect. An index of exactly would mean that season is unaffected by seasonality.
Deseasonalising and reseasonalising
Removing the seasonal effect lets you see the underlying trend; restoring it converts a trend forecast back to an actual figure.
Deseasonalised value .
Reseasonalised value deseasonalised value seasonal index.
Dividing strips out the seasonal bump or dip; multiplying puts it back. Deseasonalised data is the right input for fitting a trend line, because the trend line should not be distorted by the seasonal pattern.
Working with seasonal indices
A cafe's quarterly sales have indices Q1 , Q2 , Q3 and an unknown Q4. The actual Q3 sales were .
Step 1: Find the missing seasonal index using the summing rule.
Seasonal indices for a full cycle must sum to the number of seasons in that cycle. For quarterly data the four indices sum to , because their average is (meaning the average quarter is exactly average). Setting up the equation: , so . The Q4 index is .
Step 2: Interpret the Q1 and Q4 indices in context.
An index minus , expressed as a percentage, gives the seasonal effect relative to the average quarter. Q1 index means Q1 sales are typically above the quarterly average, marking Q1 as a peak season for this cafe. Q4 index means Q4 sales are typically below the quarterly average, so Q4 is the cafe's quietest quarter.
Step 3: Deseasonalise the Q3 actual figure.
Deseasonalising removes the seasonal effect so we can compare the underlying level across different quarters. We divide the actual value by the seasonal index for that quarter: deseasonalised Q3 , that is . This figure represents what Q3 would have been if it were a perfectly average quarter, free from the seasonal dip.
Step 4: Reseasonalise a deseasonalised forecast.
A trend line fitted to deseasonalised data gives forecasts without the seasonal pattern, so we must restore that pattern before quoting an actual prediction. If the trend line gives a deseasonalised Q1 forecast of , we multiply by the Q1 index to put the seasonal peak back in: . This is the actual expected sales figure for Q1.
Why deseasonalise
Comparing raw seasonal figures is misleading: a December peak is not "growth", it is the season. Deseasonalising removes that effect so you can judge whether the business is genuinely trending up or down. After fitting a trend line to deseasonalised data and forecasting, you reseasonalise the forecast to predict the actual figure for a specific season.
Calculating seasonal indices from data
When indices are not given, compute them. The standard method: find each value as a proportion of the average for its cycle (or of a centred moving average), then average those proportions for each season across all cycles, and finally scale the averaged figures so they sum to the number of seasons. For instance, if four raw quarterly averages came to and , summing to , multiply each by so the adjusted indices sum to exactly . This final scaling step is where marks are commonly lost, so always confirm the indices total the number of seasons before using them.
- Multiplying when you should divide
- Deseasonalise by dividing by the index; reseasonalise by multiplying. Mixing these reverses the seasonal effect.
- Indices not summing to the number of seasons
- Four quarterly indices sum to , twelve monthly to ; use this to find a missing index.
- Misreading an index as a percentage directly
- An index of is above average, not above; subtract first.
- Fitting a trend line to raw seasonal data
- Deseasonalise first, then fit the trend, then reseasonalise the forecast.
Exam-style questions
Questions in the style of SCSA exam questions on this dot point, each with a worked answer. They are written by ExamExplained unless tagged "Past paper"; the year shows the paper a question is modelled on.
WACE 2022-style6 marksA shop's quarterly sales have seasonal indices: Quarter 1 , Quarter 2 , Quarter 3 , Quarter 4 . (a) Find the missing seasonal index. (b) Interpret the Quarter 2 index. (c) The actual Quarter 1 sales were ; deseasonalise this figure.Show worked answer →
Seasonal indices for four quarters sum to .
(a) , so . Quarter 4 index . (2 marks)
(b) A Quarter 2 index of means Quarter 2 sales are typically above the quarterly average. (2 marks)
(c) Deseasonalised actual divided by the index , that is . (2 marks)
Markers reward indices summing to , the "10% above average" interpretation, and dividing by the index to deseasonalise.
WACE 2024-style5 marksMonthly visitor numbers have a December seasonal index of . (a) Interpret this index. (b) The deseasonalised forecast for next December is visitors. Reseasonalise it to give the actual forecast.Show worked answer →
An index above marks an above-average season.
(a) A December index of means December visitor numbers are typically above the monthly average, a strong peak season. (2 marks)
(b) Reseasonalise by multiplying the deseasonalised value by the index: visitors. (3 marks)
Markers reward the "45% above average" interpretation and multiplying by the index to reseasonalise.