Lesson 7 of 7 · 20 min
Forecasting and solving time series problems
Forecast future values by extending the trend line and re-seasonalising with the seasonal index, judge how reliable a forecast is, and carry out a full time series analysis.
What you will be able to do
- Forecast a future value: find its , substitute into the trend line, then multiply by the seasonal index.
- Judge the reliability of a forecast: extrapolation, strength of the trend, and whether the pattern will continue.
- Carry out a full time series analysis to answer a practical question.
The holiday-park manager now has everything she needs: seasonal indices for each quarter and a trend line for the deseasonalised guest nights. To forecast next summer she runs the analysis backwards. The trend line says what an average quarter will look like then; the seasonal index turns that into the quarter she actually cares about.
Forecasting from a trend line
Find t for the period you want
If is Q1 2022, then Q1 2025 is .
Substitute into the trend line
Deseasonalised guest nights thousand. This is the trend value: a deseasonalised forecast.
Re-seasonalise
Forecast trend value seasonal index thousand.
Answer in context
About 45 600 guest nights are forecast for Q1 2025.
The dashed line extends the trend; the hollow points are the re-seasonalised forecasts. Change the horizon to forecast further ahead — and ask yourself how much you would trust the last one.
Worked example
Forecast a year of guest nights
For the holiday park, (thousands, 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.
Step 1: Find t for each quarter of 2025
The data ends at Q4 2024, . So Q1 to Q4 2025 are .
Step 2: Find the trend values
:
: : :
These are deseasonalised forecasts — what an average quarter would be at each time.
Step 3: Re-seasonalise
Q1: Q2:
Q3: Q4:
Step 4: Comment on reliability
These are extrapolations of up to four quarters beyond the data. The trend is strong () and the seasonal pattern has been very stable, so they are reasonably reliable — provided nothing unusual (a cyclone, a new competitor) happens.
Try it yourself first, then check the working one step at a time.
Answer
Forecasts for 2025: Q1 45.6, Q2 25.6, Q3 35.9 and Q4 40.7 thousand guest nights.
Method
Find for each period to be forecast.
Substitute into the trend line to get the trend (deseasonalised) value.
Multiply by the season's index.
Watch out for
Using to for 2025, or .
Stopping at the trend value (36.1 for Q1) without multiplying by the index.
Using (thousands, is Q1 2022) and the Q2 seasonal index 0.698, forecast the number of guest nights in Q2 2025, in thousands, correct to one decimal place.
Key idea
How reliable is a forecast?
A forecast is always an extrapolation: it assumes the trend and the seasonal pattern carry on beyond the data. Judge it on three things:
- How far ahead? One or two periods past the data is far more reliable than five years.
- How strong is the trend? A trend line with close to (fitted to the deseasonalised values) and small irregular fluctuations gives more reliable forecasts.
- Will the pattern continue? New competition, a pandemic, a price change or a cyclone can break both the trend and the seasonal pattern.
The holiday-park data runs from Q1 2022 to Q4 2024. Which forecast is likely to be the least reliable?
A full time series analysis
Plot and describe
Construct the time series plot. Describe the trend, seasonality and irregular fluctuations in context.
Smooth if it helps
A moving mean or median (odd window) shows the trend through the noise. Use the median if there are outliers.
Seasonal indices
If there is seasonality, calculate the indices by the average percentage method (complete years only) and check their sum.
Deseasonalise
Divide each value by its seasonal index.
Fit the trend line
Least-squares line of deseasonalised value against . Interpret the slope.
Forecast and evaluate
Trend value × seasonal index. Answer the question in context, and comment on reliability.
Worked example
Should the store hire for Christmas? A full time series analysis
A Townsville outdoor and camping store recorded its quarterly sales ($'000). Data are illustrative.
| Year | Q1 | Q2 | Q3 | Q4 |
|---|---|---|---|---|
| 2021 | 113 | 105 | 123 | 164 |
| 2022 | 124 | 113 | 129 | 182 |
| 2023 | 130 | 125 | 141 | 190 |
| 2024 | 142 | 130 | 151 | 206 |
The owner hires an extra full-time staff member for any quarter with forecast sales above $220 000. Should she hire one for Q4 2025? Carry out a time series analysis to decide.
Quarterly sales ($'000), is Q1 2021.
Step 1: Describe the plot
There is an increasing trend, with yearly means of 126.25, 137, 146.5 and 157.25 thousand dollars. There is strong seasonality: a peak every Q4 (Christmas) and the lowest sales every Q2. The irregular fluctuations are small.
Step 2: Seasonal indices (average percentage method)
Each value as a percentage of its yearly mean, e.g. Q4 2021: . With a spreadsheet, the mean percentages give
Q1 0.898, Q2 0.834, Q3 0.960, Q4 1.309 (sum 4.001, allowing for rounding).
The indices are needed twice — to deseasonalise the data and to re-seasonalise the forecast.
Step 3: Deseasonalise
Divide each value by its quarter's index, e.g. Q4 2024: . The deseasonalised values rise steadily from about 126 to 157.
Step 4: Fit the trend line
Least-squares line of deseasonalised sales against ( is Q1 2021): with . Deseasonalised sales are increasing by about $2410 per quarter.
Step 5: Forecast Q4 2025
Q4 2025 is . Trend value: . Forecast: , about $221 800.
Step 6: Decide, and comment on reliability
The forecast is above $220 000, so on this analysis she should hire the extra staff member. But it is only about $1800 (less than 1%) above the threshold, and it is an extrapolation four quarters beyond the data. The trend is strong () and the Christmas peak is very consistent, so the forecast is reasonable — but it is close enough that she should check Q1–Q3 2025 sales before committing.
Try it yourself first, then check the working one step at a time.
Answer
Forecast Q4 2025 sales are about $221 800 (trend , Q4 index 1.309), just above the $220 000 threshold, so the analysis supports hiring — with the caution that the margin is small and the forecast is a four-quarter extrapolation.
Method
Plot and describe the series.
Find seasonal indices by the average percentage method.
Deseasonalise and fit a trend line against .
Forecast (trend value × index), then answer the question with a reliability comment.
Watch out for
Comparing the trend value (169.41) with $220 000 — it must be re-seasonalised first.
Using (Q1 2025) instead of for Q4 2025.
Giving a yes/no answer with no comment on how close the forecast is to the threshold.
Exam tip
Answer the question that was asked
Problem-solving questions end with a decision: should the store hire extra staff, will the dam reach capacity, is the tourism campaign working? Finish with a sentence that answers it directly, using your forecast, and add a reliability comment ("this is an extrapolation four quarters beyond the data, but the trend is strong (), so the forecast is reasonably reliable if conditions don't change").
Common mistake
Forgetting to re-seasonalise
The trend line gives deseasonalised values. A forecast of "36.1 thousand guest nights in Q1 2025" is the trend value, and it is too low for a peak quarter by about 9 thousand. Always multiply by the season's index unless the question asks for the trend (deseasonalised) value.
Summary
Forecast = trend value × seasonal index, where the trend value comes from substituting into the trend line.
Get right: count on from , four per year for quarters, twelve per year for months.
Every forecast is an extrapolation. It is more reliable close to the data, with a strong trend and a stable seasonal pattern.
In a practical problem: plot, describe, find indices, deseasonalise, fit the trend, forecast, then answer the question with a reliability comment.
Finished the lesson?
Try the 2 quick checks above and the lesson completes itself, or mark it complete now.