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 >1> 1: the season is typically above average (1.15 means 15% above);
  • index <1< 1: typically below average (0.85 means 15% below);
  • index =1= 1: 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

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

  2. Write each value as a percentage of its year's mean

    percentage=valuemean for that year×100%\text{percentage} = \dfrac{\text{value}}{\text{mean for that year}} \times 100\%

  3. Average the percentages for each season

    Take all the Q1 percentages and find their mean, then all the Q2 percentages, and so on.

  4. 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).

Step 1: the holiday-park data (thousands of guest nights) and the mean of each year.
YearQ1Q2Q3Q4Yearly mean
2022382129321204=30\frac{120}{4} = 30
2023412331351304=32.5\frac{130}{4} = 32.5
2024442434381404=35\frac{140}{4} = 35
Steps 2 to 4: each value as a percentage of its year's mean, then the mean of each column.
YearQ1Q2Q3Q4
20223830×100=126.67%\frac{38}{30} \times 100 = 126.67\%70.00%96.67%106.67%
20234132.5×100=126.15%\frac{41}{32.5} \times 100 = 126.15\%70.77%95.38%107.69%
20244435×100=125.71%\frac{44}{35} \times 100 = 125.71\%68.57%97.14%108.57%
Mean126.18%69.78%96.40%107.64%
Seasonal index1.2620.6980.9641.076

Check: 1.262+0.698+0.964+1.076=4.0001.262 + 0.698 + 0.964 + 1.076 = 4.000. 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.

in \%

Round to 2 decimal places.

Interactive

Seasonal indices for the holiday park

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

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

4 steps

Try it yourself first, then check the working one step at a time.

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.

With a spreadsheet: one row per year (rows 2–4) and one column per quarter (B–E). Fill each formula across and down.
CellsFormulaWhat 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*100Each value as a percentage of its year's mean. The $ keeps column F fixed.
B10 (fill across to E10)=AVERAGE(B7:B9)/100The 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

  • Simple familiar

A Cairns reef-tour operator calculates these seasonal indices for its passenger numbers:

QuarterQ1Q2Q3Q4
Seasonal index0.780.961.21

a) Find the seasonal index for Q4.

b) Interpret the seasonal indices for Q1 and Q3.

3 steps

Try it yourself first, then check the working one step at a time.

Method

  1. The indices add to the number of seasons: subtract the known ones from it.

  2. Index −1- 1 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?

Choose one answer

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. 3830×100=126.67%\frac{38}{30} \times 100 = 126.67\% and 126.67+126.15+125.713=126.18%\frac{126.67 + 126.15 + 125.71}{3} = 126.18\%, so the Q1 index is 1.2621.262. 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.

Lesson 4 of 70% read

Save your progress with a free account