Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in 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 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. X 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 an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals). Revenue = + TVAdv + NewsAdv c. Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b)? d. Predict weekly gross revenue for a week when $4.5 thousand is spent on television advertising and $3.6 thousand is spent on newspaper advertising (to 2 decimals)? $ in thousands B D A Weekly Gross Revenue (1000s) 97 91 95 93 95 95 95 95 Television Advertising ($1000s) 5 2 4 2.5 3 3.5 2.5 4 Newspaper Advertising ($1000s) 1.5 2 1.5 2.5 3.3 2.3 4.2 2.5 Predicted Revenue (Part D) 4.5 3.6 Formula for Predicted Revenue #N/A Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in 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 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. X 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 an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals). Revenue = + TVAdv + NewsAdv c. Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b)? d. Predict weekly gross revenue for a week when $4.5 thousand is spent on television advertising and $3.6 thousand is spent on newspaper advertising (to 2 decimals)? $ in thousands B D A Weekly Gross Revenue (1000s) 97 91 95 93 95 95 95 95 Television Advertising ($1000s) 5 2 4 2.5 3 3.5 2.5 4 Newspaper Advertising ($1000s) 1.5 2 1.5 2.5 3.3 2.3 4.2 2.5 Predicted Revenue (Part D) 4.5 3.6 Formula for Predicted Revenue #N/A