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 0.000 Error 14 11.912 0.851 Total 15 33.409 Predictor Coef StdError tStat P-value Intercept 4.78 1.440 2.75 0.016 Industry 0.4889 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. Question 14 options: 4.78 and 0.4889 0.4889 and 4.78 2.75 and 5.03 1.44 and .008
Given,
Coefficient of intercept = Y - intercept = 4.78
Coefficient of industry = Slope = 0.4889
Option A is correct.
TABLE 13-5 The managing partner of an advertising agency believes that his company's sales are related...
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...
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 Regression 1 Error 14 Total 15 SS MS F Sig.F 31.497 21.497 25.27 0.000 21.912 0.851 53.409 Predictor...
Q3. (15 points) The managing partner of an advertising agency believes that his company's sales are related to the industry sales ($ 1000s). He uses Microsoft Excel 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 Observations 0.9224 ANOVA df 1 14 15 F 25.27 Regression Error Total MS 21.497 0.851 Sig.F 0.000 SS 21.497 11.912 33.409...