Note: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do Helps for this spreadsheet: not worry about failed assumptions tests. Use primary methods described in text and used on homework. Review 9.1 of your text as well as the For the following two hypothesis tests, use alpha =.05 Project Help tab below for stating your Points Claim: The average age of online students is 32 years old. Can you prove it is not? null and alternate hypotheses. Review 9.3 of your text as well as the 1 Ho: Project Help tab below to do a hypothesis Note: Calculation cells Ha: test for a population mean. Also watch the should list the numbers and operations used to get your Excel videos. Sample mean: 26.54 answers. Do not put the Review 9.4 of your text as well as the Sample St. Dev: 6.76 generic formula and show all Project Help tab below to do a hypothesis calculation steps. test for a population proportion. Also Distribution: watch the Excel videos. Test Statistic: 2 decimals Calculation: . "Show Your Calculation" - these cells anjeA-d *4 decimals should list the numbers and operations Decision: used to get your answers. Do not just put the general formula and show all Interpretation: calculation steps. Do not put "=" in (context formulas so I can see the formula by just looking at the cell, not opening it. For the "Interpret" text, what can we Claim: The proportion of males in online classes is 359%. Can you prove it is not? conclude about the null hypothesis with Ho: respect to the evidence produced by the Ha hypothesis test? What does this mean about the average age and male Sample Proportion Males Sample Proportion Females proportion of all online college students? " The green cells (E8 and E9) will link from 2 Distribution: the Week 3 tab on this spreadsheet. Test Statistic: *2 decimals Calculation: . The green cells (F24 and J24) will link from :anjeA-d *4 decimals the Week 5 tab on this spreadsheet. Decision: . Only cells that are yellow need to be completed. Interpretation: . Please note rounding for calculations! context 25 Total PointsProject: Part 4 - Hypothesis Tests Assignment For this part of the project and based on your sample, you will conduct a hypothesis test with a =0.05 to test two of the claims of the above article. Using the same excel sheet as Part 3, answer the following in the "Module 6" tab: . Claim: the average age of online students is 32 years old. Can you prove it is not? o What is the null hypothesis? o What is the alternative hypothesis? o What distribution should be used? o What is the test statistic? o What is the p-value? o What is the conclusion? o How do we interpret the results, in context of our study? . Claim: the proportion of males in online classes is 35%. Can you prove it is not? o What is the null hypothesis? o What is the alternative hypothesis? o What distribution should be used? o What is the test statistic? O What is the p-value? What is the conclusion? o How do we interpret the results, in context of our study?Note: The goal ofthe project is to practice making a confidence interval for a mean and proportion with real data. Do not worry about failed assumptions tests and do not make corrections for small sample size. Use primary methods described in text and used on homework. Age m n: :i n. n: . 19 20 20 20 21 21 21 21 22 22 24 24 24 25 26 28 30 30 32 33 37 38 38 41 hggmmggmmgmgmgmmmgggmgmg Points 25 95% Confidence Interval for Average Age of Online College Students: Sample Mean: 26.54 Sample St. Dev: 6.76 Sample Size: 24 cou NT(A4:A27) T-Distribution Distribution: Critical Value: 2.07 Margin of Error: 2.86 Lower Bound: 23.69 Upper Bound: 29.39 *2 decimals *2 decimals *2 decimals *2 decimals M: Calculation cells should list the numbers and operations used to get your answers. Do not put the generic formula and show all calculation steps. Calculation: 2.07*6.76/SQRTI24) Calculation: 2654-286 Calculation: 26.54+2.86 Interpret I am 95% postive the average age of online Liberty College Students fall between (context) 23.69-29.39years. 95% Confidence Interval for Proportion of Male Online College Students: Sample Size: 24 Number of Males: 12 Male Proportion: 0.5 Female Proportion 0.5 *4 decimals Distribution: Normal Distribution Critical Value: 1.96 *2 decimals 1-0.95/2 Margin of Error: 0.2 *4 decimals Calculation: 1.96*SQRT(0.5*(1-0.5)]24) Lower Bound: 0.3 *4 decimals Calculation: 0.502 Upper Bound: 0.7 *4 decimals Calculation: 0.5+0.2 Interpret I am 95% percent sure thatthe male proportion of online Liberty college students (context) is between 0.30070 Total Points Help for this spreadsheet - Review 8.2 of your text as well as the Project Help tab below for the first confidence interval calculation (mean). Also watch Excel videos in BlackBoard. Review 8.3 of your text as well as the Project Help tab below for the second confidence interval calculation (proportion). Also watch Excel videos in BlackBoard. "Show Your Calculation" - these cells should list the numbers and operations used to get your answers. Do notjust put the general formula and show all calculation steps. 00 not put "=" in formulas so I can see the formula byjust looking at the cell, not opening it. For the "Interpret" text, what can we conclude about the population mean age and the population male proportion of online students with respect to these bounds? Your data for Columns A and B will link from the Week 3 tab on this spreadsheet no need to re-input! The green cells {63 and G4) will link from the Week 3 tab on this spreadsheet. Only cells that are yellow need to be completed