Problem Set Week Four. Let s look at some other factors that might influence pay

Problem Set Week Four. Let s look at some other factors that might influence pay. 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 (in Appendix section).Is the probability of having a graduate degree independent of the grade the employee is in?Construct a 95% confidence interval on the mean service for each gender. Do they intersect?Are males and females distributed across grades in a similar pattern?Do 95% confidence intervals on the mean length of service for each gender intersect?How do you interpret these results in light of our equity question?