Question 7 4 4 points table 13 5 the managing partner

• Test Prep
• 10
• 96% (121) 116 out of 121 people found this document helpful

This preview shows page 3 - 5 out of 10 pages.

Question 7 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 estimates of the Y -intercept and slope are ________ and ________, respectively. 0.000 2.75 and 5.03 1.44 and .008 .040451 and 3.962 3.962 and .040451
Question 8 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 0.000
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 prediction for a quarter in which X = 120 is Y = ________.
Question 9 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 standard error of the estimate is ________. 0.000
Question 10 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: