Lesson 6: Fitting a trend line

Fit a trend line to deseasonalised data

SkillsFitting a trend lineDeseasonalising data

Worked example

  • Complex familiar
  • Technology active

The deseasonalised guest nights (thousands) at the holiday park, from Q1 2022 (t=1t = 1) to Q4 2024 (t=12t = 12), are:

tt123456789101112
Deseasonalised30.1130.0930.0829.7432.4932.9532.1632.5334.8734.3835.2735.32

a) Fit a least-squares trend line to the deseasonalised data, with coefficients correct to three decimal places.

b) Interpret the slope, and comment on the strength of the trend.

1 of 4 steps
  1. Step 1: Enter the data

    tt values in the xx list, deseasonalised values in the yy list.

Try a similar one

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

Method

  1. Deseasonalise first (or use the deseasonalised values given).

  2. Fit the least-squares line of deseasonalised value against tt.

  3. Interpret the slope per period, and use rr to describe the strength of the trend.

Watch out for

  • Fitting the line to the raw guest nights, which gives 0.462t+29.50.462t + 29.5 with r=0.23r = 0.23.

  • Saying "per year" when tt counts quarters.

Save your progress with a free account