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. In particular, these data include each selected employee’s gender, age, number of years of relevant work experience prior to employment at Beta, the number of years of employment at Beta, the number of years of post-secondary education, and annual salary. The data are in the file P2_1.XLS. Use Excel to construct pivot tables or other descriptive graphs to answer the following questions:

a. What proportion of these full-time Beta employees are female?

b. Is there evidence of salary discrimination against women at Beta Technologies? What are the limitations of the conclusion that you have drawn in answering this question?

c. Is additional post-secondary education positively associated with higher average salaries at Beta?

d. Is there evidence of salary discrimination against older employees at Beta Technologies? What are the limitations of the conclusion that you have drawn in answering this question?