Question: please help me with the numbers in the problem thank you! Video Due to a recent change by Microsoft you will need to open the

Video 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.9 thousand is spent on television advertising and $3.9 thousand is spent on newspaper advertising (to 2 decimals)? in thousands Check My Work Reset Problem 3 4 5 6 7 B 9 10 11 Weekly Gross Revenue (1000s) 19 20 21 22 23 C B Television Newspaper Advertising Advertising ($1000s) 97 ($1000) 6 2 5 2.5 4 3.5 2.5 4 24 25 26 88288299 91 95 93 12 13 Predicted Revenue (Part D) 14 15 16 17 Formula for Predicted Revenue 18 WNIA 96 94 95 95 1.5 3 1.5 2.5 3.3 2.3 42 2.5 3.9 D E F G H Delete this text then place your Simple Regression output in this shaded area. Output range $E$1 Delete this text then place your Multiple Regression output in this shaded area. Output range $E$21
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
