The following data represent the annual revenues (in millions of dollars) for a cloud software company...

 

Transcribed Image Text:

The following data represent the annual revenues (in millions of dollars) for a cloud software company from 2013 to 2022. Complete the table by developing: • exponentially smoothed forecasts with a = 0.32 • exponentially smoothed with trend forecasts with a = 0.32 and B = 0.7 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 result obtained before rounding. Year 2013 2014 2015 2016 2019 2020 2021 Revenue 2017 3.9 2022 4.3 2018 5.0 2023 4.0 4.6 4.8 4.4 4.2 5.1 5.5 Download CSV Exponential Exp. Smoothing w/ Trend Smoothing (α = 0.32) (α = 0.32) (B = 0.7) a. What is the MSE for the exponentially smoothed (x = 0.32) forecasts? b. What is the MSE for the exponentially smoothed with trend (α = 0.32, B = 0.7) forecasts? c. Based on MSE, which of the methods provides the best forecast accuracy for the data? Select an answer The following data represent the annual revenues (in millions of dollars) for a cloud software company from 2013 to 2022. Complete the table by developing: • exponentially smoothed forecasts with a = 0.32 • exponentially smoothed with trend forecasts with a = 0.32 and B = 0.7 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 result obtained before rounding. Year 2013 2014 2015 2016 2019 2020 2021 Revenue 2017 3.9 2022 4.3 2018 5.0 2023 4.0 4.6 4.8 4.4 4.2 5.1 5.5 Download CSV Exponential Exp. Smoothing w/ Trend Smoothing (α = 0.32) (α = 0.32) (B = 0.7) a. What is the MSE for the exponentially smoothed (x = 0.32) forecasts? b. What is the MSE for the exponentially smoothed with trend (α = 0.32, B = 0.7) forecasts? c. Based on MSE, which of the methods provides the best forecast accuracy for the data? Select an answer