Concept explainers
The Professional Golfers Association (PGA) maintains data on performance and earnings for members of the PGA Tour. For the 2012 season Bubba Watson led all players in total driving distance, with an average of 309.2 yards per drive. Some of the factors thought to influence driving distance are club head speed, ball speed, and launch angle. For the 2012 season Bubba Watson had an average club head speed of 124.69 miles per hour, an average ball speed of 184.98 miles per hour, and an average launch angle of 8.79 degrees. The DATAfile named PGADrivingDist contains data on total driving distance and the factors related to driving distance for 190 members of the PGA Tour (PGA Tour website, November 1, 2012). Descriptions for the variables in the data set follow.
Club Head Speed: Speed at which the club impacts the ball (mph).
Ball Speed: Peak speed of the golf ball at launch (mph).
Launch Angle: Vertical launch angle of the ball immediately after leaving the club (degrees).
Total Distance: The average number of yards per drive.
- a. Develop an estimated regression equation that can be used to predict the average number of yards per drive given the club head speed.
- b. Develop an estimated regression equation that can be used to predict the average number of yards per drive given the ball speed.
- c. A recommendation has been made to develop an estimated regression equation that uses both club head speed and ball speed to predict the average number of yards per drive. Do you agree with this? Explain.
- d. Develop an estimated regression equation that can be used to predict the average number of yards per drive given the ball speed and the launch angle.
- e. Suppose a new member of the PGA Tour for 2013 has a ball speed of 170 miles per hour and a launch angle of 11 degrees. Use the estimated regression equation in part (d) to predict the average number of yards per drive for this player.
a.
Find the estimated regression equation that could be used to predict the average number of yards per drive given the club head speed.
Answer to Problem 9E
The estimated regression equation that could be used to predict the average number of yards per drive given the club head speed is
Explanation of Solution
Calculation:
The Professional Golfers Association (PGA) data consist of information regarding to the speed at which the club impacts the ball (club head speed), peak speed of the golf ball at launch (ball speed), vertical launch angle of the ball immediately after leaving the club (launch angle), and the average number of yards per drive (total distance).
Multiple linear regression model:
A multiple linear regression model is given as
Denote y as the dependent variable total distance.
Regression:
Software procedure:
Step-by-step procedure to get regression equation using EXCEL software:
- Open the file PGADrivingDist.
- Select Data > Data Analysis > Regression.
- Click OK.
- Under Input Y Range enter $E$1:$E$191.
- Under Input X Range enter $B$1:$B$191.
- Click the box of Labels.
- Under Output Range enter $H$1.
- Click OK.
Output obtained using EXCEL software is given as follows:
Thus, the estimated regression equation that could be used to predict the average number of yards per drive given the club head speed is
b.
Find the estimated regression equation that could be used to predict the average number of yards per drive given the ball speed.
Answer to Problem 9E
The estimated regression equation that could be used to predict the average number of yards per drive given the ball speed is
Explanation of Solution
Calculation:
The regression equation can be obtained using excel software.
Regression:
Software procedure:
Step-by-step procedure to get the regression equation using EXCEL software:
- Open the file PGADrivingDist.
- Select Data > Data Analysis > Regression.
- Click OK.
- Under Input Y Range enter $E$1:$E$191.
- Under Input X Range enter $C$1:$C$191.
- Click the box of Labels.
- Under Output Range enter $H$24.
- Click OK.
Output obtained using EXCEL software is given as follows:
Thus, the estimated regression equation that could be used to predict the average number of yards per drive given the ball speed is
c.
Explain whether developing an estimated regression equation that uses both club head speed and ball speed to predict the average number of yards per drive is useful or not.
Explanation of Solution
Calculation:
Regression:
Software procedure:
Step-by-step procedure to get the regression equation using EXCEL software:
- Open the file PGADrivingDist.
- Select Data > Data Analysis > Regression.
- Click OK.
- Under Input Y Range enter $E$1:$E$191.
- Under Input X Range enter $B$1:$C$191.
- Click the box of Labels.
- Under Output Range enter $H$24.
- Click OK.
Output obtained using EXCEL software is given as follows:
Thus, the estimated regression equation that could be used to predict the average number of yards per drive given both club head speed and ball speed is as follows:
In the given output,
Thus, only 77.14% variability in total distance can be explained by variability in club head and ball speed.
Scatter Diagram:
Software procedure:
Step-by-step procedure to obtain scatter diagram using EXCEL software:
- Open the file PGADrivingDist.
- Select the cell Range $B$1:$C$191.
- Go to insert and select scatter plot.
- Click OK
Output obtained using EXCEL software is given as follows:
The scatter diagram exhibits a strong positive linear relationship between ball speed and club head speed. Both the variables in the same model are not recommended as the linear effect of one variable describes the linear effect of the other variable. As a result, the other variable will be of little additional value. Thus, there is a chance of multicollinearity.
Thus, developing an estimated regression equation that uses both club head speed and ball speed to predict the average number of yards per drive is not useful.
d.
Find the estimated regression equation that could be used to predict the average number of yards per drive given the ball speed and the launch angle.
Answer to Problem 9E
The estimated regression equation that could be used to predict the average number of yards per drive given both ball speed and launch angle is as follows:
Explanation of Solution
Calculation:
The regression equation can be obtained using Excel software.
Regression:
Software procedure:
Step-by-step procedure to get the regression equation using EXCEL software:
- Open the file PGADrivingDist.
- Select Data > Data Analysis > Regression.
- Click OK.
- Under Input Y Range enter $E$1:$E$191.
- Under Input X Range enter $C$1:$D$191.
- Click the box of Labels.
- Under Output Range enter $H$24.
- Click OK.
Output obtained using EXCEL software is given as follows:
Thus, the estimated regression equation that could be used to predict the average number of yards per drive given both ball speed and launch angle is as follows:
e.
Predict the average number of yards per drive for the new player using the obtained equation in part (d).
Answer to Problem 9E
The predicted average number of yards per drive for the new player is 285.465 yards.
Explanation of Solution
Calculation:
The ball speed of a new PGA player is 170 mph with launch angle of 11 degrees.
From Part (b), it is found that the estimated regression equation that could be used to predict the average number of yards per drive given both club head speed and launch angle is
Thus, the predicted average number of yards per drive for the new player is as follows:
Thus, the predicted average number of yards per drive for the new player is 285.465 yards.
Want to see more full solutions like this?
Chapter 15 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
- Name the four characteristics of a good definition.arrow_forwardThe data set shows the ages of members in a book club. What is the club's median age?arrow_forwardThe Toyota Camry is one of the best-selling cars in North America. The cost of a previously owned Camry depends on many factors, including the model year, mileage, and condition. To investigate the relationship between the car's mileage and the sales price for Camrys, the following data show the mileage and sale price for 19 sales (PriceHub web site, February 24, 2012). DATA file Miles (1,000s) Price ($1,000s) 22 16.2 29 16.0 36 13.8 47 11.5 63 12.5 77 12.9 73 11.2 87 13.0 92 11.8 101 10.8 110 8.3 28 12.5 59 11.1 68 15.0 68 12.2 91 13.0 42 15.6 65 12.7 110 8.3arrow_forward
- Mackenzie makes the minimum salary for an Actuary. Stacy makes the median salary for a CPA.arrow_forwardBicycling, the world's leading cycling magazine, reviews hundreds of bicycles throughout the year. Their "Road-Race" category contains reviews of bikes used by riders primarily interested in racing. One of the most important factors in selecting a bike for racing is the weight of the bike. The following data show the weight (pounds) and price ($) for 10 racing bikes reviewed by the magazine.T Brand Weight Price ($) FELT F5 17.8 2,100 PINARELLO Paris 16.1 6,250 ORBEA Orca GDR 14.9 8,370 EDDY MERCKX EMX-7 15.9 6,200 BH RC1 Ultegra 17.2 4,000 BH Ultralight 386 13.1 8,600 CERVELO S5 Team 16.2 6,000 GIANT TCR Advanced 2 17.1 2,580 WILIER TRIESTINA Gran Turismo 17.6 3,400 SPECIALIZED S-works Amira SL4 14.1 8,000 (a) Use the data to develop an estimated regression equation that could used to estimate the price a bike given the weight. (Round your numerical values to the nearest integer). (b) Compute 2. (Round your answer to three decimal places.) Did the estimated regression equation provide…arrow_forwardBicycling, the world's leading cycling magazine, reviews hundreds of bicycles throughout the year. Their "Road-Race" category contains reviews of bikes used by riders primarily interested in racing. One of the most important factors in selecting a bike for racing is the weight of the bike. The following data show the weight (pounds) and price ($) for 10 racing bikes reviewed by the magazine.t Brand Weight Price ($) FELT F5 17.8 2,100 PINARELLO Paris 16.1 6,250 ORBEA Orca GDR 14.9 8,370 EDDY MERCKX EMX-7 15.9 6,200 BH RC1 Ultegra 17.2 4,000 BH Ultralight 386 13.1 8,600 CERVELO S5 Team 16.2 6,000 GIANT TCR Advanced 2 17.1 2,580 WILIER TRIESTINA Gran Turismo 17.6 3,400 SPECIALIZED S-works Amira SL4 14.1 8,000 (a) Use the data to develop an estimated regression equation that could be used to estimate the price for a bike given the weight. (Round your numerical values to the nearest integer). ŷ = -1,439x + 28,574 (b) Compute r. (Round your answer to three decimal places.) = 0.864arrow_forward
- Bicycling, the world's leading cycling magazine, reviews hundreds of bicycles throughout the year. Their "Road-Race" category contains reviews of bikes used by riders primarily interested in racing. One of the most important factors in selecting a bike for racing is the weight of the bike. The following data show the weight (pounds) and price ($) for 10 racing bikes reviewed by the magazine.t Brand Weight Price ($) FELT F5 17.8 2,100 PINARELLO Paris 16.1 6,250 ORBEA Orca GDR 14.9 8,370 EDDY MERCKX EMX-7 15.9 6,200 BH RC1 Ultegra 17.2 4,000 BH Ultralight 386 13.1 8,600 CERVELO S5 Team 16.2 6,000 GIANT TCR Advanced 2 17.1 2,580 WILIER TRIESTINA Gran Turismo 17.6 3,400 SPECIALIZED S-works Amira SL4 14.1 8,000 (a) Use the data to develop an estimated regression equation that could be used to estimate the price for a bike given the weight. (Round your numerical values to the nearest integer). (b) Compute 2. (Round your answer to three decimal places.) 2 =| Did the estimated regression…arrow_forwardBicycling, the world's leading cycling magazine, reviews hundreds of bicycles throughout the year. Their "Road-Race" category contains reviews of bikes used by riders primarily interested in racing. One of the most important factors in selecting a bike for racing is the weight of the bike. The following data show the weight (pounds) and price ($) for 10 racing bikes reviewed by the magazine.t Brand Weight Price ($) FELT F5 17.8 2,100 PINARELLO Paris 16.1 6,250 ORBEA Orca GDR 14.9 8,370 EDDY MERCKX EMX-7 15.9 6,200 BH RC1 Ultegra 17.2 4,000 BH Ultralight 386 13.1 8,600 CERVELO S5 Team 16.2 6,000 GIANT TCR Advanced 2 17.1 2,580 WILIER TRIESTINA Gran Turismo 17.6 3,400 SPECIALIZED S-works Amira SL4 14.1 8,000 (a) Use the data to develop an estimated regression equation that could be used to estimate the price for a bike given the weight. (Round your numerical values to the nearest integer). (b) Compute 2. (Round your answer to three decimal places.) 12 = Did the estimated regression…arrow_forwardBicycling, the world's leading cycling magazine, reviews hundreds of bicycles throughout the year. Their "Road-Race" category contains reviews of bikes used by riders primarily interested in racing. One of the most important factors in selecting a bike for racing is the weight of the bike. The following data show the weight (pounds) and price ($) for 10 racing bikes reviewed by the magazine.t Brand Weight Price ($) FELT F5 17.8 2,100 PINARELLO Paris 16.1 6,250 ORBEA Orca GDR 14.9 8,370 EDDY MERCKX EMX-7 15.9 6,200 BH RC1 Ultegra 17.2 4,000 BH Ultralight 386 13.1 8,600 CERVELO S5 Team 16.2 6,000 GIANT TCR Advanced 2 17.1 2,580 WILIER TRIESTINA Gran Turismo 17.6 3,400 SPECIALIZED S-works Amira SL4 14.1 8,000 (a) Use the data to develop an estimated regression equation that could be used to estimate the price for a bike given the weight. (Round your numerical values to the nearest integer). %3D (b) Compute r. (Round your answer to three decimal places.) ,2 = Did the estimated regression…arrow_forward
- The World’s Highest Waterfalls: The Information Please Almanac lists the world’s highest waterfalls. The list shows that Angel Falls in Venezuela is 3281 feet high, or more than twice as high as Ribbon Falls in Yosemite, California, which is 1612 feet high. What kind of data are these heights?arrow_forwardFind the IQR of this data set.arrow_forwardBicycling World, a magazine devoted to cycling, reviews hundreds of bicycles throughout the year. Its "Road-Race" category contains reviews of bicycles used by riders primarily interested in racing. One of the most important factors in selecting a bicycle for racing is the weight of the bicycle. The following data show the weight (pounds) and price ($) for ten racing bicycles reviewed by the magazine. Click on the datafile logo to reference the data. Model Weight (lb) Price ($) Fierro 7B 17.9 2,200 HX 5000 16.2 6,350 Durbin Ultralight 15.0 8,470 Schmidt 16.0 6,300 WSilton Advanced 17.3 4,100 Bicyclette vélo 13.2 8,700 Supremo Team 16.3 6,100 XTC Racer 17.2 2,680 D'Onofrio Pro 17.7 3,500 Americana #6 14.2 8,100 How much of the variation in the prices of the bicycles in the sample does the regression model you estimated in part (b) explain? If required, round your answer to the nearest whole number. Do not round intermediate…arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillElementary Geometry For College Students, 7eGeometryISBN:9781337614085Author:Alexander, Daniel C.; Koeberlein, Geralyn M.Publisher:Cengage,Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
- Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell