Exercise 17-10 Static In the United States, baseball has always been a favorite pastime and is rife with statistics and theories

Exercise 17-10 Static In the United States, baseball has always been a favorite pastime and is rife with statistics and theories. Researchers have shown that major league players who have nicknames live longer than those without them. The following table shows a portion of data on the lifespan (Years) of a player and a Nickname variable (Yes if the player had a nickname, No otherwise). Years 74 62 Nickname Yes Yes 64 No pictureClick here for the Excel Data File: a. Create two subsets, one consisting of players with a nickname and the other one without a nickname. Calculate the average longevity for each subset. (Round your answers to 2 decimal places.) Mean Years 68.47 Players with a nickname Players without nickname 64.08 b-1. Estimate a linear regression model of years on a dummy variables d with value 1 if the player had a nickname, o otherwise. Hint: You have to first convert the Nickname categorical variable (Yes/No) into a dummy variable (1/0). (Round coefficient estimates to 4 decimal places) Predicted Years = 64.0833 + 3.9722 0 b-2. Compute the predicted longevity of players with and without a nickname.