Question 6: Refer to Question 4. (4 points) Use a =.01 to test the hypotheses (2 points) Ho: B = Be=0 H.: B and/or B2 is not equal to zero a. for the model y = B.+Byx + Bxx+ e, where x = television advertising (51000s) X, - newspaper advertising ($1000s) b. Use a = .05 to test the significance of Bi. Should x, be dropped from the model? (1 point) c. Use a = 05 to test the significance of B. Should x: be dropped from the model? (point) NOT No Spacing JUUUU Ter Cebote 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 (S1000s) (51000) (51000) 96 90 95 92 95 94 94 94 5.0 2.0 4.0 25 3.0 3.5 2.5 3.0 1.5 2.0 1.5 25 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: Y values weekly gross revenue X values Television advertising Newspaper advertising Regression Statistics I Multiple 0.958663444 R Square 0.9190356 Adjusted R Square 0.88664984 Standard Error 0.642587303 Observations 8 ANOVA d . MS F Regression Residual Total 2 21.43540779 11.7177019283776819 0.00186522 52.064592208 0.41291844 7 25 English (United States) Question 6: Refer to Question 4. (4 points) Use a =.01 to test the hypotheses (2 points) Ho: B = Be=0 H.: B and/or B2 is not equal to zero a. for the model y = B.+Byx + Bxx+ e, where x = television advertising (51000s) X, - newspaper advertising ($1000s) b. Use a = .05 to test the significance of Bi. Should x, be dropped from the model? (1 point) c. Use a = 05 to test the significance of B. Should x: be dropped from the model? (point) NOT No Spacing JUUUU Ter Cebote 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 (S1000s) (51000) (51000) 96 90 95 92 95 94 94 94 5.0 2.0 4.0 25 3.0 3.5 2.5 3.0 1.5 2.0 1.5 25 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: Y values weekly gross revenue X values Television advertising Newspaper advertising Regression Statistics I Multiple 0.958663444 R Square 0.9190356 Adjusted R Square 0.88664984 Standard Error 0.642587303 Observations 8 ANOVA d . MS F Regression Residual Total 2 21.43540779 11.7177019283776819 0.00186522 52.064592208 0.41291844 7 25 English (United States)