BUS 308 Week 3 Assignment Problem Set Week Three (New)
Assignment: Problem Set Week Three
All statistical calculations will use the Employee Salary Data set included in the online course.
Complete the problems below and submit your work in an Excel document. Be sure to show all of your work and clearly label all calculations. All statistical calculations will use the Employee Salary Data Set.
Last week, we found that average performance ratings do not differ between males and females in the population. Now we need to see if they differ among the grades. Is the average performance rating the same for all grades? What does that decision mean in terms of our equal pay question?
While it appears that average salaries per each grade differ, we need to test this assumption. Is the average salary the same for each of the grade levels? (Assume equal variance, and use the analysis toolpak function ANOVA.)
The table and analysis below demonstrate a 2-way ANOVA with replication. Please interpret the results. What do these decisions mean in terms of our equal pay question:
Many companies consider the grade midpoint to be the "market rate" - what is needed to hire a new employee. Does the company, on average, pay its existing employees at or above the market rate?
Using the results up through this week, what are your conclusions about gender equal pay for equal work at this point?
Carefully review the Grading Rubric in your online course for the criteria that will be used to evaluate your assignment.
Questions & Answers
Have a Question?
Be the first to ask a question about this.