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 that is ATTACHED!!!
Problems
Is either that male or female salary equal to the overall mean salary? (Two hypotheses, one-sample testsneeded.)
Are male and female average salaries statistically equal to each other?
Are the male and female compa average measures equal to each other?
If the salary and compa mean tests in questions 2 and 3 provide different equality results, which would be more appropriate to use in answering the question about salary equity? Why?
What other information would you like to know to answer the question about salary equity between the genders? Why?
