Corporate triple A bond interest rates for 12 consecutive months are as follows: 9.6 9.2 9.3 9.7 9.8 9.7 9.7 10.6 9.9 9.6 9.4 9.7 (a) Choose the correct time series plot. (i) Monthly Interest Rate 10.8 10.6 104 10.2 10.0 9.8 9.6 Interest Rate%) 9.4 No 9.2 9.0 8.8 8.6 8.4 0 0 8.2 1 2 4 5 6 7 8 9 10 11 12 Month(t) (ii) Monthly Interest Rate 10.8 10.6 10.4 10.2 eeeeegggg 10.0 9.8 Interest Rate % 9.6 9.4 9.2 9.0 0 0 0 8.8 000 8.6 8.4 8.2 N 1 2 3 10 11 12 4 5 6 7 8 9 Month(t) (iii) Monthly Interest Rate 10.8 10.6 10.4 10.2 10.0 9.8 Interest Rate(%) 9.6 9.4 9.2 9.0 8.8 000000000 8.6 8.4 8.2 i 2 3 3 10 1 11 12 4 5 6 7 Month(t) (iv) Monthly Interest Rate 10.8 10.6 10.4 10.2 10.0 9.8 0 000 eeeeeggggg 8 8 Interest Rate %) 9.6 m 9.4 9.2 ON 9.0 8.8 8.6 o co co 8.4 8.2 1 2 3 4 5 10 11 12 Month(t) - Select your answer What type of pattern exists in the data? - Select your answer - (b) Develop three-month and four-month moving averages for this time series. If required, round your answers to two decimal places. 3 Month 4 Month Moving Average Moving Average Month Sales 1 9.6 2 9.2 3 9.3 4 9.7 5 9.8 6 9.7 7 9.7 8 10.6 9 9.9 10 9.6 11 9.4 12 9.7 Enter the Square Errors the ree-month the four-month moving average forecasts. If your answers 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 Select your answer - (c) What is the moving average forecast for the next month? If required, round your answer to two decimal places