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)
- Bicycling 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_forwardA local construction company is trying to reduce costs. It found that the price of steel bars varies considerably from manufacturer to manufacturer. The table below shows the cost of one steel bar from different manufacturers. Calculate the IQR. Cost for One Steel Bar Emerson $4.31 Mannix $6.20 United $5.67 American $2.79 National $3.20 Pracox $3.57 Steelco $5.32 Cost per Steel Bar 7 6 4 3 2 1 O $2.47 O $2.53 O $4.32 O $5.36arrow_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.† 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 r2. (Round your answer to three decimal…arrow_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.† 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 r2. (Round your answer to three decimal…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.† 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 r2. (Round your answer to three decimal…arrow_forwardUse excel to do all calculations. Please show all work.arrow_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 (Bicycling website). DATA file Brand FELT F5 PINARELLO Paris ORBEA Orca GDR EDDY MERCKX EMX-7 BH RC1 Ultegra BH Ultralight 386 CERVELO S5 Team GIANT TCR Advanced 2 WILIER TRIESTINA Gran Turismo (to 3 decimals) Weight Price ($) 17.8 16.1 14.9 15.9 Did the estimated regression equation provide a good fit? The estimated regression equation provided a - Select your answer - fit. c. Predict the price for a bike that weighs 15 pounds. (to whole number) 2100 6250 8370 6200 17.2 13.1 16.2 17.1 17.6 SPECIALIZED S-Works Amira SL4 14.1 8000 a. Use the data to develop an estimated regression equation that could…arrow_forwardone standart?arrow_forward16 20 40 60 80 100 Miles (1000s) 120 Scatter diagram 1 b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? Negative relationship c. Develop the estimated regression equation that could be used to predict the price ($1000s) (to 4 decimals). 16.469 .0588 I d. Test for a significant relationship at the 0.05 level of significance (to 3 decimals). p-value= less than α = 0.05. e. Did the estimated regression equation provide a good fit? Yes f. Provide terpretation for the slope of the estimated regression equation (to 4 decimals but dollar value to the nearest cent). Enter negative values as negative numbers. The slope of the estimated regression is -.0588. Therefore, every additional 1,000 miles on the car's odometr will result in a $ predicted price. decrease in the g. Suppose that you are considering purchasing a previously owned 2007 Camry that has been driven 60,000 miles. Using the estimated regression equation developed in…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