Question

In: Statistics and Probability

A social scientist would like to analyze the relationship between educational attainments (years in higher ed)...

A social scientist would like to analyze the relationship between educational attainments (years in higher ed) and annual salary (in $1,000s). He collects the data above.

Salary Education
40 3
53 4
80 6
41 2
70 5
54 4
110 8
38 0
42 3
55 4
85 6
42 2
70 5
60 4
140 8
40 0
76 5
65 4
125 8
38 0
a What is the equation for predicting salary based on educational attainment?
b What is the coefficient for education?
c what is the predicted salary for someone with 4 years of higher ed?

Solutions

Expert Solution

Y-salary

X-education

use R studio.

use lm function to fit linear model of salary on experience

summary function to get the summary of thr model output.

Rcode:

df1 =read.table(header = TRUE, text ="
Salary   Education
40   3
53   4
80   6
41   2
70   5
54   4
110   8
38   0
42   3
55   4
85   6
42   2
70   5
60   4
140   8
40   0
76   5
65   4
125   8
38   0

"
)
df1
linmod = lm(Salary~Education,data=df1)
summary(linmod)

Output:


Call:
lm(formula = Salary ~ Education, data = df1)

Residuals:
Min 1Q Median 3Q Max
-14.817 -8.169 -2.658 4.661 30.980

Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 22.296 5.636 3.956 0.000927 ***
Education 10.841 1.195 9.072 3.91e-08 ***
---
Signif. codes:
0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 12.92 on 18 degrees of freedom
Multiple R-squared: 0.8206,   Adjusted R-squared: 0.8106
F-statistic: 82.31 on 1 and 18 DF, p-value: 3.908e-08

a What is the equation for predicting salary based on educational attainment?

salary= 22.29585 +10.84053 *Education

b What is the coefficient for education?

coeffcient of education =slope= 10.84053

c what is the predicted salary for someone with 4 years of higher ed

we have

salary= 22.29585 +10.84053 *Education

For education=4 we get

salary= 22.29585 +10.84053 *4

=65.65797

Predicted salary for someone with 4 years of higher ed=65.65797


Related Solutions

A social scientist would like to analyze the relationship between educational attainments (years in higher ed)...
A social scientist would like to analyze the relationship between educational attainments (years in higher ed) and annual salary (in $1,000s). He collects the data above. Salary Education 40 3 53 4 80 6 41 2 70 5 54 4 110 8 38 0 42 3 55 4 85 6 42 2 70 5 60 4 140 8 40 0 76 5 65 4 125 8 38 0 a. What is the equation for predicting salary based on educational attainment?...
A social scientist would like to analyze the relationship between educational attainment (in years of higher...
A social scientist would like to analyze the relationship between educational attainment (in years of higher education) and annual salary (in $1,000s). He collects data on 20 individuals. A portion of the data is as follows: Salary Education 32 1 55 1 85 5 55 1 76 8 69 7 114 12 54 0 25 5 36 3 97 5 45 2 62 1 58 9 146 12 58 0 84 2 70 5 129 12 32 0 Find the...
A social scientist would like to analyze the relationship between educational attainment (in years of higher...
A social scientist would like to analyze the relationship between educational attainment (in years of higher education) and annual salary (in $1,000s). He collects data on 20 individuals. A portion of the data is as follows: Salary   Education 38   5 70   5 96   8 55   3 80   9 78   8 108   9 49   0 31   6 37   6 96   5 40   1 69   7 70   7 166   5 63   0 83   1 62   3 131   5 28   0 Find the...
A social scientist would like to analyze the relationship between educational attainment (in years of higher...
A social scientist would like to analyze the relationship between educational attainment (in years of higher education) and annual salary (in $1,000s). He collects data on 20 individuals. A portion of the data is as follows: Salary Education 34 2 63 3 79 5 49 5 72 6 79 6 110 11 58 0 24 2 30 5 96 7 50 6 69 6 62 7 156 10 56 0 91 3 61 9 123 8 37 0 a. Find...
A social scientist would like to analyze the relationship between educational attainment (in years of higher...
A social scientist would like to analyze the relationship between educational attainment (in years of higher education) and annual salary (in $1,000s). He collects data on 20 individuals. A portion of the data is as follows: Salary Education 38 5 70 5 ⋮ ⋮ 28 0 Click here for the Excel Data File Salary Education 38 5 70 5 96 8 55 3 80 9 78 8 108 9 49 0 31 6 37 6 96 5 40 1 69...
A social scientist would like to analyze the relationship between educational attainment (in years of higher...
A social scientist would like to analyze the relationship between educational attainment (in years of higher education) and annual salary (in $1,000s). He collects data on 20 individuals. A portion of the data is as follows: Salary Education 35 5 59 5 ⋮ ⋮ 37 0 a. Find the sample regression equation for the model: Salary = β0 + β1Education + ε. (Round answers to 2 decimal places.) Salaryˆ=Salary^= __________ + __________ Education c. What is the predicted salary for...
A social scientist would like to analyze the relationship between educational attainment (in years of higher...
A social scientist would like to analyze the relationship between educational attainment (in years of higher education) and annual salary (in $1,000s). He collects data on 20 individuals. A portion of the data is as follows: Salary Education 40 3 53 4 ⋮ ⋮ 38 0 Salary Education 40 3 53 4 80 6 42 2 70 5 50 4 110 8 38 0 42 3 55 4 85 6 40 2 70 5 60 4 140 8 40 0...
A social scientist would like to analyze the relationship between educational attainment (in years of higher...
A social scientist would like to analyze the relationship between educational attainment (in years of higher education) and annual salary (in $1,000s). He collects data on 20 individuals. A portion of the data is as follows: Salary Education 35 4 71 1 84 3 52 3 70 7 80 5 107 9 55 0 23 4 33 6 102 6 40 4 67 2 68 5 163 9 55 0 83 8 56 3 125 11 31 0 a. Find...
A social scientist would like to analyze the relationship between educational attainment (in years of higher...
A social scientist would like to analyze the relationship between educational attainment (in years of higher education) and annual salary (in $1,000s). He collects data on 20 individuals. A portion of the data is as follows: Salary Education 35 1 67 6 79 2 46 1 69 7 78 5 111 6 62 0 20 4 25 5 100 6 47 5 64 3 66 9 154 7 61 0 87 1 60 3 123 7 32 0 a. Find...
A social scientist would like to analyze the relationship between educational attainment (in years of higher...
A social scientist would like to analyze the relationship between educational attainment (in years of higher education) and annual salary (in $1,000s). He collects data on 20 individuals. A portion of the data is as follows: Salary Education 43 7 54 4 ⋮ ⋮ 28 0 Click here for the Excel Data File a. Find the sample regression equation for the model: Salary = β0 + β1Education + ε. (Round answers to 2 decimal places.) Salaryˆ= Salary ^ = +...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT