please help with questions 11-15z
Format New Slide Section BI U abe X X2 AV AN A AF Shape Fill Convert to Picture Shapes SmartArt Text Arrange Box Quick Shape Outline Styles Part III: A leading consumer packaged goods company is analyzing the impact of various advertising media on its sales. It has been keeping meticulous data on weekly sales and weekly advertising spending on television, radio, and Google Ads. It knows from a prior study that, in its business, weekly advertising has a direct impact on Sales. It randomly selected 30 weeks of data correlating same-week sales with same-week advertising for the three kinds of advertising channels: Television, Radio and Google. That data appears here below. pertaining to this problem. The Chief Marketing Officer of the company ran a Regression Report on the data, which appears below. On the next page answer the five questions Week Sales Television Radio Google 1 $ 300,000 $ 50,000 $ 35,000 $ 20,000 2 5 491,345 $ 26,248 $ 18,302 $ 95,091 SUMMARY OUTPUT: Sales vs. Ad Spending Mix 3 $ 402,752 $ 14,697 $ 16,914 $ 81,208 337,697 $ 19,170 $ 58,591 $ 10,751 Regression Statistics 446,203 $ 11,055 $ 56,893 $ 74,813 Multiple R 1.00 231,789 $ 17,972 $ 60,548 $ 24,060 R Square 0.99 203,876 $ 8,568 $ 64,776 $ 16,514 Adjusted R Square 0.99 324,798 $ 16,972 $ 85,073 $ 25,934 Standard Error 10065.95 625,479 $ 67,863 $ 89,679 $ 63,409 Observations 30.00 10 $ 236,919 $ 31, 864 $ 6,844 $ 31,910 423,096 $ 21,459 19,745 $ 79,808 17 235,678 $ 32,469 $ 34,855 $ 22,195 coefficients P-value Lower 95% Upper 95% 18 522,450 $ 67,453 $ 1,647 $ 79,199 Intercept 9003.79 0.219 -23712.694 5705.117 383,011 $ 16,155 $ 33,931 $ 66,671 Television 3.08 0.000 2.938 3.220 20 510,188 $ 72,807 $ 102 $ 72,891 Radio 1.97 0.000 1.825 2.124 21 $ 485,000 $ 64,815 $ 51,909 $ 51,778 Google 4.08 0.000 3.927 4.238 2 $ 515,363 $ 98,645 $ 49,130 $ 30,292 23 5 353, 958 $ 57,451 $ 18,119 $ 36,342 24 $ 459,718 $ 4,309 $ 49,814 $ 86,791 25 $ 549,903 $ 15,454 $ 79,294 $ 86,238 26 $ 512,375 $ 86,938 $ 53,799 s 32,434 27 $ 420,988 $ 14,609 $ 49,138 28 $ 372,803 $ 95 , 768 $ 30,480 $ 6,135 29 $ 446,110 $ 89,503 $ 34,066 $ 27,367 30 $ 375,045 S 46,107 $ 81,446 S 18,458 Notes Comments - + 129% 8 de 6 of 14 English (United States)11.Write the linear equation (model) for the regression line identified by this Regression Report. 12. Do all three advertising channels (Television, Radio or Google) have a positive impact on Sales? Which has the greatest impact? Explain your answer. 13. What is the confidence interval and p value for the independent variable "Radio"? Does Radio advertising have a significant linear relationship with Sales? 14. What is the net effect on Sales of spending $1,000 in a week on Television advertising? Show your work. 15. What would Sales be if the company spent $10,000 on television ads, $8,000 on radio ads, and $4,000 on Google ads? Show your work. Notes Comments + 129% Slide 7 of 14 English (United States)
