Question

Please help me solve this.

5K Results Age Gender Total Time Anderson SC Cornelia GA Elberton GA Williamston SC Lake Geneva WI 25.08 25.20 25.33 25.36 25.82 26.04 26.04 26.07 26.29 26.47 26.54 26.54 26.57 27.99 28.71 8:18 8:33 Anderson SC Anderson SC Anderson SC Williamston SC Elberton GA Piedmont SC Piedmont SC 12 13 8:57 15 Summerville SC Anderson SC 9:26 18 Easley SC Anderson SC Anderson SC 29.20 9:42 10:01 10:13 10:14 10:21 10:27 10:29 10:32 10:33 10:55 10:57 10:59 11:04 11:07 11:19 11:31 31.40 31.43 36 Seneca SC Pendleton SC Simpsonville SC Central SC Hartwell GA Lavonia GA 31.90 31.99 32.02 32.71 32.77 25 36 Townville SC Anderson SC Anderson SC 34.22 34.69 Anderson SC Anderson SC Anderson SC Pendleton SC Pendleton SC Piedmont SC 37.23 38.75 38.78 38.78 12:50 12:51 13:08 40.64 43.56 14:05 Please use the data above from a local 5K race. 1) Create a frequency distribution for gender 2) Draw a bar chart or pie chart to display gender 3) Create a contingency table for "total time" and age for men. Make "total time" intervals of 4 minutes (22-25.99, 26-29.99, 30-33.99, etc.) Put ages in groups of 6-15, 16-25, 26-35, 36-45, 46-55, and 56-65, 66-75 Create a contingency table for "total time" and age for women. Make "total time" intervals of 4 minutes (22-25.99, 26-29.99, 30-33.99, etc.) Put ages in groups of 6-15, 16-25, 26-35, 36-45, 46-55, and 56-65, 66-75 4) 5) Make a bar chart (one chart - show both genders) for the race results by gender. Write a short paragraph to compare/contrast the male/female results. 6) Calculate the mean, mode, and median age for all runners. 7 Calculate the means, modes, and medians for runners' age based on gender 8) Calculate the means, variances, and standard deviations for pace for the first 20 runners based on gender 9) Draw a stem and leaf diagram for age (all runners) 10) Calculate the IQR of age and draw a boxplot (all runners). Are there any outliers?

Answer 1