Naples, Florida hosts a half-marathon (13.1 mile race) in January each year. The event attracts top runners from throughout the United States as well as from around the world. In the race results shown here 22 men and 31 women entered the 19-24 age class. Finish times in minutes are as follows. Times are shown in order of finish. Please show steps in Excel.aGeorge Towett of Marietta, Georgia finished in first place for the men and Lauren Wald of Gainesville, Florida finished in first place for the women. Compare the first place finish times for men and women. If the 53 men and women runners had competed as one group, in what place would Lauren have finished? bWhat is the median time for men and women runners? Compare men and women runners based on their median times. cProvide a five-number summary for both the men and women dAre there outliers in either group? e.Show the box plats for the two groups. Did men or women have the most variation in finish times? Explain. FinishMenWomen165.30109.03266.27111.22366.52111.65466.85111.93570.87114.38687.18118.33796.45121.25898.52122.089100.50122.4810108.18122.6211109.05123.8812110.23125.7813112.90129.5214113.52129.8715120.95130.7216127.98131.6717128.40132.0318130.90133.2019131.80133.5020138.63136.5721143.83136.7522148.70138.2023 139.0024 147.1825 147.3526 147.5027 147.7528 153.8829 154.8330 189.2731 189.28

By bartleby policy i can gives only 3 subparts answer at a time. Here the first place in mean = 65.30 minutes the first place in women = 109.03 minute If the two groups Men and Women compared in their finishes time. The Lauren finishes the marathon in first place with 109.03-65.30= 43.73 minutes faster.now we use excel as you need : so, Median of men = 109.6405 Median of women = 131.67 By comparing the two median values of men and women : women have the greater median value than the men median time value. Men are 109.6405-131.67 = 22.03 minutes faster than the women. Five number summery : men : Minimum 65.3 1st Quartile 89.4975 Median 109.6405 3rd Quartile 128.295 Maximum 148.7 women : Minimum 109.03 1st Quartile 122.28 Median 131.67 3rd Quartile 143.09 Maximum 189.28

Answered: George Towett of Marietta, Georgia…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Naples, Florida hosts a half-marathon (13.1 mile race) in January each year. The event attracts top runners from throughout the United States as well as from around the world. In the race results shown here 22 men and 31 women entered the 19-24 age class. Finish times in minutes are as follows. Times are shown in order of finish. Please show steps in Excel.

a	George Towett of Marietta, Georgia finished in first place for the men and Lauren Wald of Gainesville, Florida finished in first place for the women. Compare the first place finish times for men and women. If the 53 men and women runners had competed as one group, in what place would Lauren have finished?

b	What is the median time for men and women runners? Compare men and women runners based on their median times.

c	Provide a five-number summary for both the men and women

d	Are there outliers in either group?

e.	Show the box plats for the two groups. Did men or women have the most variation in finish times? Explain.

Finish	Men	Women
1	65.30	109.03
2	66.27	111.22
3	66.52	111.65
4	66.85	111.93
5	70.87	114.38
6	87.18	118.33
7	96.45	121.25
8	98.52	122.08
9	100.50	122.48
10	108.18	122.62
11	109.05	123.88
12	110.23	125.78
13	112.90	129.52
14	113.52	129.87
15	120.95	130.72
16	127.98	131.67
17	128.40	132.03
18	130.90	133.20
19	131.80	133.50
20	138.63	136.57
21	143.83	136.75
22	148.70	138.20
23		139.00
24		147.18
25		147.35
26		147.50
27		147.75
28		153.88
29		154.83
30		189.27
31		189.28