10:13 AM Mon May 1 . . . 100% Flight and Delay Analysis copy Home Insert Draw Layout Review View 0 Q . .. Calibri Bold (Body 16 B I U aA v A ~Ib= 4- Where are the most problems? From the previous analysis, you find that frequency of flights vastly differs across airlines and airports. So simply counting the delays does not reveal the worst performers. In other words, an airline/airport with a large number of flights will also have a large number of delayed flights, but does it mean it is poorly managed? Instead of the total number of delays, we focus on the percentage of delayed flights, which is a better metric for operational performance. a. Provide a bar chart of the percentage of delayed flights per airport. Sort descending. Only keep the top 20 airports. b. Provide a bar chart of the percentage of delayed flights per airline. Sort descending c. What are the ranks of ATL and Delta? 5- Now let's focus on the sources of delays. First you notice that a a vast majority of flights