Lesson 4: Seasonal indices by the average percentage method
Seasonal indices by the average percentage method
SkillSeasonal indices
Worked example
Quarterly guest nights (thousands) at a Sunshine Coast holiday park are shown. Data are illustrative.
| Year | Q1 | Q2 | Q3 | Q4 |
|---|---|---|---|---|
| 2022 | 38 | 21 | 29 | 32 |
| 2023 | 41 | 23 | 31 | 35 |
| 2024 | 44 | 24 | 34 | 38 |
Use the average percentage method to calculate the seasonal index for each quarter, correct to three decimal places.
Step 1: Find each yearly mean
2022: . 2023: . 2024: .
Step 2: Write each value as a percentage of its yearly mean
2022: , , ,
2023: , , ,
2024: , , ,
Dividing by each year's own mean removes the year-to-year growth (the trend), so only the seasonal effect is left.
Step 3: Average the percentages for each quarter
Q1:
Q2: , Q3: , Q4:
Step 4: Convert to decimals and check the sum
✓
Answer
Seasonal indices: Q1 1.262, Q2 0.698, Q3 0.964, Q4 1.076 (they add to 4).
Try a similar one
A fresh question of the same kind, checked as you answer, with hints and a full solution.
Method
Find the mean of each complete year.
Express every value as a percentage of its year's mean.
Average each quarter's percentages and write the result as a decimal.
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.