Please Indicate


Question: nycflights13 data

You are a junior analyst in the airline industry, specifically working for Virgin America. You are tasked with calculating Virgin America’s available seat miles for all flights leaving each of the three New York Metropolitan area airports separately in 2013, and comparing these figures with those of ExpressJet Airlines Inc, a close rival to your company. Available seat miles are the fundamental units of production for a passenger-carrying airline and it is a measure of capacity. You are asked for two deliverables:

  1. Present these results in
    • A well-formatted and easy to read table
    • A cleanly formatted visualization
  2. Give a two sentence executive summary on the comparison in available seat miles between Virgin America and ExpressJet Airlines Inc for the three NYC airports.

Management offers the following helpful tips: