Lesson 5: Deseasonalising data

Did sales really rise? Comparing quarters with deseasonalised values

SkillDeseasonalising data

Worked example

  • Complex familiar

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?

1 of 4 steps
  1. Step 1: Deseasonalise Q3

    386 0000.94=$410 638\frac{386\,000}{0.94} = \$410\,638

Try a similar one

A fresh question of the same kind, checked as you answer, with hints and a full solution.

Method

  1. Deseasonalise both quarters before comparing them.

  2. Compare the deseasonalised values and state the conclusion in context.

  3. 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.

Save your progress with a free account