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 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 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". %