Draw Formulas Review View Tell me ome Insert Page Layout Data X Cut Calibri (Body) 11 AA ap Wrap [3) Copy Paste UV Av FE Merge Format B I UV 12 X V fx A D E F G H 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 H Ha: Note: Calculation cells should list the numbers and operations used Sample mean: 31.19 to get your answers. Do not put Sample St. Dev: 11.05 the generic formula and show all calculation steps. 2 Distribution: Test Statistic: *2 decimals Calculation: 16 H N N p-value: *4 decimals Decision: 18 Interpretation: 19 2 context) 20 22 Claim: The proportion of males in online classes is 35%. Can you prove it is not? 23 24 1 Ho: + N 25 Ha: 26 27 Sample Proportion Males 0.06667 Sample Proportion Females 0.33 28 29 2 Distribution: 30 31 Test Statistic: *2 decimals Calculation: 32 H N p-value: *4 decimals 33 Decision: 34 Interpretation: 35 (context) 36 37 25 Total Points 38 39 40 41 42 43 44