Please help solve and please explain he accompanying table shows raw data of fif
ID: 3062109 • Letter: P
Question
Please help solve and please explain
he accompanying table shows raw data of fifteen adult sample, where income is in dollars. Enter the data into Excel and solve the problems using the multiple regression procedures. Questions: What would be the estimated annual income for an adult with 32 years old. 14 years of 1. 2. What is the p-value of the F test to determine the overall significance of the regression 3. What is the p-value of the t test to examine an impact of years of education on annual income 4. What is the p- value of the t test to examine an impact of age on annual income using the 5. Interpret the impact of years of education on annual incom education, and 8 years of work? Use two decimal points. relationship? Use 4 decimal points using the regression analysis output? Use 4 decimal points. regression analysis output? Use 4 decimal points. Annual Income Years of Education Years of Work Y000s) 21 28 34 46 ID 24 12 14 14 18 10 16 40 47 39 38 20 36 40 36 25 39 15 49 19 40 35 29 20 38 49 10 10 16 10 10 12 13 18 10 18 50 39 14Explanation / Answer
Descriptive Statistics
Mean
Std. Deviation
N
Y
34.33
9.810
15
X1
36.67
8.312
15
X2
13.53
2.924
15
X3
8.07
4.773
15
Model Summaryb
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
Change Statistics
R Square Change
F Change
df1
df2
Sig. F Change
1
.917a
.841
.798
4.409
.841
19.432
3
11
.000
a. Predictors: (Constant), X3, X2, X1
b. Dependent Variable: Y
ANOVAb
Model
Sum of Squares
df
Mean Square
F
Sig.
1
Regression
1133.458
3
377.819
19.432
.000a
Residual
213.876
11
19.443
Total
1347.333
14
a. Predictors: (Constant), X3, X2, X1
b. Dependent Variable: Y
Coefficientsa
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
-15.135
7.788
-1.943
.078
X1
.674
.289
.571
2.332
.040
X2
1.854
.439
.553
4.225
.001
X3
-.043
.482
-.021
-.089
.931
a. Dependent Variable: Y
Regressor
P-value
Comment
Age
0.040 < 0.05
Age have positive significant impact on Income
Years of Education
0.001 < < 0.05
Years of Education have high positive impact on Income
Years of work
0.931 > > 0.05
Years of work have insignificant impact on Income
Descriptive Statistics
Mean
Std. Deviation
N
Y
34.33
9.810
15
X1
36.67
8.312
15
X2
13.53
2.924
15
X3
8.07
4.773
15
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.