Output using excel:
a)
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.807807 | |||||
R Square | 0.652553 | |||||
Adjusted R Square | 0.594645 | |||||
Standard Error | 1.215175 | |||||
Observations | 8 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 1 | 16.6401 | 16.6401 | 11.26881 | 0.015288 | |
Residual | 6 | 8.859903 | 1.476651 | |||
Total | 7 | 25.5 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 88.63768 | 1.582367 | 56.01588 | 2.17E-09 | 84.76577 | 92.50959 |
TV Ads | 1.603865 | 0.477781 | 3.356905 | 0.015288 | 0.434777 | 2.772952 |
Revenue = 88.64 + 1.60 TVAdv
----
b)
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.958663 | |||||
R Square | 0.919036 | |||||
Adjusted R Square | 0.88665 | |||||
Standard Error | 0.642587 | |||||
Observations | 8 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 2 | 23.43541 | 11.7177 | 28.37777 | 0.001865 | |
Residual | 5 | 2.064592 | 0.412918 | |||
Total | 7 | 25.5 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 83.23009 | 1.573869 | 52.88248 | 4.57E-08 | 79.18433 | 87.27585 |
TV Ads | 2.290184 | 0.304065 | 7.531899 | 0.000653 | 1.508561 | 3.071806 |
Newspaper Ads | 1.300989 | 0.320702 | 4.056697 | 0.009761 | 0.476599 | 2.125379 |
Revenue = 83.23 + 2.29 TVAdv + 1.30 NewsAdv
c)
No, the coefficient is not the same for part a) and part b).
d)
Revenue = 83.23 + 2.29*5.3 + 1.30*3.7 = 100.18 thousands
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....
f Delete this text then place your Simple Regression output in this shaded area. Output range $E$1 * Weekly Gross Revenue (1000s) Television Advertising ($1000s) Newspaper Advertising ($1000s) XL Miner Analysis ToolPak Anova: Single Factor Delete this text then place your Simple Regression output in this shaded area. Output range Anova: Two-Factor With Replication Anova: Two-Factor Without Replication Correlation Covariance Descriptive statistics Exponential Smoothing 13 Predicted Revenue Part Dj F-Test Two-Sample for Variances Fourier Analysis Formula for Predicted Revenue Linear...
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 b. Develop an estimated regression equation with both television advertising and news- paper advertising...
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 expenditures. Historical data for a sample of eight weeks follow has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. Use a = .01 to test the hypotheses for the model y = Bo + 1101 + $2@2 + E, where: Ho: B1 = B2...
The owner of Showtime Movie Theaters, tInc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. Use a .01 to test the hypotheses for the model y fo+ +P2 t, where: Ho: -2-0 Hai 1 and/or h #0 Compute the F...
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) a. Find an estimated regression equation relating weekly gross revenue to television advertising expenditures and newspaper advertising expenditures (to 2 decimals). Revenue = X TV Adv + NewsAdv
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., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) a. Use a = 0.01 to test the hypotheses H: B1 = By = 0 H : 81 and/or Ba is not equal to zero for the model y = 0o + 1x1 + 02.02 + E, where 21 = television...
eBook Video Use computer software packages, such as Minitab or Excel, to solve this problem. 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 elght weeks follow. Weekly Television Newspaper Gross Revenue Advertising Advertising ($1,000s) ($1,000s) ($1,000s) 101 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 96 3.0 3.3 94 3.5 2.3 94 2.5 4.2 103 30 2.5 a. Develop...