You boss at Delta Airlines has noticed certain stations are consistently having issues with on-time departures (D0). He would like to know if this poor D0 performance is due to capacity growth at the respective stations. You are tasked with calculating D0 performance for all stations, identifying those with poor D0 scores and comparing these scores to first quarter (1Q) year-over-year (YoY) change in available seats (capacity) between 2015 and 2016. Does the data support your boss' suspicion that poor D0 performance is due to YoY capacity growth at these outstations?

• D0 is calculated by counting the number of departures where Out is less than or equal to Scheduled Departure and dividing by the total number of departures.
• Capacity is calculated by summing the maximum seating capacity of each aircraft departure.
• YoY change is calculated by dividing the difference in the new value and the old value by the old value.

Submit your findings as a scatterplot graph with D0 performance on the x-axis and YoY capacity change in the y-axis. Your graph must be on the first worksheet in the MS Excel file (.xlsx) and on a separate worksheet from the data.

Answer rating: 100% (QA)

To analyze the relationship between D0 performance and YoY capacity change and create a scatterplot ... View the full answer