Lesson 5: Deseasonalising data
Did sales really rise? Comparing quarters with deseasonalised values
SkillDeseasonalising data
Worked example
A hardware store in Mackay has seasonal indices of 0.94 for Q3 and 1.12 for Q4. Its sales were $386 000 in Q3 and $455 000 in Q4.
a) The owner says Q4 was a much better quarter than Q3. Use deseasonalised sales to evaluate this claim.
b) What Q4 sales would have been needed for deseasonalised sales to equal those of Q3?
Step 1: Deseasonalise Q3
Step 2: Deseasonalise Q4
Step 3: Evaluate the claim
Actual sales rose by $69 000, but deseasonalised sales fell by about $4400. Q4 is always a busier quarter (index 1.12), and the rise was smaller than the usual seasonal increase. The claim is not supported: allowing for the season, Q4 was slightly weaker than Q3.
Deseasonalised values compare each quarter with what that quarter normally does.
Step 4: Reverse the process
To put the seasonal effect back, multiply by the index.
Answer
a) Deseasonalised sales were about $410 600 in Q3 and $406 300 in Q4, so after allowing for the season Q4 was slightly worse, not better. b) About $459 900.
Try a similar one
A fresh question of the same kind, checked as you answer, with hints and a full solution.
Method
Deseasonalise both quarters before comparing them.
Compare the deseasonalised values and state the conclusion in context.
To find an actual value, multiply a deseasonalised value by the index.
Watch out for
Comparing actual values of different seasons and calling it a real improvement.
In (b), dividing by 1.12 again instead of multiplying.