Naples Florida hosts a half-marathon (13.1 mile race) in January each year. The
ID: 3060020 • Letter: N
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. 22 men and 31 women entered the 19-24 age class. Finish times in minutes are contained in order of finish in the Excel Online file below. Construct a spreadsheet to answer the following questions.
1
Are there outliers in either group?
If data contain outliers enter the value. If there are no outliers, leave blank. If there is more than one value, separate your answers with commas (to 2 decimals)
Outliers in the men's group = ?
Outliers in the women's group = ?
Finish Men Women1
65.53 109.26 2 66.50 111.45 3 66.75 111.88 4 67.08 112.16 5 71.10 114.61 6 87.41 118.56 7 96.68 121.48 8 98.75 122.31 9 100.75 122.71 10 108.41 122.85 11 109.28 124.11 12 110.46 126.01 13 113.13 129.75 14 113.75 130.10 15 121.18 130.95 16 128.21 131.90 17 128.63 132.26 18 131.13 133.43 19 132.03 133.73 20 138.86 136.80 21 144.06 136.98 22 148.93 138.43 23 139.23 24 147.41 25 147.58 26 147.73 27 147.98 28 154.11 29 155.06 30 189.50 31 189.51Explanation / Answer
For men
Inter Quartile Range =Q3-Q1 = 129.26-83.33 =45.93
Inner fence = Q1- 1.5IQR = 83.33 -1.5 * 45.93 = 14.435
Outer Fence = Q3+ 1.5IQR = 129.26+1.5*45.93 =198.155
No outliers for men's group
For Women :
Inter Quartile Range =Q3-Q1 = 147.41 - 122.31 = 25.1
Inner fence = Q1- 1.5IQR = 122.31-1.5*25.1 = 84.66
Outer Fence = Q3+ 1.5IQR = 147.41+1.5*25.1 = 185.06
Outliers for women's group are 189.50, 189.51 = 2 outliers
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.