# Question 23 4 4 points table 13 5 the managing

• Test Prep
• 12
• 100% (14) 14 out of 14 people found this document helpful

This preview shows page 10 - 12 out of 12 pages.

Question 23 4 / 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.802 R Square 0.643 Adjusted R Square 0.618 Standard Error SYX 0.9224 Observations 16 ANOVA df SS MS F Sig.F Regression 1 21.497 21.497 25.27 Error 14 11.912 0.851 Total 15 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 coefficient of determination is ________. 0.000 .802
.643 11.912 .851 Question 24 4 / 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.802 R Square 0.643 Adjusted R Square 0.618 Standard Error SYX 0.9224 Observations 16 ANOVA df SS MS F Sig.F Regression 1 21.497 21.497 25.27 Error 14 11.912 0.851 Total 15 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 correlation between the predicted and actual sales is ________. 0.000
Question 25 4 / 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.802 R Square 0.643 Adjusted R Square 0.618 Standard Error SYX 0.9224 Observations 16 ANOVA df SS MS F Sig.F Regression 1 21.497 21.497 25.27 Error 14 11.912 0.851 Total 15 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.000