Observation TV advertising ($) Newspaper advertising (S) Internet advertising ($) Sales ($) 1234567 8,350 4,520 1,285...

Transcribed Image Text:

Observation TV advertising ($) Newspaper advertising (S) Internet advertising ($) Sales ($) 1234567 8,350 4,520 1,285 430,400 9,370 4,700 1,265 474,055 8,300 4,978 1,185 437,885 9,950 4,800 1,495 500,205 9,090 5,150 1,090 471,900 9,680 4,290 1,405 479,860 8,160 4,790 1,290 428,930 8 8,240 5,200 1,485 442,000 9 8,600 4,860 1,365 446,495 10 10,216 4,400 1,135 462,180 11 9,090 5,000 1,354 469,600 12 8,590 5,005 1,447 450,900 13 9,900 5,130 1,650 504,100 14 8,835 5,200 1,236 465,120 15 8,700 5,025 1,121 454,325 16 8,975 4,600 1,174 456,930 17 9,980 4,060 1,130 446,350 18 8,910 4,300 1,024 447,760 19 8,570 5,500 1,045 438,600 20 9,340 5,030 1,429 481,800 SUMMARY OUTPUT Regression Statistics Multiple R 0.9030 R Square 0.8154 Adjusted R Square 0.7808 Standard Error 9985.4921 Observations 20 ANOVA df Regression 3 SS 7.05E+09 MS F Significance F 2.35E+09 2.36E+01 4.11E-06 Residual 16 1.60E+09 9.97E+07 Total 19 8.64E+09 Coefficients Standard Error Intercept 44641.8956 58710.7250 TV advertising 28.7962 4.1486 Newspaper advertising 22.0235 7.2103 Internet advertising 37.5936 14.2705 t Stat P-value 0.7604 0.4581 6.9412 0.0000 3.0545 0.0076 2.6343 0.0180 Lower 95% -79819.2815 20.0015 6.7384 7.3414 a) Write down the regression model based on the given output (e.g. Sales = 2,000 (TV advertising) +....) ar b) Using the regression model, predict the Sales if Disc Makers spends $8,000 on TV advertising. $4,500 or c) Do all the independent variables have a significant linear relationship with Sales in this regression mode d) What advertising venue (TV, newspaper or internet) has the highest impact on sales? As a Business Ana e) Please give the 95% confidence interval for the coefficients of newspaper advertising variable in the reg Upper 95% Lower 95.0% Upper 95.0% 169103.0726 -79819.2815 169103.0726 37.5909 20.0015 37.5909 37.3086 6.7384 37.3086 67.8458 7.3414 67.8458 id show why this regression model valid. Newspaper advertising and $1,800 on Internet advertising. I? Why or why not? lytics expert, what is your advice to Disc Makers on advertising expenditure? ression model? Observation TV advertising ($) Newspaper advertising (S) Internet advertising ($) Sales ($) 1234567 8,350 4,520 1,285 430,400 9,370 4,700 1,265 474,055 8,300 4,978 1,185 437,885 9,950 4,800 1,495 500,205 9,090 5,150 1,090 471,900 9,680 4,290 1,405 479,860 8,160 4,790 1,290 428,930 8 8,240 5,200 1,485 442,000 9 8,600 4,860 1,365 446,495 10 10,216 4,400 1,135 462,180 11 9,090 5,000 1,354 469,600 12 8,590 5,005 1,447 450,900 13 9,900 5,130 1,650 504,100 14 8,835 5,200 1,236 465,120 15 8,700 5,025 1,121 454,325 16 8,975 4,600 1,174 456,930 17 9,980 4,060 1,130 446,350 18 8,910 4,300 1,024 447,760 19 8,570 5,500 1,045 438,600 20 9,340 5,030 1,429 481,800 SUMMARY OUTPUT Regression Statistics Multiple R 0.9030 R Square 0.8154 Adjusted R Square 0.7808 Standard Error 9985.4921 Observations 20 ANOVA df Regression 3 SS 7.05E+09 MS F Significance F 2.35E+09 2.36E+01 4.11E-06 Residual 16 1.60E+09 9.97E+07 Total 19 8.64E+09 Coefficients Standard Error Intercept 44641.8956 58710.7250 TV advertising 28.7962 4.1486 Newspaper advertising 22.0235 7.2103 Internet advertising 37.5936 14.2705 t Stat P-value 0.7604 0.4581 6.9412 0.0000 3.0545 0.0076 2.6343 0.0180 Lower 95% -79819.2815 20.0015 6.7384 7.3414 a) Write down the regression model based on the given output (e.g. Sales = 2,000 (TV advertising) +....) ar b) Using the regression model, predict the Sales if Disc Makers spends $8,000 on TV advertising. $4,500 or c) Do all the independent variables have a significant linear relationship with Sales in this regression mode d) What advertising venue (TV, newspaper or internet) has the highest impact on sales? As a Business Ana e) Please give the 95% confidence interval for the coefficients of newspaper advertising variable in the reg Upper 95% Lower 95.0% Upper 95.0% 169103.0726 -79819.2815 169103.0726 37.5909 20.0015 37.5909 37.3086 6.7384 37.3086 67.8458 7.3414 67.8458 id show why this regression model valid. Newspaper advertising and $1,800 on Internet advertising. I? Why or why not? lytics expert, what is your advice to Disc Makers on advertising expenditure? ression model?