PLEASE HELP SOLVE PART B

Problem 15-13 (Algorithmic) The values of Alabama building contracts (in millions of dollars) for a 12-month period follow. 230 340 230 250 280 320 210 320 240 310 260 210 a. Choose the correct time series plot. (1) Value (Millions of dollars) 400 350 300 M 250 200 150 100 50 Month (t) 1 0 1 3 1 2 5 6 7 1 9 8 10 11 12 (ii) Value (Millions of dollars) 400 350 300 M 250 200 (ii) Value (Millions of dollars) 400 350 300 M 250 200 150 100 50 Month (t) 1 1 0 1 2 1 8 3 4 5 6 7 9 10 11 12 (II) Value (Millions of dollars) 400 350 300 250 200 150 100 50 Month (t) 0 1 2 3 4 5 1 7 6 8 8 9 10 11 12 (iv) Value (Millions of dollars) 400 350 300 250 200 150 100 50 Month(t) 1 1 1 1 0 1 6 2 3 4 5 7 8 9 10 11 12 Plot (iv) What type of pattern exists in the data? Horizontal Pattern b. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = 0.2. Which provides the better forecasts based on MSE? Do not round your intermediate calculations and round your final answers to two decimal places. Moving average Exponential smoothing MSE