3. Find the 10th and 90th percentiles and the first and third quartiled for the time difference between the schedule and actual arrival times for the Atlanta airline data provided. Use thw formula nk/100 + 0.5, the excel percentile inc function and the rank rank and percentile tool, and compare the results. (See picture)   Using the formula the 10th percentile is ____ and the 90th percentile i. _____

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter10: Sequences, Series, And Probability
Section10.2: Arithmetic Sequences
Problem 68E
icon
Related questions
icon
Concept explainers
Topic Video
Question

3. Find the 10th and 90th percentiles and the first and third quartiled for the time difference between the schedule and actual arrival times for the Atlanta airline data provided. Use thw formula nk/100 + 0.5, the excel percentile inc function and the rank rank and percentile tool, and compare the results. (See picture)

 

Using the formula the 10th percentile is ____ and the 90th percentile i. _____

 

Hight Number oigin Airport
Scheduled Arrival Time
Actual Arrival Time
Time Difference (Minutes)
Taxi-in Time (Minutes)
2088 IAH
12,42
13:10
28
12
1716 CLT
09:43
1002
19
12
1516 AUS.
19:17
1931
14
16
1258 MSY
08:34
08 43
6.
17
1122 EYW
14:45
14 42
10
10
1852 SRQ
07:39
0736
-3
108 MCO
17:09
16 52
-17
1
1900 DEN
12:22
13 00
38
1908 DEN
18:10
18 44
34
7.
1693 SNA
21:20
2100
-20
7.
1793 LGA
20:55
20 28
-27
6.
1030 PHX
17:49
1740
6-
-12
10
2054 TPA
07:03
06 51
1779|LGA
13:58
13 28
-30
1790 SAT
16:40
17:15
35
10
1140 PBI
20:49
20 55
9.
39
1531 JAX
11:35
1117
-18
1118 MCO
18:34
1831
-3
15
2014 ELP
12:44
1259
15
8.
1789 LGA
18:54
1837
-17
15
130 SLC
14:15
1438
23
1945 ORD
18:20
18:34
14
10
1918 D FW
12:45
1252
7.
10
1953 DCA
09:17
09:06
-11
14
2030 FLL
09:58
10:12
14
15
1653 MKE
08:53
09:00
10
1306 FLL
18:56
19.04
8.
13
2085 JAX
10:45
10:32
-13
6.
1714 ONT
13:41
14 07
26
1734 MIA
20:53
2045
-8
13
1632 TPA
17:45
1728
-17
12
0 00
Transcribed Image Text:Hight Number oigin Airport Scheduled Arrival Time Actual Arrival Time Time Difference (Minutes) Taxi-in Time (Minutes) 2088 IAH 12,42 13:10 28 12 1716 CLT 09:43 1002 19 12 1516 AUS. 19:17 1931 14 16 1258 MSY 08:34 08 43 6. 17 1122 EYW 14:45 14 42 10 10 1852 SRQ 07:39 0736 -3 108 MCO 17:09 16 52 -17 1 1900 DEN 12:22 13 00 38 1908 DEN 18:10 18 44 34 7. 1693 SNA 21:20 2100 -20 7. 1793 LGA 20:55 20 28 -27 6. 1030 PHX 17:49 1740 6- -12 10 2054 TPA 07:03 06 51 1779|LGA 13:58 13 28 -30 1790 SAT 16:40 17:15 35 10 1140 PBI 20:49 20 55 9. 39 1531 JAX 11:35 1117 -18 1118 MCO 18:34 1831 -3 15 2014 ELP 12:44 1259 15 8. 1789 LGA 18:54 1837 -17 15 130 SLC 14:15 1438 23 1945 ORD 18:20 18:34 14 10 1918 D FW 12:45 1252 7. 10 1953 DCA 09:17 09:06 -11 14 2030 FLL 09:58 10:12 14 15 1653 MKE 08:53 09:00 10 1306 FLL 18:56 19.04 8. 13 2085 JAX 10:45 10:32 -13 6. 1714 ONT 13:41 14 07 26 1734 MIA 20:53 2045 -8 13 1632 TPA 17:45 1728 -17 12 0 00
Expert Solution
Step 1

Given information:

Pk=nk100+0.50

Arrange the given data in ascending order:

-30, -27, -20, -18, -17, -17, -17, -13, -12, -11, -9, -8, -3, -3, -3, 6, 7, 7, 8, 9, 14, 14, 14, 15, 19, 23, 26, 28, 34, 35, 38

Use the given formula to determine 10th and 90th percentile:

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Centre, Spread, and Shape of a Distribution
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill