Corporate triple A bond interest rates for 12 consecutive months are as follows:

9.7 9.3 9.3 9.4 9.8 9.7 9.9 10.7 10.1 9.8 9.6 9.8
(b) Develop three-month and four-month moving averages for this time series.
If required, round your answers to two decimal places.

Week
Sales 3 Month
Moving Average 4 Month
Moving Average
1 9.7
2 9.3
3 9.3
4 9.4
5 9.8
6 9.7
7 9.9
8 10.7
9 10.1
10 9.8
11 9.6
12 9.8
Enter the Mean Square Errors for the three-month and the four-month moving average forecasts. If needed, round your answers to three decimal digits.
3-month
moving average 4-month
moving average
MSE
Does the three-month or the four-month moving average provide the better forecasts based on MSE? Explain.
- Select your answer -3-month moving average4-month moving averageItem 22
- Select your answer -Moving average with the lowest MSE provides the better forecast. Moving average with the highest MSE provides the better forecast. Item 23
(c) What is the moving average forecast for the next month?