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

Question

Question

b. Develop an estimated regression equation with both television advertising and news- paper advertising as the independent v

math Statistics-And-Probability

Add a comment Improve this question Transcribed image text

Answer 1

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)

Add a comment

Answer 2

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

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

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

Homework Answers