Use a 2-year moving average method to calculate forecasts for the years 2012-2022. Question 2Use a 2-year weighted moving average method to calculate forecasts for the years 2012-2022, with the weight of 0.7 to be assigned to the most recent year data. Note: The SUMPRODUCT function must be used for computation. Question 3-Calculate the forecasts for the years 2010-2022 using the exponential smoothing method with alpha = 0.8. Question 4-Calculate the forecasts for the years 2010-2022 using the linear trendline method. Note: Renumber the number of periods to start with t = 1, and plot the data to get the estimations. Please round the estimates to two digits after the decimal point. The graph will also be part of your answer Calculate the MSE, MAD, MAPE, and bias for the forecasts derived for the years 2010--2021 by using the exponential smoothing and linear trendline methods in questions 3 and 4. Which forecasting methos id preferred