Exercise 6.12.27. The Boston Marathon. GSM, pp. 163-4.
Table 6.33 above left con

Exercise 6.12.27. The Boston Marathon. GSM, pp. 163-4.
Table 6.33 above left contains data for the numbers of men and women who finished the 2012 Boston Marathon, grouped by finishing times. For example, 26 men and one woman finished with a time between two and two and a half hours.
Answer the following questions a through f, Including the parts. Do as much of the arlthmetle in Excel as possible. WRITTEN ANSWERS GO IN THE BOX AT LEFT. USE BLUE FOR THE FONT PLEASE.
(a) Sketch a neat histogram (by hand, on paper) of this distributed data.
(b)(1) Now make a histogram using Excel. (it should go without saying this means to insert a column chart and edit it to remove the gaps between contiguous columns, and do a good job labeling as we have practiced in class many times. The best place for the Legend is at top, directly below the Chart Title)
(b)(11) How well do the two graphs match each other? What was the most challenging part of drawing the graph by hand?
(c)(1) How many men finished the marathon? (c)(i) How many women finished the marathon?
(d)() Use the data to estimate the mode, median and mean running times for the men. Include your explanation/justification for each estimated average.
(d)(il) Mark these estimated averages on the handwntten histogram sketch. (d)(il) Now that you have marked the estimated averages on your handdrawn histogram, take o picture of your graph and upload it to the cloud or email it to yourself. On your computer. download a copy of your picture. Put the picture in this Excel sheet; go to Insert, Picture, then search for and click on your picture. Adjust as needed so it is easy to read and fits neatly. If you need more space than the box above, go ahead and put your picture to the right of these answers instead.
(e) Suppose my friend ran the marathon and finished ahead of half the men. What was his finishing time (approximately)?
(f) About what percentage of the women finished ahead of half the men?