Statistics Practical Worksheet
Practical No. 1 - Seasonal Indices by Simple Average Method
Q.5. Use the simple average method to compute seasonal indices for the given data:
Quarter 1980 1981 1982 1983 1984 1985
I 3.5 3.5 3.5 4.0 4.1 4.2
II 3.9 4.1 3.9 4.6 4.4 4.6
III 3.4 3.7 3.7 3.8 4.2 4.3
IV 3.6 4.8 4.0 4.5 4.5 4.7
Q.6. Obtain the monthly indices for the following data on production of commodity by simple average method:
Month 2000 2001 2002
January 16 19 20
February 15 18 19
March 14 17 18
April 18 20 20
May 19 20 19
June 19 19 21
July 20 21 20
August 20 21 20
September 15 17 14
October 14 16 14
November 16 17 15
December 19 18 19
Statistics Practical Worksheet
Practical No. 10 - Time Series Analysis
Q.1. Calculate i) Three yearly moving averages, ii) Five yearly moving averages And plot trend values on
same graph for the given data:
Year (X) 1 2 3 4 5 6 7 8 9 10
Sales (Y) 10 10 12 10 15 20 22 20 23 22
Q.2. Calculate Four yearly centered moving averages for the given data:
Week (X) 1 2 3 4 5 6 7 8 9 10 11 12
Profit (Y) 52 73 75 74 73 72 76 80 75 76 76 72
Q.3. Fit a straight line trend by method of least square and obtain trend values:
Year (X) 1985 1987 1989 1991 1993
Production (Y) 18 20 23 27 16
Estimate the production in 1990. Also plot the trend values and actual values on the same graph.
Q.4. The following data reveals the sterling assets of the Reserve Bank of India (in Crores of Rs.). Fit a
straight line trend by least square method and estimate the figure in 1976:
Year (X) 1966 1967 1968 1969 1970 1971
Assets (Y) 83 92 71 90 160 191