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.

Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
Relevant Tutors available to help