Consider the following time series data.
Excel File: data17-35.xls
| Quarter | Year 1 | Year 2 | Year 3 |
| 1 | 4 | 6 | 7 |
| 2 | 2 | 3 | 6 |
| 3 | 3 | 5 | 6 |
| 4 | 5 | 7 | 8 |
b. Show the four-quarter and centered movingaverage values for this time series (to 3 decimals ifnecessary).
| Year | Quarter | Time Series Value | Four-Quarter Moving Average | Centered Moving Average |
| 1 | 1 | 4 | | |
| 2 | 2 | | |
| | | 3.25 | |
| 3 | 3 | | ________ |
| | | 4 | |
| 4 | 5 | | _______ |
| | | _________ | |
| 2 | 1 | 6 | | _________ |
| | | 4.75 | |
| 2 | 3 | | 5 |
| | | 5.25 | |
| 3 | 5 | | 5.375 |
| | | 5.5 | |
| 4 | 7 | | _______ |
| | | _______ | |
| 3 | 1 | 7 | | _______ |
| | | _______ | |
| 2 | 6 | | ______ |
| | | ________ | |
| 3 | 6 | | |
| 4 | 8 | | |
c. Compute seasonal indexes and adjustedseasonal indexes for the four quarters (to 3 decimals).
| Quarter | Seasonal
Index | Adjusted
Seasonal
Index |
| 1 | | |
| 2 | | |
| 3 | | |
| 4 | | |
| Total | | |
