Mell Industries is a national manufacturing firm that specializes in textiles based out of Chicago. Starting out as a small factory in Warrenville, Illinois, the firm experienced a period of steady growth over the past twenty-four years. Steadily opening new warehouses and factories in the surrounding areas in Michigan and Indianapolis until eventually moving their base of operations to Chicago. Due to this expansion, Mell Industries is at the height of its production and hopes to avoid any interferences or deceleration of growth. In recent years, the firm has been under heavy media scrutiny for supposedly compensating its female staff unfairly lower compared to male counterparts. This was initiated when a disgruntled employee leaked the company payroll allegedly showcasing an unjust gap of income between the female employee and her male counterpart. This type of gender pay gap is highly criticized and as a precaution, Mell Industries has hired Cal Poly Pomona to conduct research to determine the validity of these claims. Mell Industries has provided Cal Poly Pomona with a data set of a sample population of
747 employees. Mell Industries has also offered Cal Poly Pomona compensation for any promising information gathered. Mell Industries may use information gathered from this project in future employee compensation decisions.
The initial dataset has been given to you in the form of an excel spreadsheet titled
Case_dataset. xlsx consisting of 12 columns labeled:
Column A - Employee ID
Column B - Gender
Column C - Date of Birth
Column D - Date of Hire
Column E - Termination Date
Column F - Occupation
Column G - Salary
Column H to L - Employee Evaluation Metrics