How do I find parts B & C?

Corporate triple A bond interest rates for 12 consecutive months are as follows: 9.6 9.4 9.5 9.7 9.9 9.5 9.8 10.6 10.1 9.9 9.5 9.8 (a) Choose the correct time series plot. (0) Monthly Interest Rate 10.8 10.6 10.4 10.2 10.0 9.8 Rate Interest 9.6 9.4 9.2 9.0 8.8 8.6 8.4 8.2 1 2 3 4 5 6 7 8 9 10 11 12 Month (ii) Monthly Interest Rate 10.8 10.6 10.4 10.2 10.0 9.8 M w 9.6 9.4 9.2 9.0 8.8 8.6 8.4 8.2 1 2 3 4 5 6 7 8 9 10 11 12 (iii) Monthly Interest Rate 10.8 10.6 Interest Rate 10.4 10.2 10.0 9.8 9.6 9.4 9.2 9.0 8.8 8.6 8.4 8.2 1 2 3 4 5 6 7 8 9 10 11 12 Month (iv) 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 8.6 8.4 8.2 1 2 3 4 5 6 7 8 9 10 11 12 Month Graph (iv) What type of pattern exists in the data? Horizontal pattern (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.5 4 9.7 5 9.9 6 9.5 7 9.8 X 8 10.6 9 10.1 10 9.9 11 9.5 12 9.8 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. 4-month 3-month moving moving average average MSE Does the three-month or the four-month moving average provide the better forecasts based on MSE? Explain. 4-month moving average v Moving average with the lowest MSE provides the better forecast. (c) What is the moving average forecast for the next month? If required, round your answer to two decim places