Need help with steps for this excel.

B C D E G H K N O P Q R S Note: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do not worry Helps for this spreadsheet: about failed assumptions tests. Use primary methods described in text and used on homework ct For the following two hypothesis tests, use alpha = .05 Un Points Claim: The average age of online students is 32 years old. Can you prove it is not? ct 6 1 Ho: 8 N Ha: Note: Calculation cells should eos. 9 list the numbers and operations ct 10 Sample mean: 30.32 used to get your answers. Do not 11 Sample St. Dev: 10.7 put the generic formula and 12 show all calculation steps. 13 2 Distribution: 14 . "Show Your Calculation" - these cells should list 15 2 Test Statistic: *2 decimals Calculation: the numbers and operations used to get your 16 IN p-value #4 decimals answers. Do not just put the general formula 17 Decision: and show all calculation steps. Do not put "=" in 18 formulas so I can see the formula by just Interpretation: 2 (context) looking at the cell, not opening it. 19 . For the "Interpret" text, what can we conclude about the null hypothesis with respect to the Claim: The proportion of males in online classes is 35%. Can you prove it is not? evidence produced by the hypothesis test? What does this mean about the average age 24 Ho N P 25 Ha and male proportion of all online college students? Sample Proportion Males | 0.4788732 Sample Proportion Females 0.52113 . The green cells (E8 and E9) will link from the 28 Week 3 tab on this spreadsheet. 29 2 Distribution: " The green cells (F24 and J24) will link from the 30 31 *2 decimals Calculation: Week 5 tab on this spreadsheet. Test Statistic: 32 NW p-value: *4 decimals Only cells that are yellow need to be 33 Decision: completed. 34 . Please note rounding for calculations! Interpretation: 35 2 (context) 36B D E G H N O Q R S Note: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do not worry Helps for this spreadsheet: 1 about failed assumptions tests. Use primary methods described in text and used on homework. ct For the following two hypothesis tests, use alpha = .05 5 Points Claim: The average age of online students is 32 years old. Can you prove it is not? 6 1 Ho 8 N Ha: Note: Calculation cells should OS. 9 list the numbers and operations ct 10 Sample mean: 30.32 used to get your answers. Do not 11 Sample St. Dev: 10.7 put the generic formula and 12 show all calculation steps. 13 2 Distribution: 14 . "Show Your Calculation" - these cells should list 15 Test Statistic: the numbers and operations used to get your NN 16 p-value answers. Do not just put the general formula 17 Decision: Normal Distribution and show all calculation steps. Do not put "=" in 18 Interpretation: T-Distribution formulas so I can see the formula by just 19 2 (context looking at the cell, not opening it. 20 . For the "Interpret" text, what can we conclude 21 about the null hypothesis with respect to the 22 Claim: The proportion of males in online classes is 35%. Can you prove it is not? evidence produced by the hypothesis test? 23 What does this mean about the average age 24 Ho and male proportion of all online college 25 Ha: 26 students? 27 Sample Proportion Males | 0.4788732 Sample Proportion Females 0.52113 . The green cells (E8 and E9) will link from the 28 Week 3 tab on this spreadsheet. 29 2 Distribution: . The green cells (F24 and J24) will link from the 30 *2 decimals Calculation: Week 5 tab on this spreadsheet. 31 Test Statistic: W 32 #4 decimals - Only cells that are yellow need to be p-value: 33 Decision: completed. 34 . Please note rounding for calculations! Interpretation: 35 (context