Question
For this part of the project and based on your sample, you will conduct a hypothesis test with ?= 0.05 to test two of the
For this part of the project and based on your sample, you will conduct a hypothesis test with ?= 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? o What is the conclusion? o How do we interpret the results, in context of our study?
Gender For the following questions, use only the "age" column: 28 F Help for this spreadsheet WEZ Points Age Frequency Distribution: Class Width Review 2.2, 3.1 - 3.3 of your text. Also watch 30 M 19 F Class Limits Relative Cumulative Excel Videos in BlackBoard. 44 F Low High Midpoint Freq. Your data is already copied into columns A Frequency Relative Freq and B. 24 M Limits RE Freq. Only cells in yellow need to be completed. 19 M Mid. Choose a class width according to the 28 M RIF following equation (rounded up to whole 36 M OF number]: 44 F CLASS WIDTH = (MAX VALUE - MIN VALUE)/N 25 F Mean *Round to two decimals of Classes (5) 21 F Median *Round to one decimal The ogive and polygon graphs need to be 21 M Sample Standard deviation: *Round to two decimals included on this page under the headers 22 M 01 *Round to one decimal below. Please do not put them on a separate 22 F *Round to one decimal page. 35 F 31 M 29 M Ogive: Ogive: Polygon: 17 M Polygon 23 F 30 F 37 M Total; 25Note: The goal of the 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 Help for this spreadsheet Age Gender Points 95% Confidence Interval for Average Age of Online College Students: Review 8.2 of your text as well as the 28 F Project Help tab below for the first 23 M Sample Mean: confidence interval calculation (mean). Also o 30 M Sample St. Dev: Note: Calculation cells should watch Excel videos in BlackBoard. 19 F 1 Sample Size: list the numbers and operations Review 8.3 of your text as well as the 44 F used to get your answers. Do Project Help tab below for the second 24 M 2 Distribution: not put the generic formula and confidence interval calculation (proportion). 38 F show all calculation steps. Also watch Excel videos in BlackBoard. 19 M 2 Critical Value: *2 decimals "Show Your Calculation" - these cells should 28 M list the numbers and operations used to get 36 M Margin of Error: *2 decimals Calculation: your answers. Do not just put the general 44 F Lower Bound: *2 decimals Calculation: formula and show all calculation steps. Do 25 F Upper Bound: *2 decimals Calculation: not put "=" in formulas so I can see the 21 F formula by just looking at the cell, not 21 M Interpret opening it. 22 M 2 (context) For the "Interpret" text, what can we 22 F conclude about the population mean age 35 F 95% Confidence Interval for Proportion of Male Online College Students: and the population male proportion of 31 M online students with respect to these 29 M Sample Size: bounds? 17 M Number of Males: 23 F Male Proportion: Female Proportion *4 decimals Your data for Columns A and B will link from #REF #REF the Week 3 tab on this spreadsheet - no 30 F N Distribution: need to re-input! 37 M The green cells (G3 and G4) will link from 2 Critical Value: *2 decimals the Week 3 tab on this spreadsheet. Only cells that are yellow need to be Margin of Error: *4 decimals Calculation: completed. Lower Bound: *4 decimals Calculation: Please note rounding for calculations! Upper Bound: *4 decimals Calculation: Interpret 2 (context) 25 Total PointsNote: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do not worry Helps for this spreadsheet: 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 Ho: Project Help tab below to do a hypothesis Ha Note: Calculation cells should test for a population mean. Also watch list the numbers and operations the Excel videos. Sample mean: used to get your answers. Do Review 9.4 of your text as well as the Sample St. Dev: not put the generic formula and Project Help tab below to do a hypothesis show all 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 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. 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 Ho: respect to the evidence produced by the Ha: hypothesis test? What does this mean Sample Proportion Males Sample Proportion Females 0 about the average age and male proportion of all online college students? 2 Distribution: The green cells (E8 and E9) will link from the Week 3 tab on this spreadsheet. Test Statistic: #2 decimals Calculation: The green cells (F24 and J24) will link p-value: #4 decimals from the Week 5 tab on this spreadsheet. Decision: " Only cells that are yellow need to be Interpretation: completed. 2 [context) Please note rounding for calculations! 25 Total PointsHo: H=32 Ha: H#32 Sample mean 28.08695652 Sample St. Dev. 7.838790743 Distribution t normal distribution Test statistic -2.39 p value 0.0256 Decision Reject Ho Interpretation There is sufficient evidence to claim that average age of online student is 32 year old Ho: p=0.35 Ha: p#0.35 Sample proportion male 0.5217 Sample proportion female 0.4783 Distribution z normal distribution Test statistic 1.73 p value 0.0842 Decision Do not reject Ho Interpretation There is not sufficient evidence to claim that promotion of males in online class is 35%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started