A human resources manager at Beta Technologies, Inc., has collected current annual salary figures and related data for 52 of the company’s full-time employees. The data are in the file P4_3.XLS.

a. Identify all full-time employees who are either (1) females between the ages of 30 and 50 (inclusive) who have 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) who have 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.

b. For those employees who meet the conditions specified above, compare the mean salary of the females with that of the males. Also, compare the median salary of the female employees with that of the male employees.

c. What proportion of the full-time employees identified in part a earn less than $50,000 per year?