The size of the audience watching the Super Bowl plays a major role in the price the

Question:

The size of the audience watching the Super Bowl plays a major role in the price the broadcasting network charges for advertising. The following data show the average number of viewers, in millions, who watched previous Super Bowls, according to Nielsen. These data can also be found in the Excel file Super Bowl viewers.xlsx.

Year Viewers Year Viewers 2005 86.0 2010 106.5 2006 90.7 2011 111.0 2007 93.2 2012 111.3 2008 97.5 2013 108.4 2009 98.7

a. Construct a graph showing the average Super Bowl viewership over time.

b. Forecast the average number of viewers for the 2014 Super Bowl using a trend projection.

c. Calculate the MAD for this forecast.

AppendixLO1

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics

ISBN: 9780133852288

2nd Edition

Authors: Robert A Donnelly, Robert Donnelly Jr

Question Posted: