AutoSaveOnDO Project Data File BUSH 230D SU 2022 (4) . Last Modified: Yesterday at 1:00 PM A Starch (Alt File Home Insert Page Layout Formulis Data Review View Help X Cut Calbri - 11 - A'A E 29 Wrap Text General Ca copy EEBEE Merge & Center Cond Format Painter For Clipboard Alignedn! Number X V f Age A B C D E F G H K Are Gender For the following questions, use only the "age" columns 27 M 17 M Points Age Frequency Distribution: Class Width 22 M 35 M Class Limits Rebthe Cumulative 27 M LOW High Midpoint Freq. Frequency Relative Freq 40 F Limits N 24 M Freq 9 29 F Mid PNN 10 23 M RF 11 33 M CF 12 37 F 13 38 F Mean *Round to two decimals 14 31 F Median *Round to one decimal 15 56 F Sample Standard deviation: "Round to two decimals NNNN 16 19 M a1 *Round to one decimal 17 19 M 03 Round to one decimal 18 35 F 19 57 F 20 19 M Ofive: Ogive: 21 45 F Polygon 22 31 M 23 32 M 24 25 Total: 25 26 27 28 Week 3 Week 5 |Week 6 Project Help Ready Accessibility. Investigate Type here to search ALIENW- Assignments X Course Hero | Make every study X om/courses/265410/assignments/5002021#submit Project: Part 2 - Descriptive Statistics Assignment For this part of the project, you will calculate descriptive statistics for the first question, age, using the Excel spreadsheet your instructor will send with all the class data at the end of Module 2. This sheet will also provide space for you to do the following descriptive statistics under the "Module 3" tab. You will submit the Excel sheet with the following information: . Make a Frequency Distribution with 5 classes, also list the midpoints, relative frequency, and cumulative relative frequency . Make a cumulative relative frequency ogive o Don't forget descriptive title and labels on x and y axis (ogive is not "descriptive, what does the graph represent?) .Make a frequency polygon o Don't forget a descriptive title and labels on x and y axis (polygon is not descriptive, what does the graph represent?) . Calculate the mean Calculate the median . Calculate the sample standard deviation (our data is sample from our class, not a population!) . Calculate the Q1 and Q3 values Project: Part 3 - Confidence Intervals Assignment Page 2 of will be checked for originality via the Turnitin plagiarism tool. For more information about Turnitin, click here