Stat Assignment 2

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 Week 2 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.) 

Due midnight