# The Professional Golfers Association (PGA) maintains data on performance and earnings for members of the PGA Tour. Scoring average is generally considered the most important statistic in terms of success on the PGA Tour. To investigate the relationship between scoring average and variables such as driving distance (DrDist), driving accuracy (DrAccu), and greens in regulation (GIR) year-end performance data for the 125 players who had the highest total earnings in PGA Tour events for 2008 is provided in cells E1 to K126. Scoring average data is in cells H1 to H126. Driving distance (DrDist) data is in cells I1 to I126. Driving Accuracy (DrAccu) data is in cells J1 to J126. Greens in Regulation (GIR) data is in cells K1 to K126. All data sets have labels in first row. Place output in a separate worksheet.       Use regression analysis to investigate the relationship between scoring average and DrDist. At .05 level of significance, what is your conclusion about the relationship between DrDist and Average score?       Use regression analysis to investigate the relationship between scoring average and DrAccu. At .05 level of significance, what is your conclusion about the relationship between DrAccu and Average score?      Use regression analysis to investigate the relationship between scoring average and GIR. At .05 level of significance, what is your conclusion about the relationship between GIR and Average score?      Which of the variables (DrDist, DrAccu, and GIR) appear to be the most significant?       RankPlayerMoney (\$)Scoring AverageDrDistDrAccuGIR1Vijay Singh6,601,09470.27297.859.4568.452Phil Mickelson5,188,87570.28295.755.2765.813Sergio Garcia4,858,22470.6294.659.3967.064Kenny Perry4,663,79470.2129661.9767.475Anthony Kim4,656,26570.22300.958.3465.786Camilo Villegas4,422,64170.6293.358.1564.67Padraig Harrington4,313,55170.7296.359.3760.678Stewart Cink3,979,30170.65296.955.2766.949Justin Leonard3,943,54270.41281.467.7266.6110Robert Allenby3,606,70070.64291.765.6470.411Jim Furyk3,455,71470.56280.469.3766.78

Question
50 views
 The Professional Golfers Association (PGA) maintains data on performance and earnings for members of the PGA Tour. Scoring average is generally considered the most important statistic in terms of success on the PGA Tour. To investigate the relationship between scoring average and variables such as driving distance (DrDist), driving accuracy (DrAccu), and greens in regulation (GIR) year-end performance data for the 125 players who had the highest total earnings in PGA Tour events for 2008 is provided in cells E1 to K126. Scoring average data is in cells H1 to H126. Driving distance (DrDist) data is in cells I1 to I126. Driving Accuracy (DrAccu) data is in cells J1 to J126. Greens in Regulation (GIR) data is in cells K1 to K126. All data sets have labels in first row. Place output in a separate worksheet. Use regression analysis to investigate the relationship between scoring average and DrDist. At .05 level of significance, what is your conclusion about the relationship between DrDist and Average score? Use regression analysis to investigate the relationship between scoring average and DrAccu. At .05 level of significance, what is your conclusion about the relationship between DrAccu and Average score? Use regression analysis to investigate the relationship between scoring average and GIR. At .05 level of significance, what is your conclusion about the relationship between GIR and Average score? Which of the variables (DrDist, DrAccu, and GIR) appear to be the most significant? Rank Player Money (\$) Scoring Average DrDist DrAccu GIR 1 Vijay Singh 6,601,094 70.27 297.8 59.45 68.45 2 Phil Mickelson 5,188,875 70.28 295.7 55.27 65.81 3 Sergio Garcia 4,858,224 70.6 294.6 59.39 67.06 4 Kenny Perry 4,663,794 70.21 296 61.97 67.47 5 Anthony Kim 4,656,265 70.22 300.9 58.34 65.78 6 Camilo Villegas 4,422,641 70.6 293.3 58.15 64.6 7 Padraig Harrington 4,313,551 70.7 296.3 59.37 60.67 8 Stewart Cink 3,979,301 70.65 296.9 55.27 66.94 9 Justin Leonard 3,943,542 70.41 281.4 67.72 66.61 10 Robert Allenby 3,606,700 70.64 291.7 65.64 70.4 11 Jim Furyk 3,455,714 70.56 280.4 69.37 66.78

check_circle

Step 1

Software procedure for regression in EXCEL.

• Enter the given data in EXCEL sheet as Scoring average in column A, DrDist in column B, DrAccu in column C, and GIR in column D.
• Go to Data > Data Analysis > Regression.
• Select Scoring average and DrDist ranges as ranges of y and x
• Click OK.
Step 2

The output obtained from Excel is given below.

Step 3

From the above result, p-value is 0.45. Therefore, the variable DrDist is not a significant variable to predict Scoring average.

By repeat...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in
MathStatistics