Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Find the 10th and 90th percentiles and the first and third quartiles for the time difference between the scheduled and actual arrival times for the
Find the 10th and 90th percentiles and the first and third quartiles for the time difference between the scheduled and actual arrival times for the Atlanta Airline Data nk provided. Use the formula 100 + 0.5, the Excel PERCENTILE.INC function, and the Rank and Percentile tool, and compare the results. Click the icon to view the data.Atlanta Airline Data Table Sample of Delta Airline Flight Statistics, Atlanta Hartsfield International (ATL) December 24, 2009 Flight Number Origin Airport Scheduled Actual Arrival Time Difference Taxi-in Time Arrival Time Time (Minutes) (Minutes) 66 DFW 15:18 15:14 - 4 9 1078 LAS 13:21 13:17 - 4 6 1228 RSW 15:22 15:17 - 5 17 1030 PHX 17:49 17:40 - 9 10 1859 BOS 14:07 13:48 - 19 9 2060 TPA 10:10 10:11 18 1310 MCO 11:04 10:50 - 14 8 1068 SFO 19:40 19:42 2 13 1865 BOS 17:49 17:25 - 24 9 1951 DCA 08:00 07:59 - 1 9 1948 SAN 15:03 14:58 - 5 8 1604 MDW 18:15 18:18 3 14 1517 JAX 06:40 06:31 - 9 7 2032 FLL 10:49 10:41 - 8 10 1258 MSY 08:34 08:43 9 17 1304 MCO 08:11 07:52 - 19 8 2008 SRQ 08:44 08:52 14\fNow, similar to the procedures used for the 10th and 90th percentiles, find the first and third quartiles using each of the three methods. Use the formula first. Using the formula, the first quartile is - 14 and the third quartile is 3. (Round to the nearest integer as needed.) Using the Excel PERCENTILE INC function, the first quartile is -13 and the third quartile is 3. (Round to the nearest integer as needed.) Note that when using the Rank and Percentile tool, the first and third quartiles may not be values in the data set. In this case, the quartiles can be found by averaging the two nearest percentiles. Using the Rank and Percentile tool, the first quartile is -12 and the third quartile is 3. (Round to the nearest integer as needed.) Compare the results for the first and third quartiles. The results using the formula are different from the results using the Excel PERCENTILE INC function. The results using the formula are different from the results using the Rank and Percentile tool. The results using the Excel PERCENTILE. INC function are different from the results using the Rank and Percentile tool
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started