Kizspy Question: 41
(Choose 1 answer)
(See picture)
A. 3.962
B. 8.816
C. 0.040451
D. 1.440
FJOVERFLOW.COM
The managing partner of an advertising agency believes that his company's sales
are related to the industry sales. 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
R Square
0.802
0.643
Adjusted R Square 0.618
Standard Error SYX0.9224
Observations
16
ANOVA
df
Regression 1
Error
SS
21.497
14
11.912
MS
21.497 25.27
0.851
F Sig.F
0.000
Total
15
33.409
Predictor Coef
StdError
t Stat
P-value
Intercept 3.962
Industry 0.040451
1.440
0.008048
2.75
0.016
5.03
0.000
Durbin-Watson Statistic
1.59
The prediction of Y for a quarter in which X = 120 is
