~() ~(3wmumwnwru ~(3wmumwnwra wmumurnwra Age as m 3 Sim '2 19 20 20 20 21 21 21 21 22 22 24 24 24 26 2B 30 30 32 33 3? 3B 3B 41 'Hgg-H-ngg-n-ng-Hg-Hg---ggg-Hg-Hg Limits Freq. Mid. RF CF Ogive: Polygon Total: Points HNNNN NMMMM F G H l J K Forthe following questions, use only the I'age" column: Age Frequency Distribution: Class Width 5 Class Limits Relative Cumulative Low High Midpoint Freq. Frequency Relative Freq 19 24 21.5 13 0.5417 0.5417 25 30 27.5 5 0.2083 0.7500 31 36 33.5 2 0.0333 0.8333 37' 42 35.5 4 0.1667 1.0000 43 43 45.5 0 0.0000 1.0000 Mean 26.54 *Round to two decimals Median 24 *Round to one decimal Sample Standard deviation: 6.76 *Round to two decimals 0.1 21 *Round to one decimal 03 30.5 *Round to one decimal Ogiye: |:l oglve '_.2|JIJIJ 1000'] 0800'] 0500'] D4000 0.2000 0.000'] C l 2 3 e 5 M N O P Help for this spreadsheet Review 2.2, 3.1 3.3 of your text. Also watch Excel Videos in Canvas. Your data is already copied into columns A and B. Only cells in yellow need to be completed. Choose a class width according to the following equation (rounded up to whole number): CLASS WlDTH : (MAX VALUE , MIN VALUE/l1 of Classes [5) The ogive and polygon graphs need to be included on this page under the headers below. Please do not put them on a separate page. Polygon: Polygon g a co enc nterval for a mean and proportion with real data. no not worry about failed _ ns for small sample size. Use primary methods described in text and used on homework. He' for thls S readShee': Note he goal of the project is to pra assum ons tests and do not make corre Age Gender Points 95% Condence Interval for Average Age of Online College Students: ' Review 8.2 Of your text as well as the 19 Project Help tab below for the first M 20 F Sample M93\": 25-54 Note: Calculation cells should confidence interval calculation [mean]. 20 M sample Stjne'\" \"5 me numbers and Also watch Excel videos in BlackBoard. :3; 1 sample SIZE: 24 coumlmmzn operations used to getyour ' Review 8.3 of your text as well as the 21 M 2 Distribution: TsDistribution answers. DO not putthe Projea Help tab bEIOW for the second 21 M genem form\" and Show a\" confidence interval calculation 21 r 2 Critical Value: 2.07 *2 decimals calmlaon Stem (proportion). Also watch Excel videos in 22 r BlackBoa rd. 22 F 2 Margin of Error: 2.36 "2 decimals Calculation: 2.0?'6.?6ISQRT(24} I "Show Your Calcu|ati0n" _ these ceIIS 24 M 1 Lower Bound: 23.69 *2 decimals Calculation: 2654-236 should list the numbers and operations :3 :41 1 Upper Bound: 29.39 *2 decimals Calculation: 26.544236 used to get your answers. [)0 notjust put 25 F Interpret lam 95% postive the average age of online Liberty College Students fall the genfral formUIa and Show a\". 26 M 2 {context} between 23.69-29.39 years. calcwat'on steps. D0 \"Ct put "2\" m 23 r formulas sol can see the formula byjust 30 F 95% Confidence Interval for Proportion of Male Online College Students: looking at the CE\Note: The goal ofthe project is to practice conducting a hypothesis test fora 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. I Review 9.1 of your text as well as the Project Help tab below for stating your null and alternate hypotheses. I Review 9.3 of your text as well as the Project Help tab below to do a hypothesis For the following two hypothesis tests, use alpha = .05 Points Claim: The average age of online students is 32years old. Can you prove it is not?I 1 Ho: u=32 _ 2 Ha; W32 "DtE' calwlat'on calls ShOUId test for a population mean. Also watch the listthe numbers and . . Excel VldeOS. Sample mean' 26 54 operations used to getyour I R _ 9 4 f ll h 5 I St D I. 6.\" answers. DO notputthe EV-IEW . 0 your text as we est 6 . amp 9 ' e\" ' genericformula and Show a" Project Help tab below to do a hypothesis _ _ _ _ _ _ calculation steps. test for a population proportion. Also 2 Distribution: Normal Distribution . watch the Excel VIClEOS. l'I ' fl 2 Test statistic: -o.31 *2 decimals Calculation: (26.54-32}}'6.?6 ' Show Your Calculation ' these cells 2 Name: 02095 *4 decimals should list the numbers and operations 1 Decision: Fail to Reject Ho used to get your answers. Do not just put the general formula and show all Interpretation: The average age of students is not different from the average age calculation steps. DO not put "=" in 2 (contex 0f32- formulas sol can see the formula by just looking at the cell, not opening it. . I! ll Claim: The proportion of males in online classes is 35%. Can you prove itis not? For the InterimQt teXt' What can we conclude about the null hypothesis with 1 Ho: p=0.35 respect to the evidence produced by the 2 Ha: [340.35 hypothesis test? What does this mean about the average age and male Sample Proportion Males 0.5 Sample Proportion Females 0.5 proportion of a\" online college students? 2 Distribution: Normal Distribution I The green calls (E8 arld E9} Wlll link from the Week 3 tab on this spreadsheet. 3 Test statistic: 1.41 *2 decimals Calculation: (0.5-0.35}}'SQRT(D.5"D.5}'24 ' The green cells (F24 and \"34} Will link from ,Halue: 03203 *4 decimals the Week 5 tab on this spreadsheet. 1 Decision: Fail to Reject Ho I Only cells that are yellow need to be completed. Interpretation: p-value>5% level of signifiance. fails to rejectthe null hypothesis. I Please note rounding for calculations! 2 {context} The proportion of males in online classes isnt different from 35% 25 Total Points Project: Part 5 Final Report Assignment You will submit a nal report= written in Word (or similar word processing software). based on your ndings and submissions from Parts 1 4. It is highly suggested you not submit this paper without rst reviewing all the feedback from your instructor on submissions from all parts of this project. Be sure to ask any questions you may have on your feedback. This nal submission should be three paragraphs and summarize your entire project. It will be submitted to Turnitin to check for originality. The project must be submitted in paragraph form and not just a list of the calculations 'om your project. Be sure your paragraphs flow (not just listing the answers to the questions. but complete sentences with transitions) and are written in third person. The goal is not to dene all the terms. nor describe how they are calculated. Rather. you should describe the results and \"rhal they told you about online students. You are presenting your results to a nonstatistical audience. do not describe the calculations, describe your results. It should include the following: I Paragraph 1: 5- Brief summary of the US. News Data: The Average Online Bachelor's Student article. including the source . A direct link to this article is located in the Learn section of Module F: "Week 7' entitled Read: U.S. News Data: The Average Online Bachelor's Student. Dene the population. sample. and statistic for the study Statement of the two claims in the article that were tested in this project Null and alternative hypothesis for both tests run for this project (in words) - Paragraph 2 (address the claim about the mean}: [:1 [:1 [:1 [:1 Summary of sample statistics (mean. standard deviation. median. quartiles. sample size) Condence interval. along with interpretation of the condence interval Description of hypothesis test (alpha. test statistic. p-value. conclusion. interpretation) - Paragraph 3 (address the claim about the proportion): Summary of sample statistics (sample size. successes. proportion) Condence interval. along with interpretation of the condence interval Description of hypothesis test (alpha. test statistic. p-value. conclusion. intemretation1 [:1 [:1 [:1