Scribd
Upload
5 views3 pages

Statistics Practical Worksheet

The document outlines practical exercises for calculating seasonal indices using the simple average method for quarterly and monthly data. It also includes tasks for time series analysis, such as calculating moving averages and fitting a straight line trend using the least squares method. The exercises involve various datasets related to sales, profit, and production over different years.

Uploaded by

mane982002
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views3 pages

Statistics Practical Worksheet

The document outlines practical exercises for calculating seasonal indices using the simple average method for quarterly and monthly data. It also includes tasks for time series analysis, such as calculating moving averages and fitting a straight line trend using the least squares method. The exercises involve various datasets related to sales, profit, and production over different years.

Uploaded by

mane982002
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

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 |

---

Practical No. 10 - Time Series Analysis

Title: Time Series (Trend by moving average & least square method, seasonal indices by simple average method)
Class: [Link].-I

Department: Statistics

Roll No.: _______

Date: _______

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 |

You might also like