Question

The following data describes weekly gross revenue, television advertising, and newspaper advertising for Showtime Movie Theat

0 0
Add a comment Improve this question Transcribed image text
Answer #1

X2-MX2 -1.341 1.722 1.813 - 1.188 0.813 -0.688 -0.188 0.313 -0.688 -0.188 -0.975 -0.475 -0.975 0.025 0.825 -0.175 1.725 0.025

Sum of X1 = 25.5
Sum of X2 = 19.8
Sum of Y = 749
Mean X1 = 3.1875
Mean X2 = 2.475
Mean Y = 93.625
Sum of squares (SSX1) = 6.4688
Sum of squares (SSX2) = 5.815
Sum of products (SPX1Y) = 8.5625
Sum of products (SPX2Y) = 0.725
Sum of products (SPX1X2) = -3.4125

Regression Equation = ŷ = b1X1 + b2X2 + a

b1 = ((SPX1Y)*(SSX2)-(SPX1X2)*(SPX2Y)) / ((SSX1)*(SSX2)-(SPX1X2)*(SPX1X2)) = 52.27/25.97 = 2.01

b2 = ((SPX2Y)*(SSX1)-(SPX1X2)*(SPX1Y)) / ((SSX1)*(SSX2)-(SPX1X2)*(SPX1X2)) = 33.91/25.97 = 1.31

a = MY - b1MX1 - b2MX2 = 93.63 - (2.01*3.19) - (1.31*2.48) = 83.98

ŷ = 2.01X1 + 1.31X2 + 83.98

Add a comment
Know the answer?
Add Answer to:
The following data describes weekly gross revenue, television advertising, and newspaper advertising for Showtime Movie Theaters....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • 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

  • Exercise 15.41 Question 14 of 16 Check My Work eBook Video The following data describes weekly...

    Exercise 15.41 Question 14 of 16 Check My Work eBook Video The following data describes weekly gross revenue, television advertising, and newspaper advertising for Showtime Movie Theaters. Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 1.5 u w Ň w 2.5 a. Find an estimated regression equation relating weekly gross revenue to television advertising expenditures and newspaper advertising expenditures (to 2 decimals). TV Adv + 1.29 NewsAdv Revenue = 81.73 + 2.84 b. Select a standardized residuals plot....

  • 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....

  • 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 (C2). Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 2.5 The estimated regression equation was y = 85.5+ 2.0621 -0.37x2. The computer solution provided SST = 26, SSR = 24.356. a. Compute RP (to 3 decimals). Compute RX (to 3 decimals). b. When television advertising was the only independent variable, R2 =...

  • 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 Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 2.5 لما الما ا ل The estimated regression equation was y = 84.6 + 1.38001 - 1.29.02. The computer solution provided SST = 17.5, SSR = 16.412. a. Compute R (to 3 decimals). Compute R (to 3 decimals). = 0.475. Are the multiple...

  • 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 (1) and newspaper advertising (22) Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 1.5 البة بة جة The estimated regression equation was y = 88.4 +1.85&1 - 0.1722 The computer solution provided SST = 23.5, SSR = 22.035. a. Compute R2 (to 3 decimals). Compute R2 (to 3 decimals). Compute RX (to 3 decimals). b. When...

  • 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 (11) and newspaper advertising (C2). Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 2.5 The estimated regression equation was y = 85.5+ 2.06x1 -0.37x2. The computer solution provided SST = 26, SSR = 24.356. a. Compute R2 (to 3 decimals). 0.937 Compute R. (to 3 decimals). b. When television advertising was the only independent variable, RP...

  • 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 95 5 1.5 93 3.5 3.5 96 4 4.3 95 4.5 2.3 95 3.5 5.2 95 4 3.5 ŷ = 84.3 + 2.02 x 1 + 0.7 x 2 The...

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
ADVERTISEMENT