Lesson 6: Fitting a trend line

Fit and interpret a trend line for annual data

SkillFitting a trend line

Worked example

  • Simple familiar
  • Technology active

Mean daily water use per person (litres) in a south-east Queensland town for 2015 to 2024 was

182, 176, 179, 171, 168, 170, 163, 160, 162, 155.

a) Using t=1t = 1 for 2015, use technology to fit a least-squares trend line. Give the coefficients correct to two decimal places.

b) Interpret the slope.

1 of 4 steps
  1. Step 1: Set up the time variable

    Enter t=1,2,…,10t = 1, 2, \ldots, 10 in the xx list (2015 is t=1t = 1, 2024 is t=10t = 10) and the water use 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. Number the periods t=1,2,3,…t = 1, 2, 3, \ldots and say what t=1t = 1 is.

  2. Fit the least-squares line of the variable against tt.

  3. Interpret the slope as the change per period, with units.

Watch out for

  • Using the year as xx, which gives an intercept of about 5774 — correct, but useless.

  • Interpreting the slope without the time unit ("decreases by 2.78") or the direction.

Save your progress with a free account