Please see attachment for question. Please show all work, thanks.
Enrollment data over the past ten years indicates that 70% of the students taking elementary statistics at FHSU are female? Is the enrollment in this semester's virtual class significantly different from this claim, as measured statistically? Justify your answer through a formal hypothesis testing praocedure on proportions with a 10% level of significance. It is required that you give needed hypotheses and related statistical values below as well as statistical computations to the right (feel free to use the appropriate template from the Excel guide for Unit 3). Then give a proper final interpretive conclusion below based on the statistical measures calculated and related to the context given.
This solution conducts a hypothesis testing by defining the null and alternative hypothesis and testing the test statistic against the p-value to either accept or reject the null hypothesis on the enrollment data. All steps are shown in an Excel file.