(Solved): Use AccountingProfessionals.xlsx To Test The Null Hypothesis That Mean Years Of Service Is Equal To ...

Use AccountingProfessionals.xlsx to test the null hypothesis
that mean years of service is equal to 16 using a 0.05 level of
significance. What is the test statistic (round to three decimal
places after making all calculations)?
Department Survey Data Years Undergraduate Study Graduate Degree? Age Group Gender Years of Service 17 CPA? Y Age Group 1 N 2 3 4 5 Age Range 21-25 26-30 31-35 36-40 41-45 46-50 51-55 56-60 over 60 7 - 4 N. 16 21 27 7 8 23 8 4 9 N. NY 2 3 5 3 N. 2 4 4 26 N - 19 5 z 2 2 4 4 4 4 19 < z 20 14 < 31 z z 10 10 26 4 N 4 28 4 4 N.