Lesson 4: Seasonal indices by the average percentage method

Seasonal indices by the average percentage method

SkillSeasonal indices

Worked example

  • Complex familiar
  • Technology active

Quarterly guest nights (thousands) at a Sunshine Coast holiday park are shown. Data are illustrative.

YearQ1Q2Q3Q4
202238212932
202341233135
202444243438

Use the average percentage method to calculate the seasonal index for each quarter, correct to three decimal places.

1 of 4 steps
  1. Step 1: Find each yearly mean

    2022: 38+21+29+324=30\frac{38 + 21 + 29 + 32}{4} = 30. 2023: 1304=32.5\frac{130}{4} = 32.5. 2024: 1404=35\frac{140}{4} = 35.

Try a similar one

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

Method

  1. Find the mean of each complete year.

  2. Express every value as a percentage of its year's mean.

  3. Average each quarter's percentages and write the result as a decimal.

  4. Check the indices add to the number of seasons.

Watch out for

  • Dividing by the mean of all twelve values instead of each year's own mean.

  • Rounding the percentages to whole numbers before averaging, which can shift the indices in the third decimal place.

Save your progress with a free account