The file P10_08.xlsx contains data on the top 200 professional golfers in 2009.
a. Create a new variable, Earnings per Round, and the ratio of Earnings to Rounds. Then create five scatter plots and corresponding correlations, each with Earnings per Round on the Y axis. The X-axis variables are those that most golf enthusiasts probably think are related to Earnings per Round: Yards/Drive, Driving Accuracy, Greens in Regulation, Putting Average, and Sand Save Pct. Comment on the results. Are any of these highly related to Earnings per Round? Do the correlations have the signs you would expect (positive or negative)?
b. For the two most highly correlated variables with Earnings per Round (positive or negative), run the regressions corresponding to the scatter plots. Explain exactly what they tell you about predicting Earnings per Round. How accurate do you think these predictions would be?