Lesson 4 of 7 · 18 min
Seasonal indices by the average percentage method
Measure how much each season sits above or below an average season by calculating seasonal indices with the average percentage method, by hand and with a spreadsheet.
What you will be able to do
- Express each value as a percentage of its year's mean.
- Average the percentages for each season to find its seasonal index.
- Use the fact that the indices add to the number of seasons to check them or find a missing one.
- Interpret a seasonal index in context.
Every Q1, the holiday park is packed with summer-holiday families. But how much busier is Q1 than a typical quarter? The manager needs a number for that: it decides how many extra staff to roster, and it lets her compare a summer quarter fairly with a winter one.
That number is the seasonal index. An index of 1.26 says "this season is typically 26% above an average season"; an index of 0.70 says "30% below".
Definition
Seasonal index
The seasonal index of a season compares it with the average season of its cycle:
- index : the season is typically above average (1.15 means 15% above);
- index : typically below average (0.85 means 15% below);
- index : a typical, average season.
The indices of all the seasons add to the number of seasons: 4 for quarters, 12 for months, 7 for days of the week. (As percentages they add to 400%, 1200%, 700%.)
The average percentage method
Find the mean of each complete year (cycle)
Add the values for the year and divide by the number of seasons. Use only complete years.
Write each value as a percentage of its year's mean
Average the percentages for each season
Take all the Q1 percentages and find their mean, then all the Q2 percentages, and so on.
Write each result as a decimal and check the sum
126.18% becomes an index of 1.262. The indices should add to the number of seasons (allowing for rounding).
| Year | Q1 | Q2 | Q3 | Q4 | Yearly mean |
|---|---|---|---|---|---|
| 2022 | 38 | 21 | 29 | 32 | |
| 2023 | 41 | 23 | 31 | 35 | |
| 2024 | 44 | 24 | 34 | 38 |
| Year | Q1 | Q2 | Q3 | Q4 |
|---|---|---|---|---|
| 2022 | 70.00% | 96.67% | 106.67% | |
| 2023 | 70.77% | 95.38% | 107.69% | |
| 2024 | 68.57% | 97.14% | 108.57% | |
| Mean | 126.18% | 69.78% | 96.40% | 107.64% |
| Seasonal index | 1.262 | 0.698 | 0.964 | 1.076 |
Check: . Q1 guest nights are typically 26.2% above the quarterly average, and Q2 guest nights are typically 30.2% below it.
In 2023 the holiday park sold 41, 23, 31 and 35 thousand guest nights in Q1 to Q4. Express the Q4 value as a percentage of the 2023 yearly mean, correct to two decimal places.
The panel shows each year's mean, each value's percentage and the four indices. Notice how similar each quarter's percentage is from year to year: that consistency is what makes the seasonal pattern predictable.
Worked example
Seasonal indices by the average percentage method
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
✓
Try it yourself first, then check the working one step at a time.
Answer
Seasonal indices: Q1 1.262, Q2 0.698, Q3 0.964, Q4 1.076 (they add to 4).
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.
| Cells | Formula | What it gives |
|---|---|---|
| F2 (fill down to F4) | =AVERAGE(B2:E2) | The mean of each year |
| B7 (fill across to E7 and down to row 9) | =B2/$F2*100 | Each value as a percentage of its year's mean. The $ keeps column F fixed. |
| B10 (fill across to E10) | =AVERAGE(B7:B9)/100 | The seasonal index of each quarter, as a decimal |
| F10 | =SUM(B10:E10) | The check: should be 4 |
Common mistake
Averaging the raw values
It is tempting to average the three Q1 values (38, 41, 44) and divide by the overall mean. Don't. When there is a trend, the later years are bigger in every quarter, and averaging raw values mixes the trend into the seasonal effect. Turning each value into a percentage of its own year's mean first removes the trend year by year — that is the whole point of the average percentage method.
Worked example
Find a missing seasonal index and interpret the indices
A Cairns reef-tour operator calculates these seasonal indices for its passenger numbers:
| Quarter | Q1 | Q2 | Q3 | Q4 |
|---|---|---|---|---|
| Seasonal index | 0.78 | 0.96 | 1.21 |
a) Find the seasonal index for Q4.
b) Interpret the seasonal indices for Q1 and Q3.
Step 1: Use the sum of the indices
For quarterly data the four indices add to 4, because an average quarter has index 1.
Step 2: Interpret Q1
, so Q1 passenger numbers are typically 22% below the quarterly average. Q1 is the tropical wet season.
Step 3: Interpret Q3
, so Q3 passenger numbers are typically 21% above the quarterly average — the dry, mild peak season.
Try it yourself first, then check the working one step at a time.
Answer
a) 1.05. b) Q1 passengers are typically 22% below the quarterly average; Q3 passengers are typically 21% above it.
Method
The indices add to the number of seasons: subtract the known ones from it.
Index gives the percentage above (positive) or below (negative) an average season.
Watch out for
Subtracting from 1 or from 100 instead of from 4.
Saying Q1 is "78% below average". 0.78 means 78% of average, which is 22% below.
The seasonal indices for a Brisbane plant nursery's sales are Q1 0.91, Q2 0.84 and Q3 1.07. Find the seasonal index for Q4.
The seasonal index for Q2 guest nights at the holiday park is 0.698. What does this mean?
Exam tip
Show one of each
When you calculate indices by hand, show one yearly mean, one percentage and one index in full, e.g. and , so the Q1 index is . Then show the sum check. That earns the method marks even if a later value slips.
Summary
A seasonal index compares a season with an average season: above 1 is above average, below 1 is below.
Average percentage method: yearly means → each value as a percentage of its year's mean → average each season's percentages.
Use complete years only.
Indices add to the number of seasons (4, 12, 7). Use this to check them or find a missing one.
Interpret in a sentence: "Q1 is typically 26.2% above the quarterly average."
Finished the lesson?
Try the 3 quick checks above and the lesson completes itself, or mark it complete now.