In: Statistics and Probability
The U.S. Department of Commerce publishes data on industrial machinery and equipment. Shown here are the shipments (in $ billions) of industrial machinery and equipment from the first quarter of year 1 through the fourth quarter of year 6. Use these data and the seasonal indexes below to deseasonalize the data.
Time Period |
Industrial Machinery and Equipment Shipments |
1st quarter (year 1) | 54.019 |
2nd quarter | 56.495 |
3rd quarter | 50.169 |
4th quarter | 52.891 |
1st quarter (year 2) | 51.915 |
2nd quarter | 55.101 |
3rd quarter | 53.419 |
4th quarter | 57.236 |
1st quarter (year 3) | 57.063 |
2nd quarter | 62.488 |
3rd quarter | 60.373 |
4th quarter | 63.334 |
1st quarter (year 4) | 62.723 |
2nd quarter | 68.380 |
3rd quarter | 63.256 |
4th quarter | 66.446 |
1st quarter (year 5) | 65.445 |
2nd quarter | 68.011 |
3rd quarter | 63.245 |
4th quarter | 66.872 |
1st quarter (year 6) | 59.714 |
2nd quarter | 63.590 |
3rd quarter | 58.088 |
4th quarter | 61.443 |
Quarter | Index |
1 | 98.07 |
2 | 103.84 |
3 | 97.04 |
4 | 101.05 |
Give the answer for quarter 1 year 5. (Rounded to three decimal places.)
1st Quarter (year 5)=
The Seasonal Index given are wrong.
See below the correct Seasonal Index (S.I).
Actual = actual shipment values
avg.S.I. = average of Seasonal indices for i th quarter
( i = 1,2,3,4)
1st Quarter (year 5) = 67.205