Sample size is 43, I will also need the excel steps.Please help with a simpler solution Thanks.

A B C D E G H K Note: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do not worry about failed assumptions tests. Use primary methods described in text and used on homework. For the following two hypothesis tests, use alpha = .05 Points Claim: The average age of online students is 32 years old. Can you prove it is not? Ho: N N Ha: Note: Calculation cells should list the numbers and Sample mean: 29.42 operations used to get your answers. Do not put the Sample St. Dev: 9.85 generic formula and show all calculation steps. 3 Distribution: Test Statistic: *2 decimals Calculation: N W W p-value: *4 decimals Decision: Interpretation: 3 (context) Claim: The proportion of males in online classes is 35%. Can you prove it is not? Ho: N N Ha: Sample Proportion Males 0.6744186 Sample Proportion Females 0.32558 2 Distribution: Test Statistic: *2 decimals Calculation: N W W p-value: *4 decimals Decision: Interpretation: 3 (context) 35