Regression analysis

dani_dj511
21-HumanResourcesSurvey.xlsx
Home>Human Resource Management homework help>Regression analysis

Scatter Plot

Scatter Plot of Salary (in $) based on Age

Salary 24 19 28 20 24 29 26 22 31 28 27 38 35 39 28 27 37 36 35 28 30 39 37 40 36 28 33 42 31 33 49 38 59 45 49 58 54 47 30 41 32 50 39 60 47 45 62 39 40 53 56 40 57 59 56 48 43 42 61 33 44 51 49 38 47 36 49 53 49 39 48 36 49 54 54 36 38 48 48 47 51 49 50 50 50 51 51 52 52 53 62 49 54 55 57 56 56 56 57 57 58 58 59 59 60 60 61 62 63 64 63 66 67 68 69 70 71 72 73 74 39600 31200 40400 33400 42100 42600 39800 33300 54100 35600 46100 34200 43600 56300 37600 34600 45600 37700 48500 48100 54600 50100 47100 46800 38900 44100 46700 56100 37500 45500 58000 52200 43500 46500 45000 67500 62000 52300 50000 56700 48100 45000 54200 47000 57500 50000 47700 49000 75500 70100 66000 62200 60000 47500 53000 56700 48600 54900 57000 57700 47800 47600 59000 53200 72000 45600 56300 43500 43300 70000 54100 46400 55500 60000 64300 61000 48100 38600 52300 56000 60500 64500 67000 58000 38700 52500 62100 79000 76500 65500 43200 60000 62500 72200 67500 61500 68700 56700 82300 67800 39600 61000 67800 81100 45600 39200 58500 77500 68000 39800 73000 67500 68900 68000 43200 76000 69500 39900 64200 46500

X

Y

PlotData

Age Salary
24 39600
19 31200
28 40400
20 33400
24 42100
29 42600
26 39800
22 33300
31 54100
28 35600
27 46100
38 34200
35 43600
39 56300
28 37600
27 34600
37 45600
36 37700
35 48500
28 48100
30 54600
39 50100
37 47100
40 46800
36 38900
28 44100
33 46700
42 56100
31 37500
33 45500
49 58000
38 52200
59 43500
45 46500
49 45000
58 67500
54 62000
47 52300
30 50000
41 56700
32 48100
50 45000
39 54200
60 47000
47 57500
45 50000
62 47700
39 49000
40 75500
53 70100
56 66000
40 62200
57 60000
59 47500
56 53000
48 56700
43 48600
42 54900
61 57000
33 57700
44 47800
51 47600
49 59000
38 53200
47 72000
36 45600
49 56300
53 43500
49 43300
39 70000
48 54100
36 46400
49 55500
54 60000
54 64300
36 61000
38 48100
48 38600
48 52300
47 56000
51 60500
49 64500
50 67000
50 58000
50 38700
51 52500
51 62100
52 79000
52 76500
53 65500
62 43200
49 60000
54 62500
55 72200
57 67500
56 61500
56 68700
56 56700
57 82300
57 67800
58 39600
58 61000
59 67800
59 81100
60 45600
60 39200
61 58500
62 77500
63 68000
64 39800
63 73000
66 67500
67 68900
68 68000
69 43200
70 76000
71 69500
72 39900
73 64200
74 46500

SLRData

Age Salary
24 39600
19 31200
28 40400
20 33400
24 42100
29 42600
26 39800
22 33300
31 54100
28 35600
27 46100
38 34200
35 43600
39 56300
28 37600
27 34600
37 45600
36 37700
35 48500
28 48100
30 54600
39 50100
37 47100
40 46800
36 38900
28 44100
33 46700
42 56100
31 37500
33 45500
49 58000
38 52200
59 43500
45 46500
49 45000
58 67500
54 62000
47 52300
30 50000
41 56700
32 48100
50 45000
39 54200
60 47000
47 57500
45 50000
62 47700
39 49000
40 75500
53 70100
56 66000
40 62200
57 60000
59 47500
56 53000
48 56700
43 48600
42 54900
61 57000
33 57700
44 47800
51 47600
49 59000
38 53200
47 72000
36 45600
49 56300
53 43500
49 43300
39 70000
48 54100
36 46400
49 55500
54 60000
54 64300
36 61000
38 48100
48 38600
48 52300
47 56000
51 60500
49 64500
50 67000
50 58000
50 38700
51 52500
51 62100
52 79000
52 76500
53 65500
62 43200
49 60000
54 62500
55 72200
57 67500
56 61500
56 68700
56 56700
57 82300
57 67800
58 39600
58 61000
59 67800
59 81100
60 45600
60 39200
61 58500
62 77500
63 68000
64 39800
63 73000
66 67500
67 68900
68 68000
69 43200
70 76000
71 69500
72 39900
73 64200
74 46500

SLR

Simple Linear Regression Analysis Salary based on Age Calculations
b1, b0 Coefficients 466.6483 31978.3631
Regression Statistics b1, b0 Standard Error 73.0863 3562.0709
Multiple R 0.5067 R Square, Standard Error 0.2568 10327.1680
R Square 0.2568 F, Residual df 40.7669 118.0000
Adjusted R Square 0.2505 Regression SS, Residual SS 4347808895.6226 12584747021.0441
Standard Error 10327.1680
Observations 120 Confidence level 95%
t Critical Value 1.9803
ANOVA Half Width b0 7053.8702
df SS MS F Significance F Half Width b1 144.7307
Regression 1 4347808895.6226 4347808895.6226 40.7669 0.0000
Residual 118 12584747021.0441 106650398.4834
Total 119 16932555916.6667
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 31978.3631 3562.0709 8.9775 0.0000 24924.4930 39032.2333
Age 466.6483 73.0863 6.3849 0.0000 321.9176 611.3790

DataCopy3

Age
24
19
28
20
24
29
26
22
31
28
27
38
35
39
28
27
37
36
35
28
30
39
37
40
36
28
33
42
31
33
49
38
59
45
49
58
54
47
30
41
32
50
39
60
47
45
62
39
40
53
56
40
57
59
56
48
43
42
61
33
44
51
49
38
47
36
49
53
49
39
48
36
49
54
54
36
38
48
48
47
51
49
50
50
50
51
51
52
52
53
62
49
54
55
57
56
56
56
57
57
58
58
59
59
60
60
61
62
63
64
63
66
67
68
69
70
71
72
73
74

CompleteStatistics3

Age
Age
Mean 47
Median 49
Mode 49
Minimum 19
Maximum 74
Range 55
Variance 167.7815
Standard Deviation 12.9531
Coeff. of Variation 27.56%
Skewness -0.0986
Kurtosis -0.7283
Count 120
Standard Error 1.1824

DataCopy2

Not Minority Minority
39600 31200
40400 33400
39800 42100
35600 42600
46100 33300
43600 54100
37700 34200
48100 56300
54600 37600
50100 34600
47100 45600
46800 48500
38900 44100
56100 46700
37500 43500
45500 62000
58000 45000
52200 54200
46500 50000
45000 66000
67500 62200
52300 47500
50000 53200
56700 45600
48100 43500
47000 46400
57500 48100
47700 38600
49000 56000
75500 64500
70100 58000
60000 62500
53000 72200
56700 67500
48600 61000
54900 67800
57000 39900
57700 64200
47800
47600
59000
72000
56300
43300
70000
54100
55500
60000
64300
61000
52300
60500
67000
38700
52500
62100
79000
76500
65500
43200
60000
61500
68700
56700
82300
67800
39600
81100
45600
39200
58500
77500
68000
39800
73000
67500
68900
68000
43200
76000
69500
46500

CompleteStats 2 Gps

Salary based on Ethnicity
Not Minority Minority
Mean 55678.0487804878 50097.3684210526
Median 55200 47800
Mode 56700 45600
Minimum 35600 31200
Maximum 82300 72200
Range 46700 41000
Variance 141596796.1457 125797560.4552
Standard Deviation 11899.4452 11215.9512
Coeff. of Variation 21.37% 22.39%
Skewness 0.3487 0.1743
Kurtosis -0.7526 -0.9796
Count 82 38
Standard Error 1314.0739 1819.4675

DataCopy

Salary
39600
31200
40400
33400
42100
42600
39800
33300
54100
35600
46100
34200
43600
56300
37600
34600
45600
37700
48500
48100
54600
50100
47100
46800
38900
44100
46700
56100
37500
45500
58000
52200
43500
46500
45000
67500
62000
52300
50000
56700
48100
45000
54200
47000
57500
50000
47700
49000
75500
70100
66000
62200
60000
47500
53000
56700
48600
54900
57000
57700
47800
47600
59000
53200
72000
45600
56300
43500
43300
70000
54100
46400
55500
60000
64300
61000
48100
38600
52300
56000
60500
64500
67000
58000
38700
52500
62100
79000
76500
65500
43200
60000
62500
72200
67500
61500
68700
56700
82300
67800
39600
61000
67800
81100
45600
39200
58500
77500
68000
39800
73000
67500
68900
68000
43200
76000
69500
39900
64200
46500

CompleteStats

Salary
Salary
Mean 53910.8333333333
Median 53100
Mode 45600
Minimum 31200
Maximum 82300
Range 51100
Variance 142290385.8543
Standard Deviation 11928.5534
Coeff. of Variation 22.13%
Skewness 0.3069
Kurtosis -0.6662
Count 120
Standard Error 1088.9230

Variable INFO

The data are a random sample of 120 employee responses to a survey conducted by the VP of Human Resourecs at a large company.
Source: INFO 501 class at Montclair State University
Variables
Salary in thousands of dollars
Age in years
YrsWork in years
JGClass job-grade classification of 1, 3, 5, 7, 9, 11 (lowest skill job to highest skill job)
Ethnicity (Minority, Not Minority)
Gender (Male, Female)

FiveNumbers

Salary (in $)
Five-Number Summary
Minimum 31200
First Quartile 45000
Median 53100
Third Quartile 62200
Maximum 82300

BoxPlot

Salary (in $)

Salary

31200 31200 31200 0.5 1 1.5 45000 45000 45000 0.5 1 1.5 53100 53100 53100 0.5 1 1.5 62200 62200 62200 0.5 1 1.5 82300 82300 82300 0.5 1 1.5 31200 82300 1 1 45000 62200 0.5 0.5 45000 62200 1.5 1.5

ForBoxPlot

31200 0.5
31200 1
31200 1.5
45000 0.5
45000 1
45000 1.5
53100 0.5
53100 1
53100 1.5
62200 0.5
62200 1
62200 1.5
82300 0.5
82300 1
82300 1.5
31200 1
82300 1
45000 0.5
62200 0.5
45000 1.5
62200 1.5

FiveNumbers 2 Gps

Salary based on Ethnicity
Five-Number Summary
Not Minority Minority
Minimum 35600 31200
First Quartile 46500 42600
Median 55200 47800
Third Quartile 65500 61000
Maximum 82300 72200

BoxPlot 2 Gps

Salary based on Ethnicity

Not Minority

35600 35600 35600 0.5 1 1.5 46500 46500 46500 0.5 1 1.5 55200 55200 55200 0.5 1 1.5 65500 65500 65500 0.5 1 1.5 82300 82300 82300 0.5 1 1.5 35600 82300 1 1 46500 65500 0.5 0.5 46500 65500 1.5 1.5

Minority

31200 31200 31200 2 2.5 3 42600 42600 42600 2 2.5 3 47800 47800 47800 2 2.5 3 61000 61000 61000 2 2.5 3 72200 72200 72200 2 2.5 3 31200 72200 2.5 2.5 42600 61000 2 2 42600 61000 3 3

ForBoxPlot2

35600 0.5 31200 2
35600 1 31200 2.5
35600 1.5 31200 3
46500 0.5 42600 2
46500 1 42600 2.5
46500 1.5 42600 3
55200 0.5 47800 2
55200 1 47800 2.5
55200 1.5 47800 3
65500 0.5 61000 2
65500 1 61000 2.5
65500 1.5 61000 3
82300 0.5 72200 2
82300 1 72200 2.5
82300 1.5 72200 3
35600 1 31200 2.5
82300 1 72200 2.5
46500 0.5 42600 2
65500 0.5 61000 2
46500 1.5 42600 3
65500 1.5 61000 3

FiveNumbers3

Age
Five-Number Summary
Minimum 19
First Quartile 37
Median 49
Third Quartile 57
Maximum 74

BoxPlot3

Age

Age

19 19 19 0.5 1 1.5 37 37 37 0.5 1 1.5 49 49 49 0.5 1 1.5 57 57 57 0.5 1 1.5 74 74 74 0.5 1 1.5 19 74 1 1 37 57 0.5 0.5 37 57 1.5 1.5

ForBoxPlot3

19 0.5
19 1
19 1.5
37 0.5
37 1
37 1.5
49 0.5
49 1
49 1.5
57 0.5
57 1
57 1.5
74 0.5
74 1
74 1.5
19 1
74 1
37 0.5
57 0.5
37 1.5
57 1.5

DataCopy4

Ethnicity
Not Minority
Minority
Not Minority
Minority
Minority
Minority
Not Minority
Minority
Minority
Not Minority
Not Minority
Minority
Not Minority
Minority
Minority
Minority
Minority
Not Minority
Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Minority
Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Minority
Not Minority
Not Minority
Not Minority
Minority
Not Minority
Not Minority
Not Minority
Not Minority
Minority
Minority
Not Minority
Not Minority
Minority
Not Minority
Not Minority
Not Minority
Not Minority
Minority
Minority
Not Minority
Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Minority
Not Minority
Minority
Not Minority
Minority
Not Minority
Not Minority
Not Minority
Minority
Not Minority
Not Minority
Not Minority
Not Minority
Minority
Minority
Not Minority
Minority
Not Minority
Minority
Not Minority
Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Minority
Minority
Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Minority
Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Not Minority
Minority
Minority
Not Minority

Bar Chart

Ethnicity

Minority Not Minority 38 82

Ethnicity

OneWayTable

Ethnicity
Count of Ethnicity
Ethnicity Total
Minority 38
Not Minority 82
Grand Total 120

SideBySide2

Gender based on Ethnicity

Female Minority Not Minority 11 42 Male Minority Not Minority 27 40

TwoWayTable2

Gender based on Ethnicity
Count of Ethnicity Gender
Ethnicity Female Male Grand Total
Minority 11 27 38
Not Minority 42 40 82
Grand Total 53 67 120

DATA

Salary Age YrsWork JGClass Ethnicity Gender
39600 24 1 5 Not Minority Male
31200 19 1 3 Minority Female
40400 28 3 3 Not Minority Female
33400 20 2 3 Minority Male
42100 24 2 5 Minority Male
42600 29 3 5 Minority Female
39800 26 2 5 Not Minority Female
33300 22 2 3 Minority Female
54100 31 1 7 Minority Male
35600 28 4 3 Not Minority Female
46100 27 4 5 Not Minority Male
34200 38 6 3 Minority Female
43600 35 3 5 Not Minority Female
56300 39 2 7 Minority Male
37600 28 5 5 Minority Female
34600 27 6 3 Minority Female
45600 37 3 5 Minority Male
37700 36 1 3 Not Minority Female
48500 35 2 7 Minority Male
48100 28 3 5 Not Minority Female
54600 30 7 7 Not Minority Male
50100 39 4 7 Not Minority Male
47100 37 6 5 Not Minority Male
46800 40 2 5 Not Minority Male
38900 36 2 5 Not Minority Female
44100 28 3 7 Minority Male
46700 33 10 5 Minority Female
56100 42 4 7 Not Minority Male
37500 31 5 3 Not Minority Male
45500 33 9 5 Not Minority Male
58000 49 3 9 Not Minority Female
52200 38 6 5 Not Minority Female
43500 59 9 7 Minority Male
46500 45 3 7 Not Minority Female
45000 49 5 7 Not Minority Male
67500 58 7 7 Not Minority Male
62000 54 6 9 Minority Male
52300 47 2 7 Not Minority Female
50000 30 8 5 Not Minority Female
56700 41 4 7 Not Minority Male
48100 32 6 3 Not Minority Male
45000 50 2 7 Minority Male
54200 39 6 7 Minority Female
47000 60 10 5 Not Minority Female
57500 47 3 7 Not Minority Female
50000 45 5 7 Minority Male
47700 62 4 9 Not Minority Female
49000 39 9 5 Not Minority Female
75500 40 12 9 Not Minority Male
70100 53 5 7 Not Minority Female
66000 56 4 11 Minority Male
62200 40 14 9 Minority Male
60000 57 7 7 Not Minority Female
47500 59 5 7 Minority Male
53000 56 8 5 Not Minority Male
56700 48 7 7 Not Minority Male
48600 43 2 7 Not Minority Female
54900 42 3 5 Not Minority Male
57000 61 5 7 Not Minority Female
57700 33 7 7 Not Minority Female
47800 44 8 7 Not Minority Female
47600 51 3 5 Not Minority Female
59000 49 6 9 Not Minority Female
53200 38 4 7 Minority Male
72000 47 3 7 Not Minority Female
45600 36 9 7 Minority Male
56300 49 2 5 Not Minority Male
43500 53 7 7 Minority Female
43300 49 2 3 Not Minority Male
70000 39 12 9 Not Minority Female
54100 48 3 5 Not Minority Female
46400 36 5 7 Minority Male
55500 49 5 5 Not Minority Female
60000 54 6 7 Not Minority Female
64300 54 3 5 Not Minority Male
61000 36 7 9 Not Minority Male
48100 38 9 7 Minority Male
38600 48 6 5 Minority Male
52300 48 4 3 Not Minority Female
56000 47 14 7 Minority Male
60500 51 9 7 Not Minority Male
64500 49 7 7 Minority Male
67000 50 5 7 Not Minority Female
58000 50 15 7 Minority Female
38700 50 3 3 Not Minority Female
52500 51 9 5 Not Minority Male
62100 51 3 7 Not Minority Female
79000 52 15 11 Not Minority Male
76500 52 7 9 Not Minority Male
65500 53 9 9 Not Minority Female
43200 62 3 5 Not Minority Female
60000 49 9 9 Not Minority Male
62500 54 8 9 Minority Male
72200 55 15 11 Minority Male
67500 57 12 11 Minority Female
61500 56 9 7 Not Minority Male
68700 56 10 9 Not Minority Male
56700 56 6 7 Not Minority Female
82300 57 15 11 Not Minority Male
67800 57 5 9 Not Minority Male
39600 58 3 5 Not Minority Female
61000 58 12 7 Minority Male
67800 59 7 9 Minority Male
81100 59 15 11 Not Minority Male
45600 60 16 5 Not Minority Male
39200 60 14 5 Not Minority Female
58500 61 8 7 Not Minority Female
77500 62 10 11 Not Minority Male
68000 63 9 9 Not Minority Male
39800 64 5 5 Not Minority Female
73000 63 15 11 Not Minority Male
67500 66 2 9 Not Minority Female
68900 67 5 9 Not Minority Female
68000 68 8 9 Not Minority Male
43200 69 10 5 Not Minority Male
76000 70 9 9 Not Minority Male
69500 71 18 9 Not Minority Male
39900 72 8 5 Minority Male
64200 73 15 9 Minority Male
46500 74 10 5 Not Minority Male

% Polygons 2 Groups

Percentage Polygons of Salary (in $) based on Ethnicity

Histogram

Freq. & % Distribution

Frequency Distribution for Salary
bins midpts Frequency Percentage
29999.9 0 0.0%
39999.9 35000 18 15.0%
49999.9 45000 34 28.3%
59999.9 55000 29 24.2%
69999.9 65000 27 22.5%
79999.9 75000 10 8.3%
89999.9 85000 2 1.7%
Total 120 100.0%