Lesson 7: Forecasting and solving time series problems

Forecast a year of guest nights

SkillForecasting

Worked example

  • Complex familiar

For the holiday park, deseasonalised guest nights=0.556t+28.885\text{deseasonalised guest nights} = 0.556t + 28.885 (thousands, t=1t = 1 is Q1 2022). The seasonal indices are Q1 1.262, Q2 0.698, Q3 0.964 and Q4 1.076.

Forecast the guest nights for each quarter of 2025, in thousands, correct to one decimal place.

1 of 4 steps
  1. Step 1: Find t for each quarter of 2025

    The data ends at Q4 2024, t=12t = 12. So Q1 to Q4 2025 are t=13,14,15,16t = 13, 14, 15, 16.

Try a similar one

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

Method

  1. Find tt for each period to be forecast.

  2. Substitute into the trend line to get the trend (deseasonalised) value.

  3. Multiply by the season's index.

Watch out for

  • Using t=1t = 1 to 44 for 2025, or t=2025t = 2025.

  • Stopping at the trend value (36.1 for Q1) without multiplying by the index.

Save your progress with a free account