The files S02_29.xlsx contain monthly percentages of on-time arrivals at several of the largest U.S. airports.
a. Explain why the current format of either data set limits the kind of information you can obtain with a pivot table. For example, does it allow you find the average on-time arrival percentage by year for any selected subset of airports, such as the average for O’Hare, Los Angeles International, and La Guardia?
b. Restructure the data appropriately and then use a pivot table to answer the specific question in part a.

  • CreatedApril 01, 2015
  • Files Included
Post your question