Consider the following data:
| Year | 2012 | 2013 | 2014 | 2015 | 2016 |
| Sales (in Rs. crores) | 8 | 10 | 7 | 9 | 12 |
The equation of the straight line trend by the method of least squares is:
Answer & explanation
Correct answer: option 3
The correct answer is Option (3) → \(y=9.2+0.7x\)
There are 5 years (an odd number), so the usual choice is to take the middle year 2014 as origin, x = year − 2014. Then x = −2, −1, 0, 1, 2 and \(\sum x = 0\).
The sums needed:
\(\sum y = 8 + 10 + 7 + 9 + 12 = 46\)
\(\sum xy = -16 - 10 + 0 + 9 + 24 = 7\)
\(\sum x^2 = 4 + 1 + 0 + 1 + 4 = 10\)
With \(\sum x = 0\) the normal equations give:
\( \displaystyle a = \frac{\sum y}{n} = \frac{46}{5} = 9.2 \)
\( \displaystyle b = \frac{\sum xy}{\sum x^2} = \frac{7}{10} = 0.7 \)
So the trend line is y = 9.2 + 0.7x, with origin 2014 and x in years. The slope 0.7 does not depend on the origin chosen, and only Option (3) has it.