You must recommend three airlines to the Director of the Grayson County Airport.
ID: 3121296 • Letter: Y
Question
You must recommend three airlines to the Director of the Grayson County Airport.After speaking with him, you determine the following weights:
1. Percent of on-time arrivals = 0.3
2. Percent of Chronically (>5%) Cancelled Flights = 0.2
3. Mishandled Baggage Reports per 100,000 Passengers = 0.15
4. Involuntary Denied Boardings per 100,000 Passengers = 0.1
5. Complaints per 100,000 Enplanements = 0.25
A) Rank the airlines using the range index method
B) Rank the airlines using the percentile index method
C) Which three airlines to you recommend? Explain
Carrier
Percent of on-time arrivals
Percent of Chronically (>5%) Cancelled Flights
Mishandled Baggage Reports per 100,000 Passengers (Pax)
Involuntary Denied Boardings per 100,000 Pax
Complaints per 100,000 Enplanements
Alaska
89.4
1.3
2.49
0.28
0.43
American
85.7
3.8
3.03
0.69
3.1
Delta
91.7
0.0
1.47
0.14
0.63
Envoy
87.8
5.4
4.85
1.79
1.32
Expressjet
84.2
4.5
3.67
1.52
0.51
Frontier
84.9
0.9
2.51
1.22
3.69
Hawaiian
82.8
1.3
2.72
0.04
1.46
Jetblue
80.2
3.8
1.52
0.01
1.92
Skywest
85.7
2.5
2.91
1.2
0.53
Spirit
77.4
2.7
2.27
0.15
11.71
Southwest
88.0
0.8
2.85
1.17
0.49
United
87.7
1.6
2.23
0.63
2.33
Virgin America
84.3
1.4
0.74
0.09
1.92
Carrier
Percent of on-time arrivals
Percent of Chronically (>5%) Cancelled Flights
Mishandled Baggage Reports per 100,000 Passengers (Pax)
Involuntary Denied Boardings per 100,000 Pax
Complaints per 100,000 Enplanements
Alaska
89.4
1.3
2.49
0.28
0.43
American
85.7
3.8
3.03
0.69
3.1
Delta
91.7
0.0
1.47
0.14
0.63
Envoy
87.8
5.4
4.85
1.79
1.32
Expressjet
84.2
4.5
3.67
1.52
0.51
Frontier
84.9
0.9
2.51
1.22
3.69
Hawaiian
82.8
1.3
2.72
0.04
1.46
Jetblue
80.2
3.8
1.52
0.01
1.92
Skywest
85.7
2.5
2.91
1.2
0.53
Spirit
77.4
2.7
2.27
0.15
11.71
Southwest
88.0
0.8
2.85
1.17
0.49
United
87.7
1.6
2.23
0.63
2.33
Virgin America
84.3
1.4
0.74
0.09
1.92
Explanation / Answer
Rank by range inex method
Carrier
Percent of
on-time
arrivals
Percent of
chronicaly
(>5%)
cancelled
flight
mishandlle
d baggage
reports per
1000000
passanger
involuntar y
denied
boaridngs
per
1000000
complint s per
1000000
enplanem
ents
Rank-
percent
of on
time
arrivals
Rank-
percent
of chronicaly
(>5%)
cancelled
flight
Rank-
mishandll
ed beggege
reports
per
1000000
pressanger
Rank-
involunta
ry denied
boaridngs
per
1000000
1-
compalint s per
1000000
enplanem
ents
Rank by percentile inex method
Carrier
Percent of
on-time
arrivals
Percent of
chronicaly
(>5%)
cancelled
flight
mishandlle
d baggage
reports per
1000000
passanger
involuntar y
denied
boaridngs
per
1000000
complint s per
1000000
enplanem
ents
Rank-
percent
of on
time
arrivals
Rank-
percent
of chronicaly
(>5%)
cancelled
flight
Rank-
mishandll
ed beggege
reports
per
1000000
pressanger
Rank-
involunta
ry denied
boaridngs
per
1000000
1-
compalint s per
1000000
enplanem
ents
Carrier
Percent of
on-time
arrivals
Percent of
chronicaly
(>5%)
cancelled
flight
mishandlle
d baggage
reports per
1000000
passanger
involuntar y
denied
boaridngs
per
1000000
complint s per
1000000
enplanem
ents
Rank-
percent
of on
time
arrivals
Rank-
percent
of chronicaly
(>5%)
cancelled
flight
Rank-
mishandll
ed beggege
reports
per
1000000
pressanger
Rank-
involunta
ry denied
boaridngs
per
1000000
1-
compalint s per
1000000
enplanem
ents
Alaska 89.40 1.30 2.49 0.28 0.43 2 9 8 8 13 American 85.70 3.80 3.03 0.69 3.10 6 3 3 6 3 Delta 91.70 0.00 1.47 0.14 0.63 1 13 12 10 9 Envoy 87.80 5.40 4.85 1.79 1.32 4 1 1 1 8 Expressjet 84.20 4.50 3.67 1.52 0.51 10 2 2 2 11 Frontier 84.90 0.90 2.51 1.22 3.69 8 11 7 3 2 Hawaiian 82.80 1.30 2.72 0.04 1.46 11 9 6 12 7 Jetblue 80.20 3.80 1.52 0.01 1.92 12 3 11 13 5 Skywest 85.70 2.50 2.91 1.20 0.53 6 6 4 4 10 Spirit 77.40 2.70 2.27 0.15 11.71 13 5 9 9 1 Southwest 88.00 0.80 2.85 1.17 0.49 3 12 5 5 12 United 87.70 1.60 2.23 0.63 2.33 5 7 10 7 4 virgin America 84.30 1.40 0.74 0.09 1.92 9 8 13 11 5Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.