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
Asked Dec 7, 2019
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

Expert Answer

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.

help_outline

Image Transcriptionclose

SUMMARY OUTPUT Regression Statistics Multiple R 0.254476658 R Square 0.06475837 Adjusted R Square -0.039157367 Standard Error 0.194972475 Observations 11 ANOVA Significance F df MS Regression 0.023689789 0.023689789 0.623181547 0.450163282 Residual 0.342128393 0.038014266 Total 10 0.365818182 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% 8.2945E-10 Intercept 72.65580776 2.772961414 26.20152138 66.38293324 78.92868229 DrDist -0.007464771 0.009456037 -0.789418486 0.450163282 -0.028855813 0.013926272

fullscreen
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...

help_outline

Image Transcriptionclose

SUMMARY OUTPUT Regression Statistics Multiple R 0.105712467 0.011175126 R Square Adjusted R Square -0.098694305 Standard Error 0.200480012 Observations 11 ANOVA Significance F 0.757061284 df MS Regression 0.004088064 0.004088064 0.101712784 Residual 0.361730118 0.040192235 Total 10 0.365818182 Coefficients standard Error t Stat P-value Lower 95% Upper 95% Intercept 70.20830079 0.81426339 86.22308413 1.92358E-14 68.36630903 72.05029255 DrAccu 0.004252159 0.013332811 0.318924418 0.757061284 -0.025908754 0.034413072

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

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

Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: A water bottling facility has a mean bottling rate of 33.5 thousand bottles per hour with a standard...

A: From the given information, the population mean for water is 33.5, the population mean for cola is 2...

question_answer

Q: True or False? The sample size required to detect an effect size of 0.25 is larger than the sample s...

A: Sample size for effect size 0.25 is given by

question_answer

Q: 19) A new-car dealer is leasing various brand-new randomly selected models for the monthly rates (in...

A: The formula for 90% confidence interval for variance is shown below:

question_answer

Q: heip Find the indicated IQ score. The graph to the right depicts IQ scores of adults, and those scor...

A: It is given that the mean and standard deviation are 100 and 15, respectively.

question_answer

Q: What is your p value? Interpret it. No, seriously, interpret it. What does it mean? mean=4.035 stdev...

A: P-value:If the null hypothesis is true, then the P-value is the probability of observing at least ex...

question_answer

Q: Using the following data, calculate the χ2, the degrees of freedom, and the effect size.  Would the ...

A: For the given data, the chi-square test for association is appropriate.Null Hypothesis:There is no a...

question_answer

Q: A college admissions officer takes a simple random sample of 90 entering freshmen and computes their...

A: The correct option is: C) No.Given information:

question_answer

Q: what does the mean and the standard deviation represent in data set? how would i interpret the Z-sco...

A: Mean and standard deviation in data set:The mean represent the average value in a data set. In other...

question_answer

Q: Sample grade point averages for ten male students and ten female students are listed. Find the coeff...

A: Descriptive statistics:Step-by-step procedure to obtain the descriptive statistics using Excel:In Ex...