The file P02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies. Use filters for each of the following.

a. Identify all employees who are male (Gender = 0) and have exactly 4 years of post-secondary education. What is the average salary of these employees? Round your answer to the nearest dollar, if necessary. $

b. Find the average salary of all female employees who have exactly 4 years of post-secondary education. Round your answer to the nearest dollar, if necessary. $

How does this mean salary compare to the one obtained in part a?

This is about (Select: $2000 less than / $2000 more than / $4000 less than / $4000 more than) the male average.

c. Identify all employees who have more than 4 years of post-secondary education. What proportion of these employees are male? Round your answer to one decimal place, if necessary. %

d. Identify all full-time employees who are either (1) females between the ages of 30 and 50 (inclusive) with at least 5 years of prior work experience, at least 10 years of prior work experience at Beta, and at least 4 years of post-secondary education; or (2) males between the ages of 40 and 60 (inclusive) with at least 6 years of prior work experience, at least 12 years of prior work experience at Beta, and at least 4 years of post-secondary education. How many employees have you identified?

e. For those employees who meet the conditions specified in part d, compare the mean salary of the females with that of the males. Round your answers to the nearest dollar, if necessary.

Males	$
Females	$

f. What proportion of the full-time employees identified in part d earns less than $50,000 per year? If your answer is zero, enter "0". %

Employee	Gender	Age	Prior Experience	Beta Experience	Education	Annual Salary
1	1	39	5	12	4	57700
2	0	44	12	8	6	76400
3	0	24	0	2	4	44000
4	1	25	2	1	4	41600
5	0	56	5	25	8	163900
6	1	41	9	10	4	72700
7	1	33	6	2	6	60300
8	0	37	11	6	4	63500
9	1	51	12	16	6	131200
10	0	23	0	1	4	39200
11	0	31	5	4	6	62900
12	1	27	0	8	0	26200
13	0	47	11	9	4	74500
14	1	35	5	5	6	64800
15	1	29	5	4	0	21600
16	0	46	4	15	6	81900
17	1	50	10	17	4	115400
18	0	30	3	6	4	57800
19	1	34	10	1	4	55800
20	1	42	11	8	4	76100
21	1	51	10	15	8	135700
22	0	63	16	20	4	140400
23	0	28	0	5	4	55400
24	1	32	4	1	4	49700
25	0	55	11	16	6	134800
26	1	45	20	2	4	76900
27	0	34	2	12	2	28700
28	0	33	2	7	4	58800
29	1	23	0	1	4	43100
30	0	40	4	13	6	82400
31	1	48	6	15	4	80100
32	1	27	0	6	0	27000
33	1	36	5	5	6	58800
34	0	58	9	22	4	133100
35	0	31	1	1	6	53700
36	1	21	0	1	2	26700
37	0	47	5	16	4	81300
38	1	35	3	7	4	55400
39	1	52	12	14	8	139900
40	0	29	3	3	2	33200
41	1	42	11	7	4	75000
42	0	60	10	21	4	128200
43	1	50	8	13	4	76800
44	1	33	1	2	6	54200
45	0	26	0	5	2	32600
46	0	38	6	6	6	59200
47	1	44	7	12	4	74800
48	0	25	0	3	4	45500
49	1	37	8	5	4	46500
50	0	53	13	13	6	136300
51	0	46	7	18	4	86900
52	1	20	0	1	0	23900
53	1	34	5	1	6	52700
54	1	60	12	13	4	92700
55	1	36	6	7	4	59500
56	0	41	6	3	6	69400
57	1	33	3	1	6	46600
58	0	29	3	8	4	61700
59	0	48	11	9	4	88200
60	1	43	0	4	6	45000
61	1	61	10	5	0	52200
62	0	30	5	1	6	61400
63	1	36	5	19	4	87500
64	1	48	7	23	4	103700
65	1	29	5	6	4	54000
66	0	26	11	23	4	125100
67	1	49	5	11	2	45900
68	0	28	10	2	6	79300
69	1	44	20	5	6	108600
70	1	48	0	13	6	68200
71	0	50	0	21	2	65200
72	1	48	12	14	4	95600
73	1	30	16	12	4	103100
74	1	41	20	23	4	143500
75	0	35	11	5	4	78200
76	1	28	3	3	4	40200
77	1	33	8	5	4	60500
78	1	61	0	7	4	40500
79	1	53	10	8	4	73800
80	1	48	4	4	4	45300
81	0	47	9	1	4	61400
82	1	48	4	7	6	64800
83	1	55	11	3	6	75600
84	0	32	1	19	6	95800
85	0	60	11	4	8	126700
86	0	50	10	2	4	67000
87	1	49	16	12	4	102600
88	0	22	4	3	4	52000
89	1	51	9	10	4	76000
90	1	22	0	3	8	83000
91	1	47	8	13	4	80800
92	1	41	10	10	6	91100
93	0	24	3	1	0	30100
94	1	64	5	7	4	55700
95	1	43	0	11	4	51400
96	0	22	3	1	4	43800
97	1	59	0	1	4	25000
98	0	32	10	15	2	80600
99	1	45	8	5	2	39600
100	0	47	0	1	2	13400
101	1	29	6	18	4	88200
102	0	61	9	15	6	109100
103	1	57	3	1	4	34200
104	1	65	4	9	4	57800
105	0	34	6	7	4	68100
106	0	54	6	13	6	94900
107	1	30	5	5	6	63200
108	1	39	6	16	4	82700
109	0	32	7	8	6	85600
110	1	24	2	7	2	27100
111	0	40	10	3	4	69800
112	0	52	13	4	4	81300
113	0	28	11	5	4	78400
114	0	53	20	9	6	127300
115	0	43	0	24	4	93700
116	0	30	5	6	6	74400
117	0	46	3	3	4	48300
118	1	38	10	13	6	98900
119	0	28	0	16	4	73300
120	1	46	11	19	6	117300
121	1	30	5	5	0	37800
122	1	43	6	14	4	77400
123	1	29	11	1	8	111200
124	0	48	11	4	4	75300
125	0	42	7	17	4	96900
126	0	18	10	19	6	123600
127	0	35	6	2	4	55200
128	1	22	0	1	0	12400
129	1	44	4	15	4	73900
130	1	47	20	4	4	94100
131	1	34	10	8	4	74300
132	1	37	11	4	4	66900
133	1	49	0	4	2	12500
134	0	32	0	18	6	90200
135	1	37	5	8	4	59000
136	1	29	10	19	6	114700
137	0	24	7	15	2	71700
138	0	43	20	18	0	125500
139	1	54	11	17	4	100200
140	1	26	0	4	6	45400
141	0	47	10	4	4	72200
142	1	31	5	12	4	69500
143	0	33	11	1	4	67900
144	0	42	2	7	6	67500
145	1	34	2	1	4	31800
146	1	59	0	10	2	27800
147	1	43	5	4	6	60200
148	1	30	2	2	4	34500
149	1	45	7	12	6	87000
150	1	50	0	4	2	12500
151	0	23	0	15	8	122700
152	1	44	5	7	4	56200
153	0	48	10	6	2	56900
154	1	47	4	12	4	66000
155	0	20	11	4	4	76000
156	1	31	0	16	2	44100
157	0	30	0	18	4	78500
158	1	42	5	13	4	71800
159	1	25	9	7	6	80700
160	1	24	2	15	2	47800
161	0	36	13	13	4	105000
162	0	32	6	15	6	100700
163	1	27	2	1	0	18300
164	0	55	12	12	6	110600
165	0	36	0	2	4	36800
166	1	22	0	4	6	45500
167	1	25	0	14	6	71400
168	1	47	5	14	4	74300
169	0	43	16	11	8	160600
170	1	53	0	7	6	52500
171	0	38	5	7	4	65000
172	0	39	12	14	4	104500
173	1	35	5	18	4	85000
174	1	23	3	10	8	110200
175	0	43	10	7	4	80100
176	1	33	3	3	4	40000
177	1	44	10	1	4	55900
178	1	33	0	16	4	64600
179	1	31	0	13	6	68600
180	1	36	7	8	4	65100
181	1	45	13	19	4	111700
182	1	45	12	1	4	62000
183	0	39	2	7	4	55800
184	0	45	5	11	2	54600
185	0	25	1	1	4	37600
186	1	34	0	7	4	41200
187	1	53	0	6	6	49900
188	0	35	4	6	4	59400
189	1	52	3	13	4	65500
190	1	33	10	3	6	73200
191	1	49	0	3	4	30500
192	1	59	6	17	4	84800
193	1	35	16	9	4	95200
194	1	44	11	11	4	84900
195	1	61	11	18	4	102600
196	1	43	11	1	4	59000
197	0	30	0	5	4	44800
198	0	32	11	2	4	70500
199	0	57	10	4	6	83700
200	1	44	10	18	4	100000
201	1	44	2	4	4	39300
202	1	45	0	7	2	20400
203	0	43	0	12	6	74300
204	0	33	11	19	4	114500