Math

StatisticsQ&A LibraryThe 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.78Question

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 |

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

Tagged in

Find answers to questions asked by student like you

Show more Q&A

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

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

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:

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.

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

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

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:

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

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