Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Your team is hired by DOT as consultants to analyze the flight delays in order t

ID: 3358686 • Letter: Y

Question

Your team is hired by DOT as consultants to analyze the flight delays in order to understand major factors impacting flight delays and therefore to advise consumers how to avoid such delays. There are millions of flight delays and cancellations every year. Due to data size restriction in Excel application, DOT has provided you with all flight delays in July and August of 2015 (during the summer time) from United Airlines. All on-time and cancelled flights, and the flights with missing information were excluded from the analysis The total number of flight delays for the analysis is 18,767. DELAYS PER DAY OF WEEK 3111 3051 3435 3080 2214 2120 1756 Total Analyze the chart. Why does Tuesday have the most delays in days of the week during July and August. Why does Friday have the least? What are some recommendations for people that are flying to prevent these delays (Weather delays, timing, technological problems, etc.). What are some recommendations for airports so that they can improve this problem? 1. 2. Please answer on an essay form.

Explanation / Answer

1.The data is a bar chart of the number of delays during the July and August month of United Airlines. The total number of flight delays for the analysis was found to be 18,767.Further, the bar chart shows that Tuesday has the most number of flight delays during these two months, and Friday has the least. One reason could be bad weather on Tuesday which might have increased the number of flight delays. Other reasons could be backups within the aviation system and airline-related issue. On Tuesday airline may have experienced such issues compared to all other days.Further,no significant issues have been noted on Friday causing least number of delays in flight.

2.In order to prevent these flights from delays, it is essential to provide accurate aircraft position information on the ground for smooth airport operations.Holdups can be detected by developing the early-warning system.Also, introducing more flights can resolve the issue. Data sharing can be used to provide better and more updated data to improve decision making for the United Airlines.

References:

NextGen – Data Sharing Helps Airlines Reduce Delays. (2017). Faa.gov. Retrieved 9 November 2017, from https://www.faa.gov/nextgen/snapshots/stories/?slide=9