Written Assignment Chapter 4 1. Name_____________________________________ There is an excel file attached to this assignment. The document contains the ages of male and female runners of the 2019 Boston Marathon. Use Excel to find the answers to the following questions and to make the parallel box plots of the data. a) (2 points) Find the 5-number summary for the male runners. List them in order of minimum, quartile 1, median, quartile 3, and max. b) (2 points) Find the 5-number summary for the female runners. List them in order of minimum, quartile 1, median, quartile 3, and max. c) (4 points) Create side-by-side (parallel) box plots of the two data sets in excel and embed the graphs in the word document you submit for this assignment. d) (4 points) Write a paragraph explaining what conclusions you can draw from this data. For full credit, you must write a detailed explanation that draws from looking at the data and comparing the box plots. ...
Purchase answer to see full attachment