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

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

Hi,

Thanks for the question.

Answer 1)

Tuesday have the most delays in the week because Tuesdays are the busiest day of the week. Most of the travellers are the frequent travellers which leads the flights to delay the most.

Similarly, since the Friday is the starting of the weekend, the traveller set is very low which leads less traffic and fewer delays.

Answer 2)

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.