The file P02_29.xlsx contains monthly percentages of on-time arrivals at several of the largest U.S. airports and all of the major airlines from 1988 to 2008. The “By Airline” sheet contains a lot of missing data, presumably because some of the airlines were not in existence in 1988 and some went out of business before 2008. The “By Airport” sheet contains missing data only for Atlantic City International Airport (and we’re not sure why).
a. Calculate summary measures (means, medians, standard deviations, and any other measures you would like to report) for each airline and each airport. How do these deal with missing data?

b. Create histograms for a few of the airports and a few of the airlines, including Atlantic City International. How do these deal with missing data?
c. Create time series graphs for a few of the airports and a few of the airlines, including Atlantic City International. How do these deal with missing data?
d. Which airports and which airlines have done a good job? Which would you like to avoid?