The accompanying data file contains monthly observations for 5years.
a. Calculate the 12-month centered movingaverage. (Do not round intermediate calculations. Roundyour answers to 2 decimal places.)
b. Calculate the ratio-to-moving average.(Do not round intermediatecalculations.Round your answers to 2 decimalplaces.)
| Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | CMA:ybar | Rate- to moving Average:y/ybar |
|---|
| 1 | 28 | 30 | 19 | 10 | 28 | 10 | 39 | 31 | 26 | 28 | 18 | 22 | | |
| 2 | 20 | 21 | 39 | 24 | 34 | 39 | 13 | 32 | 16 | 31 | 13 | 12 | | |
| 3 | 20 | 11 | 37 | 38 | 25 | 37 | 13 | 30 | 28 | 37 | 13 | 20 | | |
| 4 | 29 | 33 | 25 | 11 | 21 | 38 | 28 | 12 | 23 | 12 | 13 | 33 | | |
| 5 | 20 | 29 | 12 | 18 | 25 | 34 | 37 | 23 | 17 | 14 | 15 | 17 | | |
c-1. Calculate the seasonal indices for Apriland November. (Do not round intermediatecalculations.Round your answers to 4 decimalplaces.)
| Adjusted Seasonal Index |
|---|
| April | |
| November | |
c-2. Interpret the seasonal index for April.(Do not round intermediatecalculations.Round your answer to 2 decimalplaces.)
The Series is __________% above or below??? its average monthlylevel.
c-3. Interpret the seasonal index for November.(Do not round intermediate calculations.Round your answer to 2 decimal places.)
The series is __________% above or below??? its average monthlylevel.
