Excel Tables: Using Structured References and Analysis

Excel Tables: Using Structured References and Analysis - student project

Learning and practicing the use of structured references with tables in Excel.

 

Analysis Takeaways: It appears that flights with Hawaiian Airlines Inc. in 2015 had the longest delays on average, with the longest delays being in April (average of 25.3) and October (average of 41.5). In contrast, you were more likely to arrie early with Virgin America in 2015 even though their average flight was nearly double the distance of Hawaiian Airlines flights. On average, people flew the least distance in January and December of 2015 and travelled the furtherst in March and October of 2015. In 2015, you might have wanted to avoid flights in January and June if you wanted to avoid longer-than-average delays.