Here is my assignment, if you could, could you do it in excel and screen shot so I can learn step by step. I am really struggling but want to learn how. Sample size is 24 and here is sample Age Gender 41F27M24F31F29M20M45F35F23F23M42M23F45F52F29F25M26F18M29F20M24M20F21F23M

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? Noise: Calculation cells should list the numbers and operations used to get LDED'M-JG'IU'ILUJNIl l' D your answers. Do not put the generic formula and show all calculation steps. I'I' NH \" m 28-95 I'I' ho: 15 2 *2 decimals 16 2 17 1 I' oo 2 Interpretation: {context} Claim: The proportion of males in online classes is 35%. Can you prove it is not? Sample Proportion Males 0.4167 Sample Proportion Females 2 3 *Zdecimals Calculation: 2 *4decimals 1 2 Interpretation: {comm} 25