Skip to content
Examples 6.9.2(i) · Example 9
Q.

Calculate the 3-year moving averages for the loans (In lakh ₹) issued by co-operative banks for farmers in different states of India based on the values given below.

Year200620072008200920102011201220132014
Loan amount (In lakh ₹)41.8540.238.1226.555.523.628.3633.3141.1
Sikkim CbseNCERTSubjective· 3mImportance★★★★★
63% · 25/40 Questions
✓ Free question

Slide a 3-year window, total it, divide by 3, and place the result against the middle year — the end years 2006 and 2014 get no moving average.

3-year MA at year t=yt−1+yt+yt+13\text{3-year MA at year }t=\frac{y_{t-1}+y_t+y_{t+1}}{3}

where yty_t is the loan amount (lakh ₹) in year tt.

  1. Form the 3-year moving totals and averages (each centred on the middle year).
YearLoan (lakh ₹)3-year moving total3-year moving average
200641.85——
200740.2041.85+40.20+38.12=120.1741.85+40.20+38.12=120.17120.17/3=40.06120.17/3=40.06
200838.1240.20+38.12+26.50=104.8240.20+38.12+26.50=104.82104.82/3=34.94104.82/3=34.94
200926.5038.12+26.50+55.50=120.1238.12+26.50+55.50=120.12120.12/3=40.04120.12/3=40.04
201055.5026.50+55.50+23.60=105.6026.50+55.50+23.60=105.60105.60/3=35.20105.60/3=35.20
201123.6055.50+23.60+28.36=107.4655.50+23.60+28.36=107.46107.46/3=35.82107.46/3=35.82
201228.3623.60+28.36+33.31=85.2723.60+28.36+33.31=85.2785.27/3=28.4285.27/3=28.42
201333.3128.36+33.31+41.10=102.7728.36+33.31+41.10=102.77102.77/3=34.26102.77/3=34.26
201441.10——
  1. Note: because a 3-year window needs one year on each side, the first (2006) and last (2014) years cannot be given a moving average. The smoothed series 40.06, 34.94, 40.04, 35.20, 35.82, 28.42, 34.26 shows the underlying trend with the year-to-year fluctuations ironed out.
✓Final answer

3-year moving averages (lakh ₹): 2007 = 40.06, 2008 = 34.94, 2009 = 40.04, 2010 = 35.20, 2011 = 35.82, 2012 = 28.42, 2013 = 34.26.

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.