Question 2 Below is the annual ridership (in millions) for MiWay from 2014 to 2020. Complete the table by developing: 4-year moving average forecasts 4-year weighted moving average forecasts using weights 4, 3, 3 and 2 with emphasis placed on more recent periods; i.e. 4 is the most recent weight, 3 is the second most recent weight, 3 is the third most recent weight, and 2 is the least recent weight. exponentially smoothed forecasts with a = 0.63 Round all final results to three decimal places. If a result is being reused, ensure that the value being reused is the rounded value and not the original result obtained before rounding. D Exponential 4-year 4-year Weighted Year Revenue Smoothing Moving Average Moving Average (a = 0.63) 2014 18.0 2015 20.6 2016 22.5 2017 21.7 2018 21.7 2019 20.1 2020 11.9 Download CSV NOTE: If you perform any intermediate steps in your mean absolute deviation (MAD) calculations, then do NOT round during those steps. a. What is the mean absolute deviation (MAD) for each of the models above? 4-year Moving Average (MA) MAD = 4-year Weighted Moving Average (WMA) MAD = Exponential Smoothing (ES) (a = 0.63) MAD = b. Based on MAD, which of the methods provides the best forecast accuracy for the data? Select an answer c. Using the same models from above, what would the forecast be for 2021 be? 4-year Moving Average (MA) 2021 Forecast = 4-year Weighted Moving Average (WMA) 2021 Forecast = Exponential Smoothing (ES) (a = 0.63) 2021 Forecast = Next Question