Consider the following data of expenses (in lakhs) of an organization year wise
Year 2001 2002 2003 2004 2005 Expenses (Rs. lakh) 160 185 220 300 510
Then expected expenses trends for the year 2006 using method of least square is:
Consider the following data of expenses (in lakhs) of an organization year wise
| Year | 2001 | 2002 | 2003 | 2004 | 2005 |
|---|---|---|---|---|---|
| Expenses (Rs. lakh) | 160 | 185 | 220 | 300 | 510 |
Then expected expenses trends for the year 2006 using method of least square is:
Solution
✅ Correct Option: 4
To find the trend line that best fits the expense data, the years are coded to simplify calculations. Using 2003 as the middle year (coded as 0), the coding is: -2, -1, 0, 1, 2.
| Year | X (Coded) | Y (Expenses in lakhs) | XY | X² |
|---|---|---|---|---|
| 2001 | -2 | 160 | -320 | 4 |
| 2002 | -1 | 185 | -185 | 1 |
| 2003 | 0 | 220 | 0 | 0 |
| 2004 | 1 | 300 | 300 | 1 |
| 2005 | 2 | 510 | 1020 | 4 |
The trend line equation is where:
Therefore, the trend line equation is:
For the year 2006, continuing the coding pattern gives .
The expected expenses for 2006 is Rs. 519.5 lakh.
Related questions:
2025: 13 May Shift 1
2025: 2 June Shift 1