Based on the following 

answer these questions:

1. Looking first at Gender Equity:
   1. Which department has the lowest gender equity?
   2. Consider Job Environment Satisfaction and Job Satisfaction, do there appear to be any impact or issues to consider regarding gender distribution in the department? Explain your view using metrics.
   3. What actions would you recommend to the company regarding gender (if any)? Explain your reasoning.
2. Looking at Training Participation:
   1. Which department had the highest rate of participation?
   2. Which department had the lowest rate of participation?
   3. Does there appear to be any correlation between education level and training participation? Why or why not might this be the case?
3. Looking at age distribution and attrition risk (potential to leave):
   1. Which department has the highest risk of attrition? Why?
   2. Does job satisfaction appear to be an issue with any age cohort?
   3. Does gender appear to be a factor influencing either attrition or job satisfaction?
4. Looking at job satisfaction:
   1. Which department has the highest job environment satisfaction AND job satisfaction?
   2. Which department has the lowest job satisfaction?
   3. Which age cohort has the highest job satisfaction?
   4. Which tenure group has the lowest job satisfaction?
   5. Does gender equity appear influence job satisfaction in the sales department? Explain your reasoning.
5. Identify and explain any other metrics that you would present to the leadership team as possible issues or opportunities?
    

Transcribed Image Text:

Gender (All) Female Male Marital Status (All) Divorced. Married Single Attrition (All) No Yes Department (All) HR R&D Sales Job Role (All) Employees Monthly Payment Gender Department Education Level Male Female HR 1,470 21.04M 882 588 63 R&D Sales 961 446 Below College College Bachelor Master Doctor 170 282 572 398 48 Gender Employees Ages 300 Attrition by Age No Yes 274 600 533 40.00% 60.00% Male Female Years at company Count of Employees 400 200 10 20 30 40 20 Years Education (All) Avg. Environment Satisfaction 2.72 Count of Employees 197 200 177 185 161 139 100 56 41 400 315 235 86 200 67 54 33 20 30 40 50 60 Age Count of Employees Years In Current Role 600 673 400 311 239 200 73 96 32 25 19 5 10 15 20 Years Avg. Job Satisfaction 2.73 18-291 30-40 11-50 Training Times last Year 600 400 200 71 54 150 91 89 51-60 547 491 18-29 30-40 41-50 123 119 65 0 1 2 3 4 5 6 Avg. Performance Rating 3.15 51-60 Gender (All) Female Male Marital Status (All) Divorced. Married Single Attrition (All) No Yes Department (All) HR R&D Sales Job Role (All) Employees Monthly Payment Gender Department Education Level Male Female HR 1,470 21.04M 882 588 63 R&D Sales 961 446 Below College College Bachelor Master Doctor 170 282 572 398 48 Gender Employees Ages 300 Attrition by Age No Yes 274 600 533 40.00% 60.00% Male Female Years at company Count of Employees 400 200 10 20 30 40 20 Years Education (All) Avg. Environment Satisfaction 2.72 Count of Employees 197 200 177 185 161 139 100 56 41 400 315 235 86 200 67 54 33 20 30 40 50 60 Age Count of Employees Years In Current Role 600 673 400 311 239 200 73 96 32 25 19 5 10 15 20 Years Avg. Job Satisfaction 2.73 18-291 30-40 11-50 Training Times last Year 600 400 200 71 54 150 91 89 51-60 547 491 18-29 30-40 41-50 123 119 65 0 1 2 3 4 5 6 Avg. Performance Rating 3.15 51-60