I am having a hard time figuring out what my frequency would be and how to set it up in order to do so.

Project Student File (SUMMER 2024)-2.xIsx - Neat Office Calc File Edit View Insert Format Styles Sheet Data Tools Window Help Calibri 17 S E = AB D E G H M N 1 Age Gender For the following questions, use only the "age" column: 2 0 19 Y Help for this spreadsheet 3 20 Y Points Age Frequency Distribution: Class Width 4 21 Y Review 2.2, 3.1- 3.3 of your text. Also watch 5 22 Y Class Limits Relative Cumulative Excel Videos in BlackBoard. 6 22 N Low High Midpoint Freq. Frequency Relative Freq Your data is already copied into columns A 17 22 Y Limits and B. 2 18 27 22.5 8 22 N Freq. 27 36 31.5 Only cells in yellow need to be completed. 23 N Mid! 36 45 40.5 Choose a class width according to the 10 24 Y NNNN RF 45 54 49.5 following equation (rounded up to whole 11 27 Y CF 54 63 58.5 number): 12 28 N CLASS WIDTH = (MAX VALUE - MIN VALUE)/# 13 29 Y Sample Size of Classes (5) 14 30 Y Mean 30.85 *Round to two decimals The ogive and polygon graphs need to be 15 33 Y Median 27.5 *Round to one decimal included on this page under the headers 16 33 Y Sample Standard deviation: 11.80 *Round to two decimals below. Please do not put them on a separate 17 40 Y 2 page. Q1 22 *Round to one decima 18 43 Y Q3 34.75 #Round to one decimal 19 45 Y 20 53 Y 21 61 N Ogive Ogive: Polygon: w U 22 Polygon 23 24 25 26 Total: 27 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 K 1 1 + Part 2 Descriptive Statistics Part 3 Confidence Intervals Part 4 Hypothesis Test Project Help Sheet 1 of 4 PageStyle_Part 2 Descriptive Statistics English (USA) Type here to search M 99+ 9 DELL ESC F1 F2 F3 F4 F5 F6 F7 F8 F10 F11