Graph (1) 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 Sales Moving Average Moving Average Month 1 9.7 2 9.4 3 9.6 4 9.8 5 9.6 6 7 9.9 8 10.5 9 9.8 $ $ $ $ 10 9.5 13 9.4 12 9:4 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 4-month moving moving average average MSE Does the three month or the four month moving average provide the better forecasts based on MSG? Explain Select your answer Select your answer Enter the Mean Square Errors for the three-month and the four-month moving average forecasts. If 3-month 4-month moving moving average average Select your answer 3-month moving average 4-month moving average T-month moving average provide the better forecasts based on MSE? Select your answer (6) 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 Month Sales Moving Average Moving Average 1 9.7 2 9.4 3 9.6 4 9.8 5 9.6 $$ 6 9.9 7 9.9 8 10.5 9 9.8 10 9.5 11 9.4 12 9.4 Enter the Mean Square Errors for the three month and the four-month moving average forecasts. If needed, round your answers to 3-month 4-month moving moving average average MSE Select your answer Moving average with the lowest MSE provides the better forecast, recasts based on MSE? Explain Moving average with the highest MSE provides the better forecast - Select your answer Corporate triple A bond interest rates for 12 consecutive months are as follows: 9.7 9.4 9.6 9.8 9.6 9.9 9.9 10.5 9.8 9.5 9.4 9.4 If required, round your answer to two decimal places. (a) Choose the correct time series plot. (1) Monthly Interest Rate 10.8 106 104 10. 2 100 9.8 Interest Rate 94 92 9.0 88 86 84 82 1 2 3 4 5 6 7 00 9 10 11 12 Month (ii) Monthly Interest Rate Interest Rate 108 10.6 104 102 10.0 9.8 96 94 92 90 88 8.6 84 82 3 5 10 11 12 Morth m) Monthly Interest Rate 108 10.6 104 102 100 98 96 Interest Rate MW 92 90 8.8 8.6 84 8.2 1 3 4 5 10 11 8 12 N Month (iv) Monthly interest Rate Interest Rate 108 10.6 104 102 100 9.8 9.6 94 92 90 86 84 1 3 4 10 11 12 Month