The ongoing question that the weekly assignments will focus on…
by ella | Mar 26, 2024 | Finance
The ongoing question that the weekly assignments will focus on is: Are males and females paid the same for equal work (under the Equal Pay Act)? |
Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The column labels in the table mean: |
|
|
|
|
|
|
|
|
|
|
ID – Employee sample number |
Sal – Salary in thousands |
|
|
|
|
|
|
|
|
Age – Age in years |
|
EES – Appraisal rating (Employee evaluation score) |
|
|
|
|
|
SER – Years of service |
G – Gender (0 = male, 1 = female) |
|
|
|
|
|
|
|
Mid – salary grade midpoint |
Raise – percent of last raise |
|
|
|
|
|
|
|
|
Grade – job/pay grade |
Deg (0= BSBA 1 = MS) |
|
|
|
|
|
|
|
|
Gen1 (Male or Female) |
Compa – salary divided by midpoint, a measure of salary that removes the impact of grade |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This data should be treated as a sample of employees taken from a company that has about 1,000 |
|
|
|
|
employees using a random sampling approach. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mac Users: The homework in this course assumes students have Windows Excel, and |
|
|
|
|
|
|
can load the Analysis ToolPak into their version of Excel. |
|
|
|
|
|
|
|
|
The analysis tool pak has been removed from Excel for Windows, but a free third-party |
|
|
|
|
|
tool that can be used (found on an answers Microsoft site) is: |
|
|
|
|
|
|
|
|
http://www.analystsoft.com/en/products/statplusmacle |
|
|
|
|
|
|
|
|
|
Like the Microsoft site, I make cannot guarantee the program, but do know that |
|
|
|
|
|
|
Statplus is a respected statistical package. |
You may use other approaches or tools |
|
|
|
|
|
|
as desired to complete the assignments. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
