# Question

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.

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.

## Answer to relevant Questions

Unfortunately, StatTools doesn’t have a stacked option for its correlation procedure, which would allow you to get a separate table of correlations for each category of a categorical variable. The only alternative is to ...The file S03_57.xlsx lists the average salary for each NFL team from 2004 to 2009, along with the number of team wins each of these years. Answer the same questions as in the problem 55 for this football data. The file S03_64.xlsx lists monthly data since 1950 on the well-known Dow Jones Industrial Average (DJIA), as well as the less well-known Dow Jones Transportation Average (DJTA) and Dow Jones Utilities Average (DJUA). Each of ...The publisher of a popular financial periodical has decided to undertake a campaign in an effort to attract new subscribers. Market research analysts in this company believe that there is a 1 in 4 chance that the increase in ...A study has shown that the probability distribution of X, the number of customers in line (including the one being served, if any) at a checkout counter in a department store, is given by P(X = 0) = 0.25, P(X = 1) = 0.25, ...Post your question

0