Kizspy | Question: 34
(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
R Square
0.802
0.643
Adjusted R Square
0.618
Standard Error SYX0.9224
Observations
16
ANOVA
df
SS
Error
14
Regression 1
21.497
11.912
MS
21.497
25.27
0.851
F
Sig.F
0.000
Total
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