# Question

The file S03_58.xlsx lists salaries of MLB players in the years 2007 to 2009. Each row corresponds to a particular player. As indicated by blank salaries, some players played in one of these years, some played in two of these years, and the rest played in all three years.

a. Create a new Yes/No variable, All 3 Years, that indicates which players played all three years.

b. Create two pivot tables and corresponding pivot charts. The first should show the count of players by position who played all three years. The second should show the average salary each year, by position, for all players who played all three years. Explain briefly what these two pivot tables indicate.

c. Define a StatTools data set on only the players who played all three years. Using this data set, create a table of correlations of the three salary variables. What do these correlations indicate about player salaries?

a. Create a new Yes/No variable, All 3 Years, that indicates which players played all three years.

b. Create two pivot tables and corresponding pivot charts. The first should show the count of players by position who played all three years. The second should show the average salary each year, by position, for all players who played all three years. Explain briefly what these two pivot tables indicate.

c. Define a StatTools data set on only the players who played all three years. Using this data set, create a table of correlations of the three salary variables. What do these correlations indicate about player salaries?

## Answer to relevant Questions

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 ...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 ...Several major automobile producers are competing to have the largest market share for sport utility vehicles (SUVs) in the coming quarter. A professional automobile market analyst assesses that the odds of General Motors not ...A fair coin (i.e., heads and tails are equally likely) is tossed three times. Let X be the number of heads observed in three tosses of this fair coin. a. Find the probability distribution of X.b. Find the probability that ...A personnel manager of a large manufacturing plant is investigating the number of reported on-the-job accidents at the facility over the past several years. Let X be the number of such accidents reported during a one-month ...Post your question

0