Problem Set Week 2

Problem Set Week Two

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 theEmployee Salary Data Setand theWeek Two 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 theGrading Rubricfor the criteria that will be used to evaluate your assignment.