Answer: Take \(X = -3, -2, -1, 0, 1, 2, 3\) for 2017 to 2023, so \(\sum X = 0\).
\(Xy\): \(-117, -88, -43, 0, 49, 112, 171\); \(X^{2}\): 9, 4, 1, 0, 1, 4, 9.
\(\sum y = 336\), \(\sum Xy = 84\), \(\sum X^{2} = 28\), \(n = 7\).
\(a = \dfrac{\sum y}{n} = \dfrac{336}{7} = 48\); \(b = \dfrac{\sum Xy}{\sum X^{2}} = \dfrac{84}{28} = 3\).
Trend: \(y = 48 + 3X\) (origin 2020, \(X\) in years, \(y\) in thousand litres).
Trend values: 2017: 39, 2018: 42, 2019: 45, 2020: 48, 2021: 51, 2022: 54, 2023: 57.
For 2026, \(X = 6\): \(y = 48 + 18 = 66\) thousand litres.
How marks are given
- 1 mark: \(X\) values and \(\sum y = 336\), \(\sum Xy = 84\), \(\sum X^{2} = 28\)
- 1 mark: \(a = 48\)
- 1 mark: \(b = 3\), giving \(y = 48 + 3X\)
- 1 mark: trend values 39, 42, 45, 48, 51, 54, 57
- 1 mark: estimate for 2026 of 66 thousand litres