(Choose 1 answer)
(See picture)
Α. 85.46%
B. None of the other choices is correct
C. 73.03%
D. 15.00%
Ε. 68.53%
You worked as an intern at We Always Win Car Insurance Company last summer You notice that individual car insurance premiums depend very much on the age c the individual and the number of traffic tickets received by the individual. You performed a regression analysis in EXCEL and obtained the following partial information:
Regression Statistics
Multiple R
0.8546
R Square
0.7303
Adjusted R Square
0.6853
Standard Error
226.7502
Observations
15
ANOVA
df
SS
MS
F
Significance F
Regression
2
835284.6500
16.2457
0.0004
Residual
12
616987.8200
Total
2287557.1200
Coefficients
Standard Error
t Stat
P-value
Intercept
821.2617
161.9391
5.0714
0.0003
Age
-1.4061
2.5988
-0.5411
0.5984
Lower 99%
326.6124
-9.3444
Upper 99%
1315.911
6.532
6
