Complete the problems below and submit your work in an Excel document. Be sure t

Complete the problems below and submit your work in an Excel document. Be sure to show all of your work and clearly label allcalculations. Allstatisticalcalculations will use the EmployeeSalary DataSet that is ATTACHED!!!ProblemsIs either that male or female salary equal to the overall mean salary? (Two hypotheses one-sample testsneeded.)Are male and femaleaverage salariesstatistically 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 inansweringthe question about salary equity? Why?What other information would you like to know to answer the question about salaryequitybetween the genders? Why?