Skip to main contentSkip to solution

Data available for profit (₹ Thousands) of a company as

Year2004200520062007200820092010
Profit(₹ 000)114130126144138156164

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):

YearXY (Profit in ₹ 000)
2004-3114
2005-2130
2006-1126
20070144
20081138
20092156
20103164

Centering at 0 makes calculations easier because ΣX=0\Sigma X = 0.


Calculate the required sums:

YearXYXYX²
2004-3114-3429
2005-2130-2604
2006-1126-1261
2007014400
200811381381
200921563124
201031644929
Total097221428

The trend equation is Y=a+bXY = a + bX

Since ΣX=0\Sigma X = 0:

b=ΣXYΣX2b = \dfrac{\Sigma XY}{\Sigma X^2}

b=21428b = \dfrac{214}{28}

b=7.643b = 7.643


Since ΣX=0\Sigma X = 0:

a=ΣYna = \dfrac{\Sigma Y}{n}

a=9727a = \dfrac{972}{7}

a=138.857a = 138.857

Trend Equation: Y=138.857+7.643XY = 138.857 + 7.643X


For year 2007, X=0X = 0:

Y=138.857+7.643(0)Y = 138.857 + 7.643(0)

Y=138.857Y = 138.857

Y≈138.86Y \approx 138.86


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.

Keyboard Shortcuts

  • Left arrow: Previous question
  • Right arrow: Next question
  • S key: Jump to solution
  • Q key: Jump to question