Lesson 5: Deseasonalising data
Deseasonalise a year of guest nights
SkillDeseasonalising data
Worked example
The holiday park's seasonal indices are Q1 1.262, Q2 0.698, Q3 0.964 and Q4 1.076. In 2023 it sold 41, 23, 31 and 35 thousand guest nights in Q1 to Q4.
a) Deseasonalise the 2023 values, correct to two decimal places.
b) What do the deseasonalised values show that the actual values don't?
Step 1: Divide each value by its own quarter's index
Q1: Q2:
Q3: Q4:
Step 2: Check the direction
Q1 and Q4 (indices above 1) came down; Q2 and Q3 (below 1) went up. ✓
A quick sense check that you divided rather than multiplied.
Step 3: Interpret
The actual values swing from 23 to 41 thousand, but the deseasonalised values are all close to 32.5 thousand. Almost all the swing is the usual seasonal pattern. Relative to a typical year, Q2 was the strongest quarter of 2023 and Q3 the weakest.
Answer
a) 32.49, 32.95, 32.16, 32.53 thousand. b) Once the seasonal effect is removed, business was steady at about 32.5 thousand guest nights a quarter throughout 2023; Q2 was relatively the best quarter, even though it had the fewest actual guest nights.
Try a similar one
A fresh question of the same kind, checked as you answer, with hints and a full solution.
Method
Divide each actual value by the seasonal index of its season.
Check that peak seasons came down and quiet seasons went up.
Compare deseasonalised values to judge underlying performance.
Watch out for
Multiplying by the index instead of dividing.
Using the wrong season's index for a value.