Chapter 15: Multiple Regression Model Question 4 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. (4 points) Weekly Gross Televison Newspaper Revenue Advertising Advertising ($1000s) ($1000s) ($1000s) 96 90 95 92 95 94 94 94 5.0 2.0 4.0 2.5 3.0 3.5 2.5 3.0 1,5 2.0 1.5 2.5 3.3 2.3 4.2 2.5 a. Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables. (2 points) Using Excel's Descriptive Statistics Regression Tool, paste the Excel output: Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA SS MS F Significance F Regression Residual Total Coefficients Standard Error Stat P-value Intercept Television Advertising ($1000s) intercept Television Advertising (51000) Newspaper Advertising (51000) 9- where Page 6 of 16 Xi = television advertising (51000) X = newspaper advertising ($1000s) b Predict weekly gross revenue for a week when $3500 is spent on television advertising and S1800 is spent on newspaper advertising? (2 points) Revenue