The file Golf Stats.xlsx contains data on the 200 top golfers each year from 2003 to 2017. (This data set is used in an example in the next section.) For the 2017 data, create a recoded Age variable, with values “Twenties,” “Thirties,” and “Forties,” based on their ages in the 2017 sheet. Then calculate the mean, median, and standard deviation of the following 2017 variables, broken down by the recoded Age. Comment on whether it appears that golfers peak in their thirties.
a. Earnings
b. Yards/Drive and Driving Accuracy
c. Greens in Regulation
d. Putting Average (Golfers want this to be small.)