Note 1) erter values only in the highlighed col 2) the number of our values in the actuar com Slope 194.1273 Intercept2384 MAD 272.16 MSE14.112.40 Moving Average Noelenter values only in the Highed cells, 2) enter the number of tourists values in the war column MAD 500.00 MSEEN.464.00 Period 1 2 3 4 5 Actual Forecast Error Error Actual Forecast Error Error 700903.52737.4727297 AT2703480.03 3456.431.518.654501407 63730.701097.7010 OT.7010201204 44.4.2001 3.000.00 1410 1008.094 0.300.30 23175.5 1531223.184.83644133106.6 1028 127.201241.7001 170011423.28 13011561.410-24.412 20.41022700.21 14891715.545-20.545200.545567239.99 1985 17:473100327310032731933.45 20430 Period 1 2 3 4 $ . 10 11 6 498 527 4761 1430445.33333.03.6067 2063.4 1988 19.4447754.333334333018 1182 477 1301 1542393 241,3333 241.933 8241.78 144411600 51 51 2001 1985481.60727.333335273333 270004 1501.447 + 10 1) Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center. 248 Year Number of Tourists 1 700 2 3 633 4 458 1410 6 1588 7 1629 8 1301 9 1455 10 1989 Tom is interested in implementing a forecasting system and is investigating the following forecasting methods as possibilities: Simple moving average, Weighted moving average, Simple Exponential Smoothing, and Regression. Using a spreadsheet (use the attached excel template, the excel template is your submission file), choose any two forecasting methods, and calculate the forecast for year 11 (if you use exponential smoothing, begin with the assumption the forecast for year 9 was 1500, choose any alpha value; if you use the weighted average method, choose the weights you want). Explain why each of your two chosen methods is appropriate for the data and the time frame given