# Question: The file S03 59 xlsx lists the results of about 20 000 runners

The file S03_59.xlsx lists the results of about 20,000 runners in the 2008 New York Marathon.

a. For all runners who finished in 3.5 hours or less, create a pivot table and corresponding pivot chart of average of Time by Gender. For the same runners, and on the same sheet, create another pivot table and pivot chart of counts by Gender. Comment on the results.

b. For all runners who finished in 3.5 hours or less, create a pivot table and corresponding pivot chart of average of Time by Age. Group by Age so that the teens are in one category, those in their twenties are in another category, and so on. For the same runners, and on the same sheet, create another pivot table and pivot chart of counts of these age groups. Comment on the results.

c. For all runners who finished in 3.5 hours or less, create a single pivot table of average of Time and of counts, broken down by Country. Then filter so that only the 10 countries with the 10 lowest average times appear. Finally, sort on average times so that the fastest countries rise to the top. Guess who the top two are!

a. For all runners who finished in 3.5 hours or less, create a pivot table and corresponding pivot chart of average of Time by Gender. For the same runners, and on the same sheet, create another pivot table and pivot chart of counts by Gender. Comment on the results.

b. For all runners who finished in 3.5 hours or less, create a pivot table and corresponding pivot chart of average of Time by Age. Group by Age so that the teens are in one category, those in their twenties are in another category, and so on. For the same runners, and on the same sheet, create another pivot table and pivot chart of counts of these age groups. Comment on the results.

c. For all runners who finished in 3.5 hours or less, create a single pivot table of average of Time and of counts, broken down by Country. Then filter so that only the 10 countries with the 10 lowest average times appear. Finally, sort on average times so that the fastest countries rise to the top. Guess who the top two are!

**View Solution:**## Answer to relevant Questions

The file S02_12.xlsx includes data on the 50 top graduate programs in the U.S., according to a recent U.S. News & World Report survey.a. Create a table of correlations between all of the numerical variables. Discuss which ...The file S03_65.xlsx lists a lot of data for each NBA team for the seasons 2004–2005 to 2008–2009. The variables are divided into groups: (1) Overall success, (2) Offensive, and (3) Defensive. The basic question all ...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 ...Consider a random variable with the following probability distribution: P(X = 0) = 0.1,P(X = 1) = 0.2, P(X = 2) = 0.3, P(X = 3) = 0.3, and P(X = 4) = 0.1.a. Find P(X ≤ 2)b. Find P(1 < X ≤ 3)c. Find P(X > 0)d. Find P(X > ...Let X be the number of heads when a fair coin is flipped four times.a. Find the distribution of X and then use simulation to generate 1000 values of X.b. Is the simulated distribution indicative of the given probability ...Post your question