Question

The following table shows on-time arrivals, mishandled bags /1000 passengers, and customer complaints per 1000 passengers for 10 airlines. The data will be used in a series of questions. You may want to copy it in to an Excel spreadsheet, which you can do electronically (by which I mean you don’t have to input each cell).

Airline	On-Time Arrivals %	Mishandled Bags per 1000 passengers	Customer Complaints per 1000 passengers
Virgin	83.5	.87	1.50
JetBlue	79.1	1.88	0.79
Allegiant	87.1	1.58	0.91
Delta	86.5	2.10	0.73
Alaska/Virgin	87.5	2.93	0.51
Frontier	77.9	2.22	1.05
Southwest	83.1	3.08	0.25
American	85.9	2.14	1.74
United	76.9	2.92	1.80
Air Canada	77.4	3.87	4.24

1. For all the airlines, what is the average of on-time arrivals? Mishandled bags? Customer complaints? The variances and standard deviations? (Feel free to use Excel functions for this purpose.)
2. If you are flying Delta, what is the chance that your flight will be on time?
3. Which airline has the worst overall performance as measured by the number of customer complaints?
4. If you randomly choose one of the 10 airlines for a follow-up study on airline quality ratings, what is the probability that you will pick an airline with less than 2 mishandled bags per 1000 passengers?
5. If you choose a randomly selected US airlines, are you more likely to land on time than if you chose Air Canada?

Answer 1

We use Excel to solve this question-

                 On-Time Arrivals %   Mishandled Bags per 1000 passengers   Customer Complaints per 1000 passengers
Average                82.49                 2.36                                          1.35
Variances         18.35               0.74                                            1.29
SD                  4.28                 0.86                                     1.14

If If you are flying Delta, the chance that your flight will be on time 86.5%

From given information / data, Observe that Air Canada airline has the worst overall performance as measured by the number of customer complaints.

Let x = Number of airline with less than 2 mishandled bags per 1000 passengers is 3.
n = Total number of airlines with mishandled bags per 1000 passengers is 10.
Probability that you will pick an airline with less than 2 mishandled bags per 1000 passengers = x /n = 3/10 = 0.3

Yes If I choose a randomly selected US airlines, then it is more likely to land on time than if you chose Air Canada because on time arrival for US airlines is 76.9% which is more as compared to Air Canada 77.4% and customer complaint per 1000 passengers for Air Canada is larger than the US airline.