File Home Insert Draw Page Layout Formulas Data Review View Help G30 X V 0.0385 A B C D E F G H K L M Note: 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 1 assumptions tests and do not make corrections for small sample size. Use primary methods described in text and used on homework w N Age Gender Points 95% Confidence Interval for Average Age of Online College Students: 17 F 19 M Sample Mean: 27.4 Note: Calculation cells should 20 M Sample St. Dev: 7.65 20 M list the numbers and 1 Sample Size: 24 20 M operations used to get your 20 M Distribution: T-Distribution answers. Do not put the 21 F generic formula and show all 21 M calculation steps. 2 Critical Value: 2.06 #2 decimals 22 M Margin of Error: 3.15 #2 decimals Calculation: 2.07*(24/SQRT(24)) Lower Bound 24.17 #2 decimals Calculation: 27.4 - 3.23 Upper Bound: 30.63 *2 decimals Calculation: 27.4 + 3.23 Interpret We are 95% confident the mean age of online college students is between 2 (context) |24.25 and 30.55 95% Confidence Interval for Proportion of Male Online College Students Sample Size: 24 N HP Number of Males: 16 Male Proportion: 0.64 Female Proportion 0.36 $4 decimals M 2 Distribution: Normal Distribution 3F 685 2 Critical Value: 1.96 #2 decimals Margin of Error: 0.0385*4 decimals Calculation: SORT of MP*(1-0.6667))/ sample Lower Bound: 0.6282 #4 decimals Calculation 0.6667 - 0.0385 Upper Bound: 0.7052 #4 decimals Calculation: 0.6667 + 0.0385 Interpret We are 95% confident the proportion of males in online classes is between 2 (context) |0.4518 and 0.8282. 25 Total Points 38 Week 5-Part 3 Week 6-Part 4 Sheet2 +A Note: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do Exam Review and Exam Instructions not worry about failed assumptions tests. Use primary methods described in text and used on homework. For the following two hypothesis tests, use alpha = .05 JO UI B W N - Points Claim: The average age of online students is 32 years old. Can you prove it is not? Project Instructions 1 Ho 32 Note: Calculation cells should 8 Ha list the numbers and 9 operations used to get your Project Part 4 - Hypothesis Testing 10 Sample mean: 27.4 answers. Do not put the 11 Sample St. Dev: 7.65 Based on your sample, you will conduct a hypothesis test with to test two of the claims of the above article. generic formula and show all 12 calculation steps. Using the same excel sheet as last week, answer the following in the "week 6" tab: 13 2 Distribution: 14 . Claim: the average age of online students is 32 years old. Can you prove it is not? 15 2 Test Statistic: *2 decimals Calculation . What is the null hypothesis? 16 p-value: #4 decimals What is the alternative hypothesis? 17 Decision: . What distribution should be used? 18 What is the test statistic? o What is the p-value? Interpretation: . What is the conclusion? 19 2 (context) o How do we interpret the results, in context of our study? 20 . Claim: the proportion of males in online classes is 359%. Can you prove it is not? 21 . What is the null hypothesis? 22 Claim: The proportion of males in online classes is 35%. Can you prove it is not? What is the alternative hypothesis? 23 What distribution should be used? 1 Ho What is the test statistic? 24 What is the p-value? 25 Ha What is the conclusion? 26 How do we interpret the results, in context of our study? 27 Sample Proportion Males 0.64 Sample Proportion Females 0.36 28 29 2 Distribution: 30 Exam 3 Work Submission 31 3 Test Statistic: *2 decimals Calculation: IN You must submit all written work for the exam questions. Exams submitted without the accompanying work will not be 32 p-value: #4 decimals 33 Decision: Uploading your exam work in BlackBoard.docx 34 Interpretation: 35 2 (context) 36 . . . Week 5-Part 3 Week 6-Part 4 Sheet2 +
