This first yearly chart shows a general

Explore discuss data innovations to drive business efficiency forward.
Post Reply
phonedata
Posts: 112
Joined: Mon Dec 23, 2024 3:21 am

This first yearly chart shows a general

Post by phonedata »

The data has a record for average delay in minutes for each flight route for the month. This level of aggregation is too much to be able to identify very short-term effects on flight delays (e.g. one-day strikes or short-lived weather events such as a storm passing through), but it should be sufficient to see events that had a bigger impact and to identify any long term trends.

We can start by looking at the average delay across all routes for monthly/yearly and month of year bandings. long-term downward trend in the average flight delay with an cyprus mobile numbers interesting spike in 2010 that disturbs this pattern.

Branded Reporting Period (Years)

If we drill into this and go down to a monthly view we can see why there was a spike in 2010. The highest value (yellow circle) of 38.64 minutes average delay across all flights occurred in December 2010. From personal memory (with a 1 month old baby!) I remember very clearly the copious amounts of snow and very low temperatures that month. This is quite likely to be the reason for this anomaly. The next highest value – 33.70 minutes in September 2001 – is almost certainly down to the heightened security measures in place and delays caused by the 9/11 attacks.


Finally, let’s look at a banding by the Month of Year. Not surprisingly (based on the previous two results), December is the month with the highest average delay. Following that, the summer months (in which there are more flights) have higher delays then spring and autumn.
Post Reply