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

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 23PPS
icon
Related questions
Question
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

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 3 images

Blurred answer
Knowledge Booster
Types of Data and Their Measurement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL