HomeworkLib
Question

Question 1The owner of Showtime Movie Theaters, Inc. would like to predict weekly gross revenue as a function of advertising
b. Develop an estimated regression equation with both television advertising and news- paper advertising as the independent v
math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

b)

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.958663444
R Square 0.9190356
Adjusted R Square 0.88664984
Standard Error 0.642587303
Observations 8
ANOVA
df SS MS F Significance F
Regression 2 23.43540779 11.7177039 28.37776839 0.001865242
Residual 5 2.064592208 0.412918442
Total 7 25.5
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 83.23009169 1.573868952 52.88247894 4.57175E-08 79.18433275 87.27585063 79.18433275 87.27585063
Television Ad 2.290183621 0.304064556 7.531899313 0.000653232 1.508560797 3.071806445 1.508560797 3.071806445
Newspaper Ad 1.300989098 0.320701597 4.056696662 0.009760798 0.476599399 2.125378798 0.476599399 2.125378798

Revenue = 83.2301 + 2.2902 * Television Ad + 1.3011 * Newspaper Ad

c)

Television Ad = 3500 = 3.5 ($1000s) and Newspaper Ad = 1800 = 1.8 ($1000s)

Revenue = 83.2301 + 2.2902 * 3.5 + 1.3011 * 1.8

Revenue = 83.2301 + ‭8.0157‬ + 2.3421

‭Revenue = 93.5879‬ ($1000s)

0 0
Add a comment
Know the answer?
Add Answer to:
Question 1The owner of Showtime Movie Theaters, Inc. would like to predict weekly gross revenue as...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Question 1The owner of Showtime Movie Theaters, Inc. would like to predict weekly gross revenue as...

    Question 1The owner of Showtime Movie Theaters, Inc. would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. (6 points) Weekly Gross Revenue Newspaper Advertising Advertising ($1000s) Televison ($1000s) (s1000s) 96 5.0 1.5 2.0 2.0 90 95 4.0 1.5 92 2.5 2.5 3.3 95 3.0 3.5 2.3 94 2.5 4.2 94 94 3.0 2.5 Question 2: In Question 1, the owner of Showtime Movie Theaters, Inc. used multiple...

  • The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue y)...

    The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue y) as a function of television advertising (1) and newspaper advertising (2) Weekly Gross Televison Newspaper Advertising (S1000s) Advertising (S1000s) Revenue ($1000s) 96 5 2.5 91 2 3 95 2.5 93 3.5 2.5 95 4 4.3 95 4.5 2.3 94 3.5 4.2 94 4 3.5 86.3+1.611 0.48a The estimated regression equation was =16.875, SSR 16.01 The computer solution provided SST a. Compute R (to 3...

  • The following data describes weekly gross revenue, television advertising, and newspaper advertising for Showtime Movie Theaters....

    The following data describes weekly gross revenue, television advertising, and newspaper advertising for Showtime Movie Theaters. Weekly Gross Televison Newspaper Advertising Advertising Revenue ($1000s) ($1000s) ($1000s) 1.5 2 1.5 2.5 3.3 2.3 90 2 4 2.5 92 95 94 94 94 3.5 2.5 2.5 a. Find an estimated regression equation relating weekly gross revenue to television advertising expenditures and newspaper advertising expenditures (to 2 decimals) Revenue = 83.78 1.78 TVAdv + | 1.47 NewsAdv

  • The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising exp...

    The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XLMiner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet Open spreadsheet a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue = + TVAdv b....

  • The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a...

    The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XLMiner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet. Open spreadsheet a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue = TVAdv b. Develop...

  • The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue (y)...

    The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue (y) as a function of television advertising (x 1) and newspaper advertising (x 2). The estimated regression equation was Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 96 5 1.5 90 2 2 96 5 1.5 92 2.5 3.5 95 4 4.3 95 4.5 2.3 94 3.5 5.2 94 4 3.5 ŷ = 85.7 + 1.94 x 1 + 0.3 x 2 The...

  • 2. The owner of Showtime Movie Theaters would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are as below: TV Advertising...

    2. The owner of Showtime Movie Theaters would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are as below: TV Advertising $1000s 5.0 2.0 4.0 2.5 3.0 3.5 2.5 3.0 Week Weekly gross revenue $1000s 96 90 95 92 95 94 94 94 Newspaper Advertising $1000s 2.0 2.5 3.3 2.3 4.2 2.5 4 6 Following are the regression results for the data using Excel. In this problem, you...

  • The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a...

    The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Televison Newspaper Advertising ($1000s) Advertising ($1000s) Revenue ($1000s) 97 5 1.5 2 06 96 4 2.5 93 3.5 2.5 96 4 3.3 94 3.5 3.3 94 2.5 5.2 95 4 2,5 a. Use o 0.01 to test the hypotheses H8 and/or B is not equal to zero for the...

  • The owner of Showtime Movie Theaters, Inc, would like to predict weekly gross revenue as a...

    The owner of Showtime Movie Theaters, Inc, would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow Weekly Gross Televison Newspaper Advertising Advertising Revenue ($1000s) ($1000s) ($1000s) 96 5 1.5 91 3 96 5 2.5 92 2.5 2.5 95 3 4.3 95 3.5 3.3 94 2,5 4.2 94 3 3.5 a. Use o0.01 to test the hypotheses Ho BB0 H A and/or Bis not equal to zero for...

  • please help! nework The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a fu...

    please help! nework The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow Televison Weekly Gross Newspaper Advertising Reyenue Advertising ($1000s) ($1000s) ($1000s) 97 1.5 91 2.5 92 2.5 2.5 06 3.3 4. 94 3.5 2.3 2.5 5.2 95 4 2.5 a. Use a 0.01 to test the hypotheses H,:6 and/or B is not equal to zero for the model y...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT