Question

Question 8 (4 points) TABLE 13-5 The managing partner of an advertising agency believes that his company's sales are related to the industry sales. He uses Microsoft Excel's Data Analysis tool to analyze the last 4 years of quarterly data (i.e., n = 16) with the following results: Regression Statistics Multiple R 0.78 R Square 0.6084 Adjusted R Square 0.6012 Standard Error SYX 0.9224 Observations 16 ANOVA df Regression 1 Error 14 Total 15 ss MSF Sig.F 21.497 21.497 25.27 0.000 11.912 0.851 33.409 Predictor Coef StdError tStat P-value Intercept 3.962 1.440 2.75 0.016 Industry 0.040451 0.008048 5.03 0.000 Durbin-Watson Statistic 1.59 Referring to Table 13-5, the amount of variation explained by using Industry as the independent variable is 0.802 0.643 0.78 0.6084

Answer 1

solution The Ŕ Value reprents the amount of variation I explained by the independent variable. R-Square value from the given table is 0.6084 :. The amount of Variation explained by using industry as the independent variable is 50-60847