Remember those questions that were difficult or nearly impossible to answer with table 2? See if you can answer them now, using the spreadsheet you modified. Part A
What is the probability that a randomly chosen flight arrives on time?

Part B
Overall, which carrier has the highest probability of arriving on time?

Part C
Given that a randomly chosen flight arrives on time, what is the probability that it arrives in Philadelphia (PHL)?

Part D
Given that the carrier is Hawaiian Airlines (HA), what is the probability that a randomly chosen flight arrives on time?

Part E
If you’re a frequent flyer who travels to many different airports, and you have a choice between SkyWest Airlines (OO) and Southwest Airlines (WN) for all your flights, which carrier should you choose if your primary concern is arriving on time?