Project: Part 2 Descriptive Statistics Assignment For this part of the project, you will calculate descriptive statistics for the rst 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 equency, and cumulative relative frequency Make a cumulative relative frequency ogive 0 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 0 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 A B C D E F G H K M N O P Q R N Age Gende For the following, use Column A for your data W 20 M CLICK HERE: VIDEO TO CREATE AN OG A 26 F Age Frequency Distribution: Class Width 5 24 POINT DISTRIBUTION Cumulative 6 25 Class Limits Relative Relative 49 Point Values Points Earned Low High Midpoint Frequency Frequency Frequency 24 F Class Limits N N 22 M Midpoint 10 26 M Frequency N INSERT RELATIVE 11 37 M Relative Frequency FREQUENCY OGIVE IN 12 32 M Cumulative Relative Frequer THIS THE GRAY BOX 13 25 M 23 M Mean Mean 15 44 M Median Median 16 M Sample Standard Deviation NNNNN Sample Standard deviation: 24 Quartile 1 Q1 BT 19 M Quartile 3 03 19 50 M 20 20 M Ogive: W 21 28 M |Polygon w 22 21 M LICK HERE: VIDEO TO CREATE A FREQUENC 23 27 M TOTAL POINTS 25 0 = 0% 24 20 F Week 3 Week 5 Week 6 Project - Video Helps +