15.5 Excel Activity 1 - Hypothesis Test for Significance in Multiple Regression with XLMiner Analysis ToolPak (Freeform)

Please see attached for data

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.

15.5 Excel Activity 1 - Hypothesis Test for Significance in Multiple Regression with XLMiner Analysis ToolPak (Freeform) El Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak addin manually from the home ribbon. Screenshot of ToolPak 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 = g + 31x1 + [321:2 + s, where: H0 1 51 = {32 = 0 H,3 :51 and/or B2 #0 Compute the Ftest statistic (to 2 decimals). What is the p-value? What is your conclusion? b. Use a = .05 to test the significance of E1. Compute the ttest statistic (to 2 decimals). 15.5 Excel Activity 1 - Hypothesis Test for Significance in Multiple Regression with XLMiner Analysis ToolPak (Freeform) Question 1 UPI I] Submit What is the p-value? What is your conclusion? l v Should :61 be dropped from the model? | V i c. Use a .05 to test the significance of 132. Compute the t test statistic (to 2 decimals). What is the p-value? What is your conclusion? l v Should :52 be dropped from the model? | V i d. The owner plans to spend (in $1000s) $4.9 on television advertising and $3.9 on newspaper advertising. What is the expected revenue (in $10005) for this advertising combination (to the nearest whole number)? $ Check My Work Reset Problem File Home Insert Draw Page Layout Formulas Data Review View Help Arial V 10 B A . . . E V ap E1 Y X Vfx A B C D E F G H Television Newspaper Weekly Gross Advertising Advertising 1 Revenue (1000s) ($1000s) ($1000s) 97 6 1.5 91 2 2 95 5 1.5 JOUAWN 93 2.5 2.5 95 4 3.3 94 3.5 2.3 95 2.5 4.2 9 95 4 2.5 10 11 12 Predicted Revenue 13 4.9 3.9 14 15 16