Data available for profit (₹ Thousands) of a company as
Year 2004 2005 2006 2007 2008 2009 2010 Profit(₹ 000) 114 130 126 144 138 156 164
Based on the above data using least square method the trend value for the year '2007' is
Data available for profit (₹ Thousands) of a company as
| Year | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 |
|---|---|---|---|---|---|---|---|
| Profit(₹ 000) | 114 | 130 | 126 | 144 | 138 | 156 | 164 |
Based on the above data using least square method the trend value for the year '2007' is
Solution
✅ Correct Option: 2
For the least squares method, coded values (X) are assigned to years, centered around the middle year (2007 = 0):
| Year | X | Y (Profit in ₹ 000) |
|---|---|---|
| 2004 | -3 | 114 |
| 2005 | -2 | 130 |
| 2006 | -1 | 126 |
| 2007 | 0 | 144 |
| 2008 | 1 | 138 |
| 2009 | 2 | 156 |
| 2010 | 3 | 164 |
Centering at 0 makes calculations easier because .
Calculate the required sums:
| Year | X | Y | XY | X² |
|---|---|---|---|---|
| 2004 | -3 | 114 | -342 | 9 |
| 2005 | -2 | 130 | -260 | 4 |
| 2006 | -1 | 126 | -126 | 1 |
| 2007 | 0 | 144 | 0 | 0 |
| 2008 | 1 | 138 | 138 | 1 |
| 2009 | 2 | 156 | 312 | 4 |
| 2010 | 3 | 164 | 492 | 9 |
| Total | 0 | 972 | 214 | 28 |
The trend equation is
Since :
Since :
Trend Equation:
For year 2007, :
The trend value for the year 2007 is 138.86 (₹ Thousands).
The actual profit in 2007 was 144, but the trend value is 138.86, representing the smoothed pattern based on the overall data.
Related questions:
2025: 19 May Shift 1
2026: 22 May Shift 2
2025: 30 May Shift 1