1 Tables

Using the data set from the reference lab of PNW flights, choose three analytical questions from the menu below, and design a table for each one that answers it in a publication-ready format (using your choice of table library), including appropriate column names, etc. Unless otherwise specified, all questions should be explored for flights departing from Portland. Alternatively, please feel free to come up with your own analyses!

Which airlines had the best and worst track records of on-time departures in each month? Is it different between PDX and SEA?
Which airlines improved the most in terms of on-time departures over time, and on which routes? Which airlines got worse?
What cities have the most service from Portland (defined however you like, but do make sure to define it clearly!), and which have the worst?
By month, what new routes were added or removed?
- Hint: I haven’t tried this one, but dplyr’s lead and lag commands could be helpful
Finding busy aircraft (identified by tailnum), with “business” defined as:
- Which specific aircraft (tailnum) are seen most often, for whom do they fly, and on what routes?
- Which specific aircraft accumulate the most flight time?
- Which specific aircraft log the most distance?
Descriptive statistics comparing several characteristics of long-haul vs. short-haul routes (defined however you like, but you must be clear about your definition)
- the air_time column will be useful here
Time of Day: are some destinations from PDX “morning” destinations vs “evening” ones?

Make sure to keep in mind the design principles that we discussed on Monday regarding spacing, use of rules, row-vs-column orientation, alignment, etc., and provide a short description of your design and its motivation.

Lab 05: Tables & Fonts Challenge

Steven Bedrick

4/29/2020

1 Tables

2 Fonts