Kizspy | Question: 37
(Choose 1 answer)
(See picture)
A. 3.962
Β. 8.816
C. 0.040451
D. 1.440
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
0.802
FUOVERFLOW
R Square
0.643
Adjusted R Square
0.618
Standard Error SYX0.9224
Observations
16
ANOVA
Error
Total
df
SS
Regression 1
21.497
14
11.912
MS
F
Sig.F
21.497
25.27
0.000
0.851
15
33.409
Predictor Coef
StdError t Stat 2.75
P-value
Intercept
3.962
1.440
0.016
Industry
0.040451
0.008048
5.03
0.000
Durbin-Watson Statistic
1.59
The prediction of Y for a quarter in which X = 120 is
