In the Week Two Assignment sheet, 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 and Weekly Assignment Sheet.
(Note: Questions 1- 4 have additional elements to respond to below the analysis results and included in the Week Two Assignment sheet are 2 one-sample t-tests comparing male and female average salaries to the overall sample mean.)
Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment.