ID Salary Compa- Midpoint ratio Age Performance Service Gender Rating Raise Degree Gender Grade 1 Copy Employee Data set to this page. Are males and...

Hey B-Hunter, let me know if you have any questions. This is for week 4 in the excel document.

Problem Set Week Four

This week we get to answer our equal pay for equal work question by looking at relationships between and among the different variables.

The first question this week looks at correlations and the creation of a correlation table for our variables.  The second question asks for a regression equation showing how the different variables impact the compa-ratio measure. The third questions asks you to discuss the benefits of using a regression equation approach over the single variable tests we have been doing.

The forth question asks for what other information you would have liked to have analyzed in our research. The fifth question asks for your answer to the equal pay for equal work question of: Is the company paying fairly or not?  If not, who benefits and why?

Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment.