Thank you in advance; screenshots help a lot if you can provide them.

Predicting LPGA Player's Average Score: The attached file has statistics for 134 Ladies Professional Golfers Association (LPGA) members. The variables included are:

1. Golfers: names of the golfers

2. Earnings ($): the total earnings in thousands of dollars

3. Scoring Avg.: the average score for all events

4. Greens in Reg.: the percentage of time a player can hit the greens in regulation.

5. Putting Avg. is the average number of putts taken on greens hit in regulation.

6. Drive Accuracy: the percentage of times a tee shot rests in the fairway.

Note: A green is considered a hit in regulation if any part of the ball touches the putting surface, and the difference between the value of par for the hole and the number of strokes taken to hit the green is at least 2.

Answer the following questions on the same Excel document where you run the analysis (for convenience, you can insert a text box and write the answers there) and upload only one Excel document.

a. Develop an estimated regression equation that can be used to predict the average score for all events given the average number of putts taken on greens hit in regulation.

b. Develop an estimated regression equation that can be used to predict the average score for all events given the percentage of time a player can hit the greens in regulation, the average number of putts taken on greens hit in regulation, and the rate of times a player's tee shot comes to rest in the fairway.

c. At the .05 level of significance, test whether the two independent variables added in part (b), the percentage of time a player can hit the greens in regulation and the rate of times a player's tee shot comes to rest in the fairway, contribute significantly to the estimated regression equation developed in part (a). Explain.