Recall that the file Golf Stats.xlsx contains data on the 200 top golfers each year from 2003 to 2009. The question to be explored in this problem is what drives earnings, and whether this is consistent from year to year.
a. For each year, create a new variable Earnings/Event. This is potentially a better measure of earnings because some players enter more events than others.
b. Create a separate table of correlations for each year that includes Earnings/Event, Yards/Drive, Driving Accuracy, Greens in Regulation, Putting Average, Sand Save Pct, and Birdies/Round. Explain whether these correlations help answer the questions posed above.
c. There is a saying in golf: “Drive for show, putt for dough.” Create a separate set of scatter plots for each year of Earnings/Event (Y axis) versus each of Yards/Drive, Driving Accuracy, and Putting Average. Discuss whether these scatter plots tend to support the saying.