The number of viewers for network television shows has a direct effect on the amount of advertising dollars that will be generated. The following data show the number of viewers, in millions, for the Super Bowl superbowl.xlsx.

a. Forecast the number of viewers for the Super Bowl in 2019 using three-period weighted moving average with weights 3, 2, and 1.

b. Calculate the MAD for the forecast in part a.

c. Forecast the number of viewers for the Super Bowl in 2019 using exponential smoothing with trend adjustment and setting ? = 0.4 and ? = 0.2.

d. Calculate the MAD for the forecast in part c.

e. In which forecast do you have the most confidence? Why?

Transcribed Image Text:

Year 2009 2010 2011 2012 2013 Viewers 98.7 106.5 111.0 111.3 Year 2014 2015 2016 2017 2018 Viewers 111.5 114.4 111.9 111.3 108.4 103.4