STATS question:

11:51 AM Mon Dec 11 Project 2 620/0 Home Insert Draw Page Layout Formulas II Data General Review View o 0 9 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Calibri (Body) -SUM( A7:A35 ) c D For the following two hypothesis tests, use alpha = .05 p s Points 2 2 3 3 3 2 3 2 2 2 3 3 2 3 B Claim: Ho: Ha: The average age of online students is 32 years old. Can you prove it is not? Sample mean: Sample St. Dev: Distribution: Test Statistic: p-value: Decision: Interpretation: (context) 24.17 6.49 Note: Calculation cells should list the numbers and operations used to get your answers. Do not put the generic formula and show all calculation steps. *2 decimals *4 decimals Calculation: Claim: The proportion of males in online classes is 35%. Can you prove it is not? Ho: Ha: Sample Proportion Males o Distribution: Test Statistic: p-value: Decision: Interpretation: (context) *2 decimals *4 decimals Part 3 Confidence In... Sample Proportion Females Calculation: Part 4 Hypothesis T... Review 9.1 of your text as well as the Project Help tab below for stating your null and alternate hypotheses. Review 9.3 of your text as well as the Project Help tab below to do a hypothesis test for a population mean. Also watch the Excel videos. Review 9.4 of your text as well as the Project Help tab below to do a hypothesis test for a population proportion. Also watch the Excel videos. "Show Your Calculation" -these cells should list the numbers and operations used to get your answers. Do not just put the general formula and show all calculation steps. Do not put in formulas so I can see the formula by just looking at the cell, not opening it. For the "Interpret" text, what can we conclude about the null hypothesis with respect to the evidence produced by the hypothesis test? What does this mean about the average age and male proportion of all online college students? The green cells (E8 and E9) will link from the Week 3 tab on this spreadsheet. The green cells (F24 and J24) will link from the Week 5 tab on this spreadsheet. Only cells that are yellow need to be completed. Please note rounding for calculations! Part 2 Descripitive S... Project Help