Lesson 5: Deseasonalising data

Deseasonalise a year of guest nights

SkillDeseasonalising data

Worked example

  • Simple familiar

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?

1 of 3 steps
  1. Step 1: Divide each value by its own quarter's index

    Q1: 411.262=32.49\frac{41}{1.262} = 32.49 Q2: 230.698=32.95\frac{23}{0.698} = 32.95

    Q3: 310.964=32.16\frac{31}{0.964} = 32.16 Q4: 351.076=32.53\frac{35}{1.076} = 32.53

    32.49, 32.95, 32.16, 32.5332.49,\ 32.95,\ 32.16,\ 32.53

Try a similar one

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

Method

  1. Divide each actual value by the seasonal index of its season.

  2. Check that peak seasons came down and quiet seasons went up.

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

Save your progress with a free account