Your team is hired by DOT as consultants to analyze the flight delays in order t
ID: 3358518 • 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 HBsss 43 9080 2214 1756 0513435 Total 1. 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? 2. What are some recommendations for people that are flying to prevent these delays. What are some recommendations for airports so that they can improve this problem? Please answer on an essay form. Two page max)Explanation / Answer
The reasons for flight delays can be classified as follows
a) due to Airport operations
Facilities lacking to quickly issue boarding pass, baggage check in, Immigration and Security Clearance
b) due to Specific Airline
Late Arriving Aircraft
Improper Aircraft maintenance / Baggage loading / Passenger boarding / Cabin Crew preparedness / refilling fuel and food
c) due to poor air traffic management in Control Room
Congestion in Traffic
d) due to accumulated delays
Lack of quick clearance on accumulated delays
e) due to unavoidable circumstances
Bad/Extreme Weather or Natural Disaster
Unfortunate Terrorism associated Events
1)
From the data the following can be inferred.
The passenger traffic is high during weekends and first half of the week.
The delay gets accumulated from Saturday to Tuesday. Probably that is the reason why Tuesdays have most number of delays
The accumulated delays cleared and low traffic during second half(excluding Saturday) of the week together brings down the number of delays during the second half(excluding Saturday) of the week.
That explains why Friday is minimum number of delays
2)
Recommendations for people that are flying to prevent these delays.
Recommendations for airports to prevent these delays.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.