Question: 49
(Choose 1 answer)
(See picture)
A. 1.5740
B. 1.3045
C. 0.1478
D. -0.1478
A financial analyst wanted to examine the relationship between salary (in $1,000)
and 2 variables: age (X₁= Age) and experience in the field (X2 = Exper). He took
a sample of 20 employees and obtained the following Microsoft Excel output:
Regression Statistics
Multiple R
0.8535
R Square
0.7284
Adjusted R Square
0.6964
Standard Error
10.5630
Observations
20
ANOVA
df
SS
Regression
Residual
2
17
Total
19
5086.5764
1896.8050
6983.3814
MS
2543.2882
111.5768
F
22.7941
Significance F
0.0000
Coefficients
Intercept
Age
1.5740
1.3045
Standard Error
9.2723
t Stat
0.1698
P-value
0.8672
Lower 95%
Upper 95%
-17.9888
21.1368
0.1956
6.6678
0.0000
0.8917
1.7173
Exper
-0.1478
0.1944
-0.7604
0.4574
-0.5580
0.2624
The estimate of the unit change in the mean of Y per unit change in X₁,
considering the effects of the other variable, is