Consider the following data :
| Year | 2008 | 2009 | 2010 | 2011 | 2012 |
| Profit (in lakh Rs.) | 10 | 12 | 15 | 20 | 25 |
The best fitted trend line equation by the method of least squares is :
Answer & explanation
Correct answer: option 4
The correct answer is Option (4) → \(y=8.8+3.8x\)
Let x = year − 2008, so x = 0, 1, 2, 3, 4, and fit y = a + bx by the method of least squares, with n = 5:
\(\sum x = 0 + 1 + 2 + 3 + 4 = 10\)
\(\sum y = 10 + 12 + 15 + 20 + 25 = 82\)
\(\sum x^2 = 0 + 1 + 4 + 9 + 16 = 30\)
\(\sum xy = 0 + 12 + 30 + 60 + 100 = 202\)
\( \displaystyle b = \frac{n\sum xy - \sum x \sum y}{n\sum x^2 - \left(\sum x\right)^2} \)
\( \displaystyle = \frac{5 \times 202 - 10 \times 82}{5 \times 30 - 100} = \frac{190}{50} = 3.8 \)
\( \displaystyle a = \frac{\sum y - b\sum x}{n} = \frac{82 - 38}{5} = 8.8 \)
So the trend line is y = 8.8 + 3.8x, with x measured in years from 2008.
The slope 3.8 (the yearly rise in profit) does not depend on which year is taken as the origin: with 2010 as origin the same line reads y = 16.4 + 3.8X. Options (1), (2) and (3) have slopes 16.4, 5.8 and 6.4, so none of them fits these data.