Forecast the advertising revenue for each quarter in 2011 using seasonal dummy variables and a best...

50.1K

Verified Solution

Question

Basic Math

Forecast the advertising revenue for each quarter in 2011 usingseasonal dummy variables and a best subsets regression.? (Let thefirst dummy variable be equal to 1 for Quarter 2 and so? on,following the order of the seasonal categories in the given?table.
2008
1 540
2 516
3 488
4 500
2009
quarter Rev. in Millions
1 433
2 407
3 402
4 460
2010
quarters rev. in millions
1 347
2 297
3 292
4 332
A) The revenue forecast for the first quarter in 2011 is?
The revenue forecast for the second quarter in 2011 is?
The revenue forecast for the third quarter in 2011 is?
The revenue forecast for the fourth quarter is?
B.) quarter 4 has an average revenue that is ___ above that forquarter !
C.) Calculate the MAD for the forecast.

Answer & Explanation Solved by verified expert

4.4 Ratings (695 Votes)

Please See the Values Carefully The data can be presented in terms of Quarter and Year variables as Quarter1 Quarter2 Quarter3 Quarter4 Year Revenue millions 1 0 0 0 1 540 0 1 0 0 1 516 0 0 1 0 1 488 0 0 0 1 1 500 1 0 0 0 2 433 0 1 0 0 2 407 0 0 1 0 2 402 0 0 0 1 2 460 1 0 0 0 3 347 0 1 0 0 3 297 0 0 1 0 3 292 0 0 0 1 3 332 Carrying out regression in Excel go to Data tab Data Analysis Regression choose Revenue as Ycolumn and QuarterYear columns as Xcolumns we get the following See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member