Age Gender For the following questions, use only the "age" column: 24 M Help for this spreadsheet 23 M Points Age Frequency Distribution: Class Width 5 20 F Review 2.2, 3.1 - 3.3 of your text. Also watch 27 M Class Limits Relative Cumulative Excel Videos in BlackBoard. 40 F Low High Midpoint Freq. Frequency Relative Freq . Your data is already copied into columns A 24 F Limits 19 24 21.5 0.5910 0.5910 20 F Freq 25 30 27.5 0.1360 0.7270 and B. 43 M Mid. HNNNN 31 36 33.5 0.1360 Only cells in yellow need to be completed. - N W W W 0.8640 21 F RF 37 42 39.5 0.0910 0.9550 . Choose a class width according to the 32 F CF 43 48 45.5 0.0450 1.0000 following equation (rounded up to whole 21 M number): 30 F Mean 26.45 *Round to two decimals 36 F Median 23.5 *Round to one decimal CLASS WIDTH = (MAX VALUE - MIN VALUE)/# NNNN 19 M Sample Standard deviation: 7.49 *Round to two decimals of Classes (5) 38 M Q1 20.3 *Round to one decimal . The ogive and polygon graphs need to be 32 M Q3 31.5 *Round to one decimal included on this page under the headers 22 M below. Please do not put them on a separate 21 F 20 F Ogive: Ogive: Polygon: W w 19 M Polygon Relative Frequency 30 F 1.2000 Frequency Polygon 20 M 0.9550 1.0000 1.0000 0.8640 14 13 Total: 25 0.8000 0.7270 12 0.5910 0.6000 10 0.4000 8 0.2000 3 0.0000 2 0 2 3 5 6 N O 1 2 3 4 5For the following two hypothesis tests, use alpha = .05 Points Claim: The average age of online students is 32 years old. Can you prove it is not? 1 Ho: u=32 2 Ha: u not equal 32 Note: Calculation cells should list the numbers and operations Sample mean: 26.45 used to get your answers. Do Sample St. Dev: 7.49 not put the generic formula and show all calculation steps. 2 Distribution: T-Distribution 2 Test Statistic: 3.47 *2 decimals Calculation: 26.45-32/7.49/sqrt(22) 2 p-value: