CengageNOW | Online teaching and learning resource from Cengage Learning Assignment: Chapter 2 Practice Assignment Score

[answerhappygod]

CengageNOW | Online teaching and learning resource from CengageLearning
Assignment: Chapter 2 Practice
Assignment Score: 75.92%
Questions
Question5 of 6
Problem 2-34 (Excel Tables)
Question Workspace
The file P02_07.xlsx includes data on 204 employees atthe (fictional) company Beta Technologies. Use filters for each ofthe 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 tothe nearest dollar, if necessary.$
b. Find the average salary of all femaleemployees 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 inpart a?
This is about Select$2000 less than$2000 more than$4000less than$4000 more thanItem 3 the male average.
c. Identify all employees who have morethan 4 years of post-secondary education. What proportion of theseemployees are male? Round your answer to one decimal place, ifnecessary. %
d. Identify all full-time employees whoare either (1) females between the ages of 30 and 50 (inclusive)with at least 5 years of prior work experience, at least 10 yearsof prior work experience at Beta, and at least 4 years ofpost-secondary education; or (2) males between the ages of 40 and60 (inclusive) with at least 6 years of prior work experience, atleast 12 years of prior work experience at Beta, and at least 4years of post-secondary education.How many employees have you identified?
e. For those employees who meet theconditions specified in part d, compare themean salary of the females with that of the males. Round youranswers to the nearest dollar, if necessary.
f. What proportion of the full-timeemployees identified in part d earnsless than $50,000 per year? If your answer is zero, enter"0". %
Icon Key
Question5 of 6