(Solved): Use AccountingProfessionals.xlsx To Test The Null Hypothesis That The Proportion Of Females Is Equa ...

Use AccountingProfessionals.xlsx to test the null hypothesis
that the
proportion of females is equal to 55% 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.