Data Analytics -

Question # 34 Page 70, data file - P02-07.xlsx - Business Analytics By S Christian Albright - Sixth Addtion

34. 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 and have exactly 4 years of post-secondary education. What is the average salary of these employees?

b. Find the average salary of all female employees who have exactly 4 years of post-secondary education. How does this mean salary compare to the one obtained in part a?

c. Identify all employees who have more than 4 years of post-secondary education. What proportion of these employees are male?

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 postsecondary 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.

e. For those employees who meet the conditions specified in part d, 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. f. What proportion of the full-time employees identified in part d earns less than $50,000 per year?