Lesson 6: Fitting a trend line
Fit and interpret a trend line for annual data
SkillFitting a trend line
Worked example
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 for 2015, use technology to fit a least-squares trend line. Give the coefficients correct to two decimal places.
b) Interpret the slope.
Step 1: Set up the time variable
Enter in the list (2015 is , 2024 is ) and the water use in the list.
Time is the explanatory variable. Numbering periods from 1 keeps the intercept sensible.
Step 2: Run the linear regression
The calculator (or
=SLOPEand=INTERCEPTin a spreadsheet) gives , and .Step 3: Write the trend line
where is 2015.
Step 4: Interpret the slope
Each year, mean daily water use is predicted to decrease by about 2.78 L per person.
Answer
, with in 2015. Water use is decreasing by about 2.78 L per person per day each year (, a strong decreasing trend).
Try a similar one
A fresh question of the same kind, checked as you answer, with hints and a full solution.
Method
Number the periods and say what is.
Fit the least-squares line of the variable against .
Interpret the slope as the change per period, with units.
Watch out for
Using the year as , which gives an intercept of about 5774 — correct, but useless.
Interpreting the slope without the time unit ("decreases by 2.78") or the direction.