Course 4:41 Predictive Analytics -... Progress saved Done o Question 1 0/19 pts 3 Details LTE The following data represent the annual revenues (in millions of dollars) for a cloud software company from 2010 to 2021. Complete the table by developing: 4-year moving average forecasts 3-year weighted moving average forecasts using weights 5, 4 and 3, with emphasis placed on more recent periods, i.e. higher weights are assigned to more recent time periods. exponentially smoothed forecasts with a = 0.8 Round all results to 3 decimal places. If a result is being reused, ensure that the value being reused is the rounded value and not the original Stream Courses Calendar More 4:41 Predictive Analytics -... LTE Course 3-year 4-year E Weighted Year Revenue Moving : Moving Average Average 2010 6.3 2011 8.2 2012 7.2 2013 6.7 2014 6.2 2015 7.7 2016 8.0 2017 7.8 2018 7.9 2019 7.1 2020 7.1 Stream Courses Calendar More Course 4:41 Predictive Analytics -... LTE 2022 Download CSV a. What is the MAD for the 4-year moving average forecasts? b. What is the MAD for the 3-year weighted moving average forecasts? c. What is the MAD for the exponentially smoothed (a = 0.8) forecasts? d. Based on MAD, which of the methods provides the best forecast accuracy for the data? Select an answer Submit Q 4-year moving average 3-year weighted moving average exponential smoothing with a = 0.8 Stream Lourses Laiengar More 4:41 Course Predictive Analytics -... LTE Exponential 3-year 4-year Weighted evenue Moving Smoothing Moving Average (a = 0.8) Average 6.3 8.2 22 7.2 6.7 6.2 7.7 8.0 7.8 7.9 7.1 7.1 74 6.8 Stream Courses Calendar More 4:41 LTE