0% found this document useful (0 votes)
54 views12 pages

Years Education Residual Plot: Regression Statistics

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 12

SUMMARY OUTPUT

Years Education Re
Regression Statistics
20000
Multiple R 0.905155
10000

Residuals
R Square 0.819306
Adjusted R Square 0.791507 0
Standard Error 5022.367 -10000 0 2 4 6

Observations 46 -20000
Years Educa
ANOVA
df SS MS F Significance F
Regression 6 4.46E+09 7.43E+08 29.47246 4.9E-13
Residual 39 9.84E+08 25224166
Total 45 5.44E+09

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%
Lower 95.0%
Upper 95.0%
Intercept 19589.47 2862.638 6.84 0.00 13799.24 25379.7 13799.24 25379.7
Years Previous Experience -106.548 213.079 -0.50 0.62 -537.541 324.4451 -537.541 324.4451
Years Employed 621.0566 125.4148 4.95 0.00 367.3811 874.7321 367.3811 874.7321
Years Education 1631.831 362.7565 4.50 0.00 898.0865 2365.575 898.0865 2365.575
Gender -1654.07 1558.115 -1.06 0.29 -4805.66 1497.51 -4805.66 1497.51
Department 2134.289 624.7683 3.42 0.00 870.5761 3398.003 870.5761 3398.003
Number Supervised 134.0144 88.1399 1.52 0.14 -44.2654 312.2941 -44.2654 312.2941

RESIDUAL OUTPUT PROBABILITY OUTPUT

Observation Predicted Salary


Residuals
Standard Residuals Percentile Salary
1 68719.68 -3232.68 -0.6914 1.086957 23654
2 46889.45 -705.454 -0.15088 3.26087 24749
3 33040.03 -258.028 -0.05519 5.434783 26452
4 46447.14 8451.86 1.807665 7.608696 26548
5 36948.55 -2079.55 -0.44477 9.782609 26578
6 34759.6 727.3989 0.155574 11.95652 28985
7 31393.39 -4845.39 -1.03632 14.13043 29548
8 44288.43 -11368.4 -2.43145 16.30435 29876
9 25821.59 3726.413 0.796997 18.47826 31425
10 41832.9 -7601.9 -1.62588 20.65217 31528
11 24606.29 -952.293 -0.20367 22.82609 32782
12 41667.42 -2336.42 -0.49971 25 32920
13 36354.96 157.042 0.033588 27.17391 34231
14 33620.89 1846.114 0.394843 29.34783 34632
15 63155.93 5269.068 1.126936 31.52174 34869
16 34458.14 1009.86 0.215987 33.69565 34987
17 42177.14 -5599.14 -1.19753 35.86957 35467
18 39438.64 389.3571 0.083275 38.04348 35468
19 34985.93 1501.067 0.321045 40.21739 35487
20 44164.89 -6616.89 -1.41521 42.3913 35631
21 28114.48 3413.518 0.730075 44.56522 36431
22 37333.04 -2701.04 -0.57769 46.73913 36487
23 45095.66 1115.337 0.238546 48.91304 36512
24 29011.65 864.3473 0.184865 51.08696 36571
25 33420.81 10253.19 2.192929 53.26087 36578
26 47513.49 -8528.49 -1.82405 55.43478 37548
27 51711.78 1522.218 0.325569 57.6087 38791
28 48591.36 3106.641 0.664441 59.78261 38985
29 46043.16 -4154.16 -0.88848 61.95652 39331
30 43705.04 -4914.04 -1.051 64.13043 39743
31 63819.18 5426.816 1.160675 66.30435 39828
32 48243.78 451.2215 0.096506 68.47826 41255
33 35088.48 -101.48 -0.0217 70.65217 41889
34 27026.52 1958.481 0.418875 72.82609 43674
35 38222.13 -2591.13 -0.55418 75 46184
36 46766.79 7912.205 1.692244 77.17391 46211
37 39715.94 27.05577 0.005787 79.34783 47536
38 43616.99 -2361.99 -0.50518 81.52174 48695
39 34162.64 2268.355 0.485151 83.69565 51698
40 25096.38 1481.622 0.316886 85.86957 53234
41 45102.49 2433.509 0.520473 88.04348 54679
42 34273.19 2297.807 0.49145 90.21739 54899
43 44849.82 11476.18 2.4545 92.3913 56326
44 37009.61 -5584.61 -1.19442 94.56522 65487
45 23716.94 1032.056 0.220734 96.73913 68425
46 30037.63 -3585.63 -0.76689 98.91304 69246
ars Education Residual Plot
00
00
Number Supervised Residual Plot
20000 Department Residual Plot
0
Normal Probability
00 0 2 4 6 8 10 12 14 10000 20000

Residuals
0 80000
00 10000

Residuals
-10000 0 5 10 150 20 60000 25 30 35 40 45 50
Years Education 40000

Salary
-20000 -10000 0.5 200001 1.5 2 2.5 3 3.5 4
Number Supervised Line Fit Plot Number Supervised
-20000 0
Years Employed Line Fit Gender
Plot Line Fit Plot $80,000 0 20
Department
40 60 8
Years Previous Experience Line Fit Plot
$80,000
$80,000
$60,000 Sample Percentile
Salary
Years Education Line
Department
Fit Plot Line Fit Plot $40,000

Salary
$60,000 Predicted Sal
$80,000 $60,000
Salary $20,000
$40,000
Salary

$60,000 $40,000 Salary

Salary
$80,000 $80,000 $0
Predicted Salary
Upper 95.0% $20,000 Salary Predicted Salary
$40,000 $20,000 0 5 101520253035404550
Salary

$60,000
$0 $60,000
$20,000 Predicted
$0 Salary Salary Salary
$40,000
0 5 10 15 20 25 $40,000
Salary

Number Supervised
$0
30 Salary
0Predicted
0.2 0.4 Salary
0.6 0.8 1 1.2 Predicted Salary
$20,000 $20,000
Years Employed
$0 0 2 4 6 8 101214161820$0 Gender
0 Previous
Years 2 4 Experience
6 8 10 12 14 0.5 1 1.5 2 2.5 3 3.5 4 4.5
Years Education Department

Years Employed
20000

Gender Years Previous


Residual PlotExperience Residual Plot10000

Residuals
0
20000 20000
-10000 0 5 10
10000 10000
-20000
Residuals

Residuals

0 0
Year
-10000 0 0.2 0.4 0.6 0 0.82
-10000 4 1 6 81.2 10 12 14 16 18 20

-20000 -20000
Gender Years Previous Experience
ment Residual Plot
Normal Probability Plot
0
0
0
1.5 2 2.5 3 3.5 4 4.5
ervised Line Fit Plot
0
0
0 20 40 60 80 100 120
Department
Sample Percentile
Salary
Predicted Salary

0253035404550
pervised

Years Employed Residual Plot


20000
10000
Residuals

0
-10000 0 5 10 15 20 25 30

-20000
Years Employed
SUMMARY OUTPUT

Regression Statistics Years Previous Ex


Multiple R 0.905155 20000
R Square 0.819306
10000
Adjusted R 0.791507

Residuals
0
Standard E 5022.367
Observatio 46 -10000 0 2 4

-20000
ANOVA Yea
df SS MS F Significance F
Regression 6 4.46E+09 7.43E+08 29.47246 4.9E-13
Residual 39 9.84E+08 25224166
Total 45 5.44E+09

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%
Lower 95.0%
Upper 95.0% Gende
Intercept 19589.47 2862.638 6.843154 3.52E-08 13799.24 25379.7 13799.24 25379.7 20000
Years Prev -106.548 213.079 -0.50004 0.619857 -537.541 324.4451 -537.541 324.4451
10000

Residuals
Years Empl 621.0566 125.4148 4.952018 1.46E-05 367.3811 874.7321 367.3811 874.7321
0
Years Educ 1631.831 362.7565 4.498419 6.01E-05 898.0865 2365.575 898.0865 2365.575
Gender -1654.07 1558.115 -1.06159 0.294953 -4805.66 1497.51 -4805.66 1497.51 -10000 0 0.2

Departmen2134.289 624.7683 3.416129 0.001497 870.5761 3398.003 870.5761 3398.003 -20000


Number Su134.0144 88.1399 1.520473 0.136459 -44.2654 312.2941 -44.2654 312.2941

RESIDUAL OUTPUT PROBABILITY OUTPUT

Observation
Predicted Salary
Residuals
Standard Residuals Percentile Salary
1 68719.68 -3232.68 -0.6914 1.086957 23654
2 46889.45 -705.454 -0.15088 3.26087 24749
3 33040.03 -258.028 -0.05519 5.434783 26452
4 46447.14 8451.86 1.807665 7.608696 26548
5 36948.55 -2079.55 -0.44477 9.782609 26578
6 34759.6 727.3989 0.155574 11.95652 28985
7 31393.39 -4845.39 -1.03632 14.13043 29548
8 44288.43 -11368.4 -2.43145 16.30435 29876
9 25821.59 3726.413 0.796997 18.47826 31425
10 41832.9 -7601.9 -1.62588 20.65217 31528
11 24606.29 -952.293 -0.20367 22.82609 32782
12 41667.42 -2336.42 -0.49971 25 32920
13 36354.96 157.042 0.033588 27.17391 34231
14 33620.89 1846.114 0.394843 29.34783 34632
15 63155.93 5269.068 1.126936 31.52174 34869
16 34458.14 1009.86 0.215987 33.69565 34987
17 42177.14 -5599.14 -1.19753 35.86957 35467
18 39438.64 389.3571 0.083275 38.04348 35468
19 34985.93 1501.067 0.321045 40.21739 35487
20 44164.89 -6616.89 -1.41521 42.3913 35631
21 28114.48 3413.518 0.730075 44.56522 36431
22 37333.04 -2701.04 -0.57769 46.73913 36487
23 45095.66 1115.337 0.238546 48.91304 36512
24 29011.65 864.3473 0.184865 51.08696 36571
25 33420.81 10253.19 2.192929 53.26087 36578
26 47513.49 -8528.49 -1.82405 55.43478 37548
27 51711.78 1522.218 0.325569 57.6087 38791
28 48591.36 3106.641 0.664441 59.78261 38985
29 46043.16 -4154.16 -0.88848 61.95652 39331
30 43705.04 -4914.04 -1.051 64.13043 39743
31 63819.18 5426.816 1.160675 66.30435 39828
32 48243.78 451.2215 0.096506 68.47826 41255
33 35088.48 -101.48 -0.0217 70.65217 41889
34 27026.52 1958.481 0.418875 72.82609 43674
35 38222.13 -2591.13 -0.55418 75 46184
36 46766.79 7912.205 1.692244 77.17391 46211
37 39715.94 27.05577 0.005787 79.34783 47536
38 43616.99 -2361.99 -0.50518 81.52174 48695
39 34162.64 2268.355 0.485151 83.69565 51698
40 25096.38 1481.622 0.316886 85.86957 53234
41 45102.49 2433.509 0.520473 88.04348 54679
42 34273.19 2297.807 0.49145 90.21739 54899
43 44849.82 11476.18 2.4545 92.3913 56326
44 37009.61 -5584.61 -1.19442 94.56522 65487
45 23716.94 1032.056 0.220734 96.73913 68425
46 30037.63 -3585.63 -0.76689 98.91304 69246
Years Education Residual Plot
Years Previous Experience Residual Plot 20000
20000 10000 Number Supe

Residuals
10000 0 20000
Residuals

0 -10000 0 2 4 6 8 10 10000
12 14

Residuals
-10000 0 2 4 6 8 10 12 14 16 18 20
-20000 0
-20000 Years Education -10000 0 5 10
Years Previous Experience -20000

Gender Residual Plot


Years Employed Resid
20000
20000
10000
Residuals

10000

Residuals
0
0
-10000 0 0.2 0.4 0.6 0.8 1 1.2
-10000 0 5 10 15
-20000 Department Residual Plot -20000
Gender 20000 Years Employed
10000
Residuals

0
-10000 0.5 1 1.5 2 2.5 3 3.5 4 4.5

-20000
Department
Residual Plot
Number Supervised Residual Plot
20000
6 8 10 10000
12 14
Residuals

0
ucation -10000 0 5 10 15 20 25 30 35 40 45 50

-20000
Number Supervised

ars Employed Residual Plot


000
000
0
000 0 5 10 15 20 25 30

000
Years Employed

Normal Probability Plot


80000
60000
40000
Salary

20000
0
0 20 40 60 80 100 120
Sample Percentile
Employee Salary Years Previous Experience Years Employed Years Education Gender
1 $65,487 0 27 12 1
2 $46,184 3 20 4 0
3 $32,782 1 0 7 0
4 $54,899 5 12 8 1
5 $34,869 5 7 4 1
6 $35,487 2 8 2 1
7 $26,548 1 5 0 0
8 $32,920 3 15 9 1
9 $29,548 6 5 1 0
10 $34,231 2 6 6 0
11 $23,654 0 0 0 1
12 $39,331 3 9 6 1
13 $36,512 6 6 4 1
14 $35,467 6 3 6 1
15 $68,425 2 25 12 0
16 $35,468 5 9 4 1
17 $36,578 4 4 8 0
18 $39,828 6 18 5 1
19 $36,487 5 6 2 0
20 $37,548 9 19 4 0
21 $31,528 11 3 3 0
22 $34,632 4 5 4 0
23 $46,211 5 14 6 1
24 $29,876 0 2 3 1
25 $43,674 9 6 4 0
26 $38,985 7 18 9 0
27 $53,234 0 25 6 0
28 $51,698 6 18 6 0
29 $41,889 16 22 7 0
30 $38,791 4 21 5 0
31 $69,246 3 22 10 0
32 $48,695 19 6 8 0
33 $34,987 6 9 2 1
34 $28,985 1 0 4 1
35 $35,631 4 6 4 0
36 $54,679 3 20 6 1
37 $39,743 6 9 5 1
38 $41,255 4 9 6 0
39 $36,431 4 9 4 1
40 $26,578 6 0 2 1
41 $47,536 5 15 6 0
42 $36,571 1 6 4 0
43 $56,326 3 12 8 0
44 $31,425 6 7 5 1
45 $24,749 2 6 0 1
46 $26,452 3 1 2 1
Department Number Supervised Thisisis fictitious
This fictitiousdata.
data.
4 44
4 1
1 0
4 0
4 1
4 2
4 2
1 4
1 0
4 3
3 2
4 1
4 2
2 3
4 1
2 5
3 8
1 5
4 3
3 6
1 6
4 0
4 5
2 5
2 2
1 5
3 3
4 1
1 7
1 9
4 45
4 40
4 3
1 4
4 2
3 4
4 1
4 4
2 2
2 2
3 4
2 2
2 6
3 6
1 1
4 0

You might also like