Question: The files S02 29 xlsx contain monthly percentages of on time arrivals at

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.


View Solution:


Sale on SolutionInn
Sales0
Views89
Comments
  • CreatedApril 01, 2015
  • Files Included
Post your question
5000