The number of viewers for network television shows has a direct effect on the amount of advertising dollars that will be generate
d. The following data show the number of viewers, in millions, for the final performance of the following seasons of American Idol. These data can also be found in the Excel file American Idol viewers. xlsx.

a. Forecast the number of viewers for American Idol for the final performance of the 2014 season 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 American Idol for the final performance of the 2014 season 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 2005 2006 2007 2008 2009 Viewers 30.3 31.8 25.3 27.1 23.8 Year Viewers 2010 20.1 20 20.6 2012 14.9 2013 2.1