Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra And Trigonometry Enhanced With Graphing Utilities

Authors: Michael Sullivan, Michael Sullivan III

7th Edition

0134269039, 9780134269030

More Books

Students also viewed these Mathematics questions

Question

Population

Answered: 1 week ago

Question

The feeling of boredom.

Answered: 1 week ago