Corporate triple A bond interest rates for 12 consecutive months are as follows: 9.6 9.4 9.2 9.7 9.8 9.9 9.7 10.6 9.9 9.6 9.7 9.5 (a) Choose the correct time series plot. (i) Monthly Interest Rate Interest Rate%) 10.8 10.6 104 102 10.0 9.8 96 94 92 90 88 8.8 * 8.2 1 2 3 4 5 6 7 8 9 10 11 12 Month(t) Month(t) (ii) Monthly Interest Rate 10.8 10.6 104 10.2 100 9.8 9.6 Interest Rate(%) 94 9.2 9.0 8.8 8.6 GOGO on 84 8.2 N 1 2 3 3 4 5 6 7 8 9 10 11 12 Month(t) (iii) Monthly Interest Rate 10,8 (iii) Monthly Interest Rate 10.8 10.6 10.4 10.2 10.0 9.8 Interest Rate% mu w 9.6 94 9.2 9.0 8.8 8.6 COCO 84 82 1 2 3 3 4 5 8 9 10 11 12 6 7 Month(t) (iv) Monthly Interest Rate 10.8 10.6 10.4 10.2 10.0 9.8 Interest Rate(%) 4 9.6 94 9.2 9.0 8.8 8.6 Co 8.4 82 COCO N N 3 4 5 6 7 8 9 10 11 12 Month(t) Select your answer - V 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.4 3 9.2 4 9.7 5 9.8 6 9.9 7 7 9.7 8 10.6 9 9.9 10 9.6 11 9.7 12 9.5 Enter the Mean Square Errors for the three-month and the four-month moving average forecasts. If required, round your answers to three decimal digits. 3-month 4-month moving moving average 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