Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Q Search this cours Eructured Activity - Multiple Regression Video The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as
Q Search this cours Eructured Activity - Multiple Regression Video 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 = 88.64 1.60 TVAV b. Develop an estimated regression equation with both television advertising and newspaper advertising as the Independent variables (to 2 decimals), Revenue TVAdy + NewsAdv 83.23 + 2.29 1.30 E 6 Weekdy Gross Revenue (1000) 01 05 93 Television Advertising (51000) 5 2 5 25 6 3.5 Newspaper Advertising ($1000) 15 2 1.5 2.5 33 23 Regression Station Multiple RS Adjust Square Standard Error Obno 04 04 04 0.836638547 0.703311288 0853503135 0.000001783 3 3 25 Predicted Revenue (Part ) ANOVA Regression Red Total SS 1 0 7 MS Sundance 13275 13.275 142232420 000273822 58 0933333333 18.875 Formula for Predicted Revenge Wercept Television Adv 1100011 Cotandard roritat Palve Lower UNU 00.45050060 T8.54305003 2:07:10 07: 102030175787100134 2017 12 051060054 3.771367004 0.000370 04214457202142472107574 BONORYS Regression State Rare AR Standard Our 0.00040000 0.0344148 TOTT 0.40760000 ANO Regres Red Total 18 2170702551 18512755 356100 0001101000 5 123707440 0 2475400 18.875 Television Adverg (51000) Newer Advertising (510001 Standart Lower Upper 002204358 1078547830 30 2247300 5.700.00045125 19241001 03 04 09240 533105470 01510097 430)44093 0000 10000054 205500411000040 20051404 0001369434 0230100415 4107331341 0.001511410 0322250150051002103022000 1.000510025
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669deb2ee1a48_390669deb2e851ee.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669deb2f8368f_391669deb2f1c031.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started