110 likes | 238 Views
Will I Make My Connection?. Ryan Chen Bonny Simi. Scenario. Grandparents invited the young couple to Florida for Family reunion during Thanks Giving. They booked tickets which connect them to Florida through JFK on Wednesday at 7pm.
E N D
Will I Make My Connection? Ryan Chen Bonny Simi
Scenario • Grandparents invited the young couple to Florida for Family reunion during Thanks Giving. • They booked tickets which connect them to Florida through JFK on Wednesday at 7pm. • They thought having 20 minutes of connection time should be good. As soon as they arrived at the airport they realized their starting flight is already delayed by 1 hour. • When they get to the connecting point, they misconnected…
Objectives Using historical data, our project and analysis seeks to answer the following questions: • What is the probability of making a connecting flight through JFK airport on JetBlue airlines in the days around Thanksgiving? • How much time between connecting flights should someone allow to guarantee making the connection? • What is the minimum time the airline should allow while still having a high success rate?
Data Description Data used in this analysis: • Flight information for departures/arrivals to JFK collected from Nov. 15 – 30, 2006 to 2007 over 24 hour period. These include their scheduled time and actual time. This data set is huge as it contains a total of around 10,000+ flights. • Weather information for JFK for same dates from Nov. 15 – 30, 2003 to 2007 over 24 hour period. An IA indicates instrumental approach which means bad weather. It turns out weather affects connection time.
Procedures • For each flight in our data set, we calculated the delay as: Delay = Actual Time – Scheduled Time • Given the delay for every single flight, we create a distribution table and maps base on the amount of time that is delayed. The intervals are 0 delay, 10 mins, 20 mins, 30 mins, 1 hour, 2 hour. • These data were further divided into four equal time periods: 1) Midnight-05:59am, 2) 06:00-11:59am, 3) noon-05:59pm and 4) 06:00pm-Midnight.
Does Weather Matter? • Along with time of the day, weather plays another important factor in affecting the delays of flights, both arrivals and departures, for every time period we studied. Bad weather increased the probability of a delay from 6%-22% depending on the time of day. On average, a passenger’s chance of a delay increased 10% with bad weather.
Analysis and Model Prerequisite probabilities needed for the analysis: P(on-time), P(delay) P(good weather), P(bad weather) P(delay length | time of day & weather) – delay categorized as shown in table • considering impact of time of day, weather and arrival/departure status on delay Probability Tree for Making a Connection
Mis-Connection Probability Model Assumptions: • Three minimum connection time possibilities: 35, 45, or 60 min • For delay length of 0 to 9 min. P(connection) = 100% Summarized P(connection) calculation: P(making connection)= (P(arriving on-time | good wx) * 100%) + (P(arriving 1-9 late | good wx) * 100%) + (P(arriving 10-19 late | good wx) * P(departing 10+ late | good wx)) + ((P(arriving 20-29 late | good wx) +… (for all delay categories)…+ (the same as above, the previous but instead given bad weather conditions)
Final Results and Conclusion For Thanks Giving or similar high-season holidays, we recommend a minimum connection time of 45 min before 12pm and 60 min for flights after 12pm to give both customers and service providers a better experience.