Skip to content
Question
Q.

(a) Fit a straight line trend by the method of least squares to the following data and find the trend values. | Year | 2010 | 2012 | 2013 | 2014 | 2015 | 2016 | 2019 | |---|---|---|---|---|---|---|---| | Sales (in lakh ₹) | 65 | 68 | 70 | 72 | 75 | 67 | 73 | OR (b) Find the trend values by taking 4-yearly moving averages for the following data. | Year | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | |---|---|---|---|---|---|---|---|---| | Sales (in thousand ₹) | 108 | 112 | 110 | 120 | 140 | 120 | 100 | 135 |

CBSECBSE Class XII Board 2025Subjective· 5mImportance★★★★★
🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

  1. Normal equations 490=7a+b490=7a+b and 108=a+51b108=a+51b solve to b≈0.747, a≈69.89b\approx0.747,\ a\approx69.89; (I flag a small difference from the MS intercept — see note).
  2. Four-yearly moving totals →\to averages →\to centred averages give the trend.

  1. Least-squares line Y=a+bXY=a+bX: ∑Y=na+b∑X\sum Y=na+b\sum X and ∑XY=a∑X+b∑X2\sum XY=a\sum X+b\sum X^{2}.
  2. Centred moving average = average of two successive 44-yearly moving averages (needed because an even period falls between years).

(a) Straight-line trend by least squares

  1. Take origin at 20142014, so X=year−2014X=\text{year}-2014. Build the table:
YearYYXXX2X^2XYXY
201065−4-416−260-260
201268−2-24−136-136
201370−1-11−70-70
201472000
2015751175
20166724134
201973525365
Total∑Y=490\sum Y=490∑X=1\sum X=1∑X2=51\sum X^2=51∑XY=108\sum XY=108
  1. With n=7n=7, the normal equations are 490=7a+b490=7a+b and 108=a+51b108=a+51b.
  2. Solve: from the first, b=490−7ab=490-7a; substitute into the second: a+51(490−7a)=108⇒a+24990−357a=108⇒−356a=−24882⇒a≈69.89a+51(490-7a)=108\Rightarrow a+24990-357a=108\Rightarrow -356a=-24882\Rightarrow a\approx69.89.
  3. Then b=490−7(69.89)=490−489.25≈0.75b=490-7(69.89)=490-489.25\approx0.75 (more precisely b≈0.747b\approx0.747).
  4. Trend line: Y=69.89+0.75XY=69.89+0.75X. Trend values Y=a+bXY=a+bX:
YearXXTrend Y=69.89+0.75XY=69.89+0.75X
2010−4-466.8966.89
2012−2-268.3968.39
2013−1-169.1469.14
2014069.8969.89
2015170.6470.64
2016271.3971.39

Unlock everything free for 14 days

  • Full step-by-step solutions
  • Concept-first explanations
  • Methods, shortcuts & mistakes
  • PYQ mapping + timed mock tests

Full access for 14 days. No credit card required.