Nate: Datafar these prohiems are in the Maduie 2 Assisted Assignments Data fil'e - there is a tab for each problem. Aii answers shaul'd be entered using two deeimai piaees uniess athen-vise specied. if both decimal' places are zeros - then just enter the integer vaiue. Percentages shauid he entered without \"$6\" sign - 3.45% shauid be entered as 3.45. M2_A1. The last 20 years of annual sales for a small business is shown in Worksheet P1. The data is shown in $1Cls so Year 1 is $233,310. I will ask for all answers in terms of 5100135 so just enterthe data in your worksheets as it is shown in the file. (Note: I have made some modifications to this problem since creating the supporting video so there is some extra information in the video that you are not responsible for at this time. Specifically; I show you how to use Solver to optimize the answers you are not responsible for using Solver at this point. Also although it shows a different problem number it is the solution for this problem}. a] Plot the data does the data appear stationary? b} Compute the forecasts using the twoyear moving average. What is the MSE? c] Compute the forecast for Year 21 using the twoyear moving average. d} Compute the forecasts using the fouryear moving average. What is the MAD? e} Compute the forecast for Year 21 using the fouryear moving average. f} Do the two and fouryear moving averages tend to underestimate or overestimate the actual data? Why? g} Compute the forecasts using the threeyear weighted moving average using weights of L16; G3; and Ill. What is the MAPE? h} Compute the forecast for Year 21 using the threeyear weighted moving average using weights of {1.6; 0.3; and {1.1. i] Compute the forecasts using exponential smoothing with a smoothing constant of {1.2 and a forecast for Year 1 of 233. What is the MSE? j} Compute the forecast for Year 21 using exponential smoothing with a smoothing constant of [5.2 and a forecast for Year 1 of 233. k} Compute the forecasts using linear regression using Excel's slope and intercept function. What is the MAD? I] Compute the forecast for Year 21 using linear regression. m] Comparing one of the error measurements (MAD; MSEJ or MAPE} which is the best forecasting method? Which is the worst forecasting method