Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show in excel The accompanying data table shows the average number of viewers, in millions, for each season of a popular television show. Complete

image text in transcribed
image text in transcribed
please show in excel
The accompanying data table shows the average number of viewers, in millions, for each season of a popular television show. Complete parts a through e below. Click the icon to view the table of average number of viewers, in millions, by year. a) Forecast the average number of viewers during the 2009 season using a three-period weighted moving average with weights 3, 2, and 1, applying 3 to the most recent data and 1 to the oldest data. The forecasted average number of viewers during the 2009 season is million viewers. (Round to one decimal place as needed.) b) Calculate the MAD for the forecast in part a. MAD = (Round to two decimal places as needed.) c) Forecast the average number of viewers during the 2009 season using exponential smoothing with trend adjustment. Set a = 0.4 and B = 0.3. The forecasted average number of viewers during the 2009 season is million viewers. (Round to one decimal place as needed.) d) Calculate the MAD for the forecast in part c. MAD = (Round to two decimal places as needed.) e) in which forecast do you have the most confidence? Why? Choose the correct answer below. O A. The three-period weighted moving average, because it has the lower MAD B. The exponential smoothing with trend adjustment, because it has the higher MAD C. The three-period weighted moving average, because it has the higher MAD OD. The exponential smoothing with trend adjustment, because it has the lower MAD Average number of viewers, in millions, by year Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 Average Viewers 12.2 21.5 25.9 26.2 30.7 30.9 28.2 26.6 24.5 The accompanying data table shows the average number of viewers, in millions, for each season of a popular television show. Complete parts a through e below. Click the icon to view the table of average number of viewers, in millions, by year. a) Forecast the average number of viewers during the 2009 season using a three-period weighted moving average with weights 3, 2, and 1, applying 3 to the most recent data and 1 to the oldest data. The forecasted average number of viewers during the 2009 season is million viewers. (Round to one decimal place as needed.) b) Calculate the MAD for the forecast in part a. MAD = (Round to two decimal places as needed.) c) Forecast the average number of viewers during the 2009 season using exponential smoothing with trend adjustment. Set a = 0.4 and B = 0.3. The forecasted average number of viewers during the 2009 season is million viewers. (Round to one decimal place as needed.) d) Calculate the MAD for the forecast in part c. MAD = (Round to two decimal places as needed.) e) in which forecast do you have the most confidence? Why? Choose the correct answer below. O A. The three-period weighted moving average, because it has the lower MAD B. The exponential smoothing with trend adjustment, because it has the higher MAD C. The three-period weighted moving average, because it has the higher MAD OD. The exponential smoothing with trend adjustment, because it has the lower MAD Average number of viewers, in millions, by year Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 Average Viewers 12.2 21.5 25.9 26.2 30.7 30.9 28.2 26.6 24.5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematics Of Finance

Authors: Petr Zima, Robert L. Brown

5th Edition

0070871353, 978-0070871359

More Books

Students also viewed these Finance questions