For the following

week 5adsx - Microsoft Excel art Page Layout Formulas Data Review View Calibri - 11 - A A" Wrap Text General SET BI U- - 3 - A- Merge & Center - $ - % Conditional Format Formatting ~ as Table Font Alignment Number Styles More : The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real owing files. Save data. Do not worry about failed assumptions tests. Use primary methods described in text and used on 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? xlsb [Autos... 7 Ho: om the last . .. 8 Ha Note: Calculation cells , November ... 9 should list the numbers and 10 Sample mean: 27.23 operations used to get your 11 Sample St. Dev: 9.54 answers. Do not put the generic formula and show xlsb [Autos... 12 13 2 Distribution: all calculation steps. om the last . .. 14 November 2... 15 Test Statistic: *2 decimals Calculation 16 2 p-value: `4 decimals 17 - M Decision (1) (version ... 19 rom the last . . . Interpretation: November 2... 19 [context) 20 21 Claim: The proportion of males in online classes is 35%. Can you prove it is not? (1).csv [Ori... 23 ast time the ... 24 Ho: , November 2... Ha 27 Sample Proportion Males 0.579 Sample Proportion Females | 0.4211 .csv [Original] 28 29 2 Distribution: ast time the .. . 30 , November 2. .. 31 Test Statistic: "2 decimals Calculation 32 2 p-value: '4 decimals Decision: Interpretation: 35 2 [context) 36 o save? 37 Total Points 38 Close 39 Week 5 ogive Week 3 Week 6