A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA

1 Employee EducLev JobGrade YrHired YrBorn Gender YrsPrior PCJob Salary

2 1 3 1 92 69 Male 1 No 32
3 2 1 1 81 57 Female 1 No 39.1
4 3 1 1 83 60 Female 0 No 33.2
5 4 2 1 87 55 Female 7 No 30.6
6 5 3 1 92 67 Male 0 No 29
7 6 3 1 92 71 Female 0 No 30.5
8 7 3 1 91 68 Female 0 No 30
9 8 3 1 87 62 Male 2 No 27
10 9 1 1 91 33 Female 0 No 34
11 10 3 1 86 64 Female 0 No 29.5
12 11 3 1 86 61 Female 2 No 26.8
13 12 2 1 87 58 Female 8 No 31.3
14 13 2 1 86 58 Female 0 No 31.2
15 14 2 1 85 37 Female 6 No 34.7
16 15 3 1 91 62 Female 0 No 30
17 16 3 1 92 68 Female 0 No 31
18 17 3 1 89 65 Female 0 No 27
19 18 2 1 87 58 Female 9 No 29.6
20 19 3 1 90 51 Female 6 No 32.6
21 20 2 1 91 66 Female 3 No 29.6
22 21 3 1 91 59 Female 2 No 29.5
23 22 2 1 92 67 Male 3 No 31
24 23 1 1 90 50 Female 0 No 28.5
25 24 2 1 92 62 Male 4 No 26.7
26 25 3 1 92 71 Male 1 No 30.75
27 26 3 1 92 68 Male 1 No 29.5
28 27 2 1 79 35 Female 6 No 42.2
29 28 1 1 82 47 Female 0 No 37.6
30 29 1 1 83 55 Female 6 No 34
31 30 2 1 91 62 Female 7 No 33
32 31 1 1 88 60 Female 4 No 28.76
33 32 1 1 84 51 Female 0 No 35.4
34 33 3 1 92 52 Male 8 No 31
35 34 2 1 77 49 Female 2 No 38.8
36 35 2 1 81 53 Female 0 No 34.3
37 36 1 1 76 48 Female 0 No 35
38 37 3 1 92 70 Female 2 Yes 34.6
39 38 2 1 93 65 Female 4 No 28.5
40 39 1 1 84 55 Female 0 No 29.5
41 40 3 1 92 69 Male 2 No 30.5
42 41 3 1 90 63 Female 1 No 34.2
43 42 1 1 80 44 Female 0 No 43.6
44 43 5 1 88 60 Female 0 Yes 33.5
45 44 3 1 83 58 Female 1 No 33
46 45 1 1 77 51 Female 0 No 45.3
47 46 1 1 78 42 Male 3 No 38.8
48 47 1 1 85 55 Female 0 No 29.9
49 48 3 1 90 44 Male 10 No 31.2
50 49 1 1 80 53 Female 0 No 34
51 50 2 1 93 42 Female 0 No 30.45
52 51 1 1 92 37 Male 3 No 35.5
53 52 1 1 91 51 Female 10 Yes 34
54 53 2 1 88 64 Female 0 No 29.1
55 54 1 1 87 31 Female 0 No 29.65
56 55 3 1 80 48 Female 1 No 29.2
57 56 3 1 86 58 Female 0 Yes 29.8
58 57 2 1 79 49 Female 0 No 33.5
59 58 1 1 87 40 Female 0 No 34
60 59 1 1 86 56 Female 0 No 29.6
61 60 3 1 77 44 Female 0 No 34
62 61 2 2 92 58 Female 8 No 37.25
63 62 2 2 89 65 Male 3 No 33
64 63 3 2 91 69 Female 0 No 28.6
65 64 5 2 90 54 Female 1 Yes 36
66 65 3 2 91 61 Female 4 Yes 37.3
67 66 2 2 88 38 Male 4 No 29.9
68 67 1 2 84 42 Female 8 No 31.5
69 68 3 2 90 63 Female 4 Yes 41.4
70 69 1 2 78 51 Female 5 No 32.74
71 70 3 2 92 70 Male 1 No 33.5
72 71 1 2 90 64 Female 9 No 32
73 72 1 2 86 45 Female 0 No 30.8
74 73 5 2 92 48 Female 3 Yes 42
75 74 3 2 91 60 Male 0 No 34
76 75 2 2 79 52 Female 0 No 32.5
77 76 2 2 86 49 Female 10 No 31.7
78 77 5 2 92 60 Male 0 No 36.5
79 78 3 2 91 73 Male 0 No 33
80 79 2 2 87 37 Female 0 No 31.2
81 80 5 2 87 55 Female 0 No 34
82 81 3 2 89 65 Female 0 No 33
83 82 5 2 91 66 Female 4 No 33.9
84 83 1 2 92 64 Female 9 Yes 39
85 84 2 2 83 43 Male 18 No 34.92
86 85 5 2 92 62 Male 5 No 39
87 86 1 2 87 46 Female 0 No 34
88 87 2 2 89 61 Female 7 No 31.9
89 88 5 2 92 69 Male 1 No 37
90 89 5 2 91 67 Male 0 No 34
91 90 5 2 92 60 Female 2 No 36.4
92 91 1 2 80 48 Female 1 Yes 38.2
93 92 1 2 80 44 Female 0 No 35.3
94 93 3 2 92 69 Male 2 No 34.5
95 94 3 2 83 62 Female 0 No 30.5
96 95 4 2 93 68 Male 2 No 30
97 96 5 2 87 61 Female 0 Yes 37.3
98 97 4 2 90 66 Female 0 No 40.2
99 98 3 2 90 68 Male 0 No 35.5
100 99 1 2 84 52 Female 0 No 35
101 100 3 2 91 59 Female 3 No 38
102 101 1 2 86 57 Female 0 No 35.3
103 102 2 2 81 35 Female 0 No 34.1
104 103 3 3 91 52 Female 5 Yes 43.2
105 104 2 3 80 47 Female 5 No 36.1
106 105 5 3 88 63 Female 3 No 34.6
107 106 3 3 90 64 Male 0 No 36
108 107 5 3 88 66 Female 2 No 36.2
109 108 3 3 88 60 Female 0 No 37.5
110 109 3 3 91 58 Female 12 No 41
111 110 2 3 85 52 Female 0 No 35.6
112 111 3 3 90 62 Female 5 No 39.8
113 112 4 3 84 37 Female 4 Yes 41.3
114 113 3 3 86 51 Female 7 No 42.5
115 114 3 3 91 58 Female 8 Yes 45.8
116 115 5 3 90 47 Female 6 No 34.9
117 116 5 3 91 69 Male 0 No 41.5
118 117 3 3 90 70 Female 0 No 38
119 118 4 3 89 57 Female 0 No 35
120 119 3 3 89 54 Female 0 No 40
121 120 3 3 90 66 Male 0 No 36
122 121 2 3 86 36 Female 0 No 33.7
123 122 2 3 90 66 Male 4 No 36.3
124 123 3 3 92 68 Female 2 Yes 38
125 124 5 3 91 65 Female 0 No 39.5
126 125 2 3 88 61 Female 5 No 36.3
127 126 3 3 87 60 Female 2 No 32.5
128 127 2 3 83 45 Female 6 No 37
129 128 5 3 92 62 Female 1 No 32.6
130 129 3 3 91 69 Female 0 No 36
131 130 5 3 92 59 Female 0 No 35
132 131 5 3 92 62 Female 5 Yes 43.6
133 132 3 3 87 48 Female 0 No 33.8
134 133 1 3 74 44 Female 0 No 35.3
135 134 1 3 79 53 Female 6 No 42.4
136 135 5 3 90 64 Male 0 No 39.5
137 136 2 3 70 33 Female 10 No 43.5
138 137 5 3 89 49 Male 1 No 42
139 138 3 3 74 35 Female 9 No 40.3
140 139 4 3 89 52 Male 5 No 44
141 140 1 3 70 42 Female 2 No 40.66
142 141 3 3 82 57 Female 1 No 39.7
143 142 5 3 89 56 Female 5 No 45
144 143 5 3 88 60 Female 0 No 43.9
145 144 4 3 87 55 Female 3 No 38
146 145 5 3 90 63 Female 3 No 39.02
147 146 5 4 90 62 Male 3 No 44.5
148 147 5 4 91 65 Male 1 No 41
149 148 5 4 89 58 Male 3 No 44
150 149 5 4 89 65 Male 0 No 44
151 150 5 4 90 63 Female 4 No 42.5
152 151 5 4 88 58 Female 3 No 40.26
153 152 5 4 90 66 Male 1 No 44.5
154 153 1 4 82 45 Female 9 No 35.5
155 154 5 4 89 66 Male 0 No 42.5
156 155 5 4 88 63 Female 0 No 44
157 156 5 4 89 64 Male 2 No 45
158 157 2 4 80 48 Female 4 No 44.4
159 158 3 4 78 51 Female 0 No 38
160 159 5 4 91 68 Male 0 No 41.8
161 160 1 4 72 40 Male 0 No 45.5
162 161 3 4 90 43 Male 4 No 42.5
163 162 5 4 92 45 Female 12 No 44
164 163 3 4 76 36 Female 8 Yes 54.3
165 164 3 4 69 48 Female 0 No 44.8
166 165 3 4 89 52 Male 4 No 47
167 166 5 4 80 54 Female 0 No 43.8
168 167 1 4 83 56 Female 4 Yes 48
169 168 5 4 86 56 Female 0 No 42.7
170 169 3 4 81 55 Female 1 Yes 48.5
171 170 3 4 79 46 Female 0 No 42
172 171 2 4 79 42 Female 1 No 45.5
173 172 3 4 84 58 Female 0 No 44.5
174 173 2 4 82 55 Female 2 No 51.2
175 174 5 5 88 61 Male 0 No 47.5
176 175 5 5 87 58 Female 0 No 44.5
177 176 5 5 87 64 Male 0 No 47
178 177 5 5 89 54 Male 10 No 47
179 178 3 5 78 49 Female 4 No 43.1
180 179 5 5 87 58 Male 2 No 49
181 180 5 5 87 62 Male 0 No 48.5
182 181 3 5 87 60 Female 5 No 45
183 182 5 5 79 46 Female 5 No 52.5
184 183 5 5 89 62 Male 2 No 47.5
185 184 5 5 88 64 Male 0 No 48
186 185 5 5 87 46 Male 4 No 46.5
187 186 5 5 83 55 Female 2 No 61.5
188 187 5 5 86 58 Female 2 No 50
189 188 5 5 83 49 Female 2 No 61.8
190 189 4 5 79 52 Female 0 No 43
191 190 5 5 84 59 Male 1 No 47
192 191 5 5 86 58 Female 6 No 58.5
193 192 5 5 79 55 Male 7 No 55
194 193 3 5 71 41 Male 3 No 57
195 194 5 5 78 38 Male 1 No 57
196 195 5 6 81 46 Male 0 No 60
197 196 3 6 82 54 Male 0 No 60
198 197 5 6 76 36 Male 4 No 59
199 198 5 6 83 44 Male 0 No 60
200 199 5 6 75 50 Male 0 No 65
201 200 5 6 75 39 Male 1 No 52
202 201 5 6 73 38 Male 0 No 58
203 202 4 6 74 42 Male 0 No 60
204 203 5 6 56 30 Male 0 No 74
205 204 3 6 61 35 Male 0 No 95
206 205 5 6 59 34 Male 0 No 97
207 206 5 6 63 33 Male 0 No 88
208 207 5 6 60 36 Male 0 No 94
209 208 5 6 62 33 Female 0 No 30
Sum - Salary Gender
Employee Female Male
1 32
2 39.1
3 33.2
4 30.6
5 29
6 30.5
7 30
8 27
9 34
10 29.5
11 26.8
12 31.3
13 31.2
14 34.7
15 30
16 31
17 27
18 29.6
19 32.6
20 29.6
21 29.5
22 31
23 28.5
24 26.7
25 30.75
26 29.5
27 42.2
28 37.6
29 34
30 33
31 28.76
32 35.4
33 31
34 38.8
35 34.3
36 35
37 34.6
38 28.5
39 29.5
40 30.5
41 34.2
42 43.6
43 33.5
44 33
45 45.3
46 38.8
47 29.9
48 31.2
49 34
50 30.45
51 35.5
52 34
53 29.1
54 29.65
55 29.2
56 29.8
57 33.5
58 34
59 29.6
60 34
61 37.25
62 33
63 28.6
64 36
65 37.3
66 29.9
67 31.5
68 41.4
69 32.74
70 33.5
71 32
72 30.8
73 42
74 34
75 32.5
76 31.7
77 36.5
78 33
79 31.2
80 34
81 33
82 33.9
83 39
84 34.92
85 39
86 34
87 31.9
88 37
89 34
90 36.4
91 38.2
92 35.3
93 34.5
94 30.5
95 30
96 37.3
97 40.2
98 35.5
99 35
100 38
101 35.3
102 34.1
103 43.2
104 36.1
105 34.6
106 36
107 36.2
108 37.5
109 41
110 35.6
111 39.8
112 41.3
113 42.5
114 45.8
115 34.9
116 41.5
117 38
118 35
119 40
120 36
121 33.7
122 36.3
123 38
124 39.5
125 36.3
126 32.5
127 37
128 32.6
129 36
130 35
131 43.6
132 33.8
133 35.3
134 42.4
135 39.5
136 43.5
137 42
138 40.3
139 44
140 40.66
141 39.7
142 45
143 43.9
144 38
145 39.02
146 44.5
147 41
148 44
149 44
150 42.5
151 40.26
152 44.5
153 35.5
154 42.5
155 44
156 45
157 44.4
158 38
159 41.8
160 45.5
161 42.5
162 44
163 54.3
164 44.8
165 47
166 43.8
167 48
168 42.7
169 48.5
170 42
171 45.5
172 44.5
173 51.2
174 47.5
175 44.5
176 47
177 47
178 43.1
179 49
180 48.5
181 45
182 52.5
183 47.5
184 48
185 46.5
186 61.5
187 50
188 61.8
189 43
190 47
191 58.5
192 55
193 57
194 57
195 60
196 60
197 59
198 60
199 65
200 52
201 58
202 60
203 74
204 95
205 97
206 88
207 94
208 30
min 26.7
max 97
range 70.3
bins 10
bin width 7.03

Combined Male Female

bins FrequencyRel Freq FrequencyMale FrequencyFemale
1 33.73 60 28.8% 15 22% 45 32%
2 40.76 71 34.1% 14 21% 57 41%
3 47.79 49 23.6% 20 29% 29 21%
4 54.82 10 4.8% 4 6% 6 4%
5 61.85 12 5.8% 9 13% 3 2%
6 68.88 1 0.5% 1 1% 0 0%
7 75.91 1 0.5% 1 1% 0 0%
8 82.94 0 0.0% 0 0% 0 0%
9 89.97 1 0.5% 1 1% 0 0%
10 97 3 1.4% 3 4% 0 0%
208 68 100% 140 100%
 Salary Frequency
40.0%
35.0%
30.0%
25.0%
20.0%
15.0%
10.0%
5.0%
0.0%
33.73 40.76 47.79 54.82 61.85 68.88 75.91 82.94 89.97 97
 Salary Frequency

45%

40%

35%

30%
Male
Female
25%

20%

15%

10%

5%

0%
33.73 40.76 47.79 54.82 61.85 68.88 75.91 82.94 89.97 97
t-Test: Two-Sample Assuming Unequal Variances

Female Male
Mean 37.209928571 45.50544118
Variance 45.035730211 251.0075655
Observations 140 68
Hypothesized Mean Difference 0
df 79
t Stat -4.14104728
P(T<=t) one-tail 4.297374E-05
t Critical one-tail 1.6643714096
P(T<=t) two-tail 8.594748E-05
t Critical two-tail 1.9904501765