What is the answer? Sample size is 78
& Cut Calibri 11 -A - 29 Wrap Text General Normal Bad Good 2 AutoSu [B Copy Fill - Merge & Center Sensitivity $ - % 2 48 598 Conditional Format as Neutral Calculation Check Cell nsert Delete Format Format Painter Formatting- Table Clear Clipboard Font Alignment Sensitivity Number Styles Cells A B C D E G H K N O Q R S - 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 null Points Claim: The average age of online students is 32 years old. Can you prove it is not? and alternate hypotheses. Review 9.3 of your text as well as the 1 Ho: Note: Calculation cells should Project Help tab below to do a hypothesis Ha: list the numbers and test for a population mean. Also watch the Excel videos. Sample mean: 30.12 operations used to get your Sample St. Dev: answers. Do not put the 3.14 Review 9.4 of your text as well as the generic formula and show all Project Help tab below to do a hypothesis calculation steps. 2 Distribution: test for a population proportion. Also watch the Excel videos. Test Statistic: *2 decimals Calculation: "Show Your Calculation" - these cells p-value: *4 decimals should list the numbers and operations Decision: used to get your answers. Do not just put Interpretation: the general formula and show all (context) calculation steps. Do not put "=" in formulas so I can see the formula by just looking at the cell, not opening it. Claim: The proportion of males in online classes is 35%. Can you prove it is not? For the "Interpret" text, what can we conclude about the null hypothesis with 1 Ho: 25 Ha: respect to the evidence produced by the 26 hypothesis test? What does this mean Sample Proportion Males 0.4359 Sample Proportion Females 0.5641 about the average age and male 28 proportion of all online college students? Week 3 Week 5 Week 6 Project Help + Display Settings 9 e XX Cut Calibri A 2P Wrap Text General Normal Good [G Copy - Format Painter BIU - - O-A- CE E Merge & Center Sensitivity $ ~ % 9 18 98 Conditional Format as Neutral Calculation Check Cell Insert Delete Format Formatting * Table Clipboard Font Alignment Sensitivity Number Styles Cells X A B C D E F G H N O Q R formulas so I can see the formula by just looking at the cell, not opening it. Claim: The proportion of males in online classes is 35%. Can you prove it is not? . For the "Interpret" text, what can we 1 Ho: conclude about the null hypothesis with Ha: respect to the evidence produced by the hypothesis test? What does this mean Sample Proportion Males 0.4359 Sample Proportion Females 0.5641 about the average age and male proportion of all online college students? 2 Distribution: The green cells (E8 and E9) will link from Test Statistic: *2 decimals Calculation: the Week 3 tab on this spreadsheet. N W p-value: *4 decimals . The green cells (F24 and J24) will link from Decision: the Week 5 tab on this spreadsheet. . Only cells that are yellow need to be Interpretation: completed. (context) 25 Total Points Week 3 Week 5 Week 6 Project Help Displ 9 e
