A B C D E G J K L P S Points Claim: The average age of online students is 32 years old. Can you prove it is not? U W Review 9.3 of your text as well as the Ho P = 32 Project Help tab below to do a hypothesis 2 Ha P + 32 Note: Calculation cells should list the numbers and test for a population mean. Also watch the Sample mean: 28.48 operations used to get your Excel videos. Sample St. Dev: 10.24 answers. Do not put the Review 9.4 of your text as well as the generic formula and show all Project Help tab below to do a hypothesis 13 Distribution Normal Distribution calculation steps. test for a population proportion. Also 14 watch the Excel videos. 15 Test Statistic: 2 decimals Calculation "Show Your Calculation"- these cells ON 16 p Value A decimals should list the numbers and operations 17 Decision: used to get your answers. Do not just put 18 the general formula and show all Interpretation: calculation steps. Do not put "=" in 19 [context) formulas so I can see the formula by just 20 looking at the cell, not opening it. 21 For the "Interpret" text, what can we 22 "Claim: The proportion of males in online classes is 657. Can you prove it is not?" conclude about the null hypothesis with 23 24 respect to the evidence produced by the Ho: 25 Ha: hypothesis test? What does this mean 26 about the average age and male 27 Sample Proportion Males D Sample Proportion Females proportion of all online college students? 28 - The green cells (ES and E9) will link from 29 Distribution the Week 3 tab on this spreadsheet. 30 The green cells (F24 and J24) will link from 31 Test Statistic: 2 decimals Calculation the Week 5 tab on this spreadsheet. 37 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) 36 37 25 Total Points 38 14 41 1 Week 3 Week 5 Week 6 Project Help Ready e