Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
6th Edition
ISBN: 9780357228708
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 15.2, Problem 9E

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.

  1. a. Develop an estimated regression equation that can be used to predict the average number of yards per drive given the club head speed.
  2. b. Develop an estimated regression equation that can be used to predict the average number of yards per drive given the ball speed.
  3. 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.
  4. 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.
  5. 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.

Expert Solution
Check Mark
To determine

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 y^=124.7160+1.3943(Club Head Speed).

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 y^=b0+b1x1+...+bpxp, where y^ is the predicted value of response or dependent variable, and x1,x2,...,xp are the k predictor variables. The quantities b1,b2,...,bp are the estimated slopes corresponding to x1,x2,...,xp, respectively and b0 is the estimated intercept of the line from the sample data.

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:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card), Chapter 15.2, Problem 9E , additional homework tip  1

Thus, the estimated regression equation that could be used to predict the average number of yards per drive given the club head speed is y^=124.7160+1.3943(Club Head Speed).

b.

Expert Solution
Check Mark
To determine

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 y^=117.14+0.9876(BallSpeed).

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:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card), Chapter 15.2, Problem 9E , additional homework tip  2

Thus, the estimated regression equation that could be used to predict the average number of yards per drive given the ball speed is y^=117.14+0.9876(BallSpeed).

c.

Expert Solution
Check Mark
To determine

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:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card), Chapter 15.2, Problem 9E , additional homework tip  3

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:

y^=113.852.231(Club Head)+2.515(BallSpeed).

In the given output, R2=77.14%.

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:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card), Chapter 15.2, Problem 9E , additional homework tip  4

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.

Expert Solution
Check Mark
To determine

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:

y^=81.60+1.0927(Ball Speed)+1.646(Launch Angle).

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:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card), Chapter 15.2, Problem 9E , additional homework tip  5

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:

y^=81.60+1.0927(Ball Speed)+1.646(Launch Angle).

e.

Expert Solution
Check Mark
To determine

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 y^=81.60+1.0927(Ball Speed)+1.646(Launch Angle).

Thus, the predicted average number of yards per drive for the new player is as follows:

y^=81.60+1.0927(170)+1.646(11)=81.60+185.759+18.106=285.465

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?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
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 places.) Did the…
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). ŷ = -1,439x + 28,574 (b) Compute r. (Round your answer to three decimal places.) = 0.864
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). %3D (b) Compute r. (Round your answer to three decimal places.) ,2 = Did the estimated regression…

Chapter 15 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)

Ch. 15.3 - 11. In exercise 1, the following estimated...Ch. 15.3 - 12. In exercise 2, 10 observations were provided...Ch. 15.3 - Prob. 13ECh. 15.3 - Prob. 14ECh. 15.3 - 15. In exercise 5, the owner of Showtime Movie...Ch. 15.3 - Prob. 16ECh. 15.3 - In part (d) of exercise 9, data contained in the...Ch. 15.3 - Prob. 18ECh. 15.5 - In exercise 1, the following estimated regression...Ch. 15.5 - Prob. 20ECh. 15.5 - Prob. 21ECh. 15.5 - Prob. 22ECh. 15.5 - Testing Significance in Theater Revenue. Refer to...Ch. 15.5 - Testing Significance in Predicting NFL Wins. The...Ch. 15.5 - The Condé Nast Traveler Gold List provides ratings...Ch. 15.5 - Prob. 26ECh. 15.6 - Prob. 27ECh. 15.7 - 32. Consider a regression study involving a...Ch. 15.7 - Prob. 33ECh. 15.7 - 34. Management proposed the following regression...Ch. 15.7 - Repair Time. Refer to the Johnson Filtration...Ch. 15.7 - Prob. 36ECh. 15.7 - Prob. 37ECh. 15.8 - Prob. 40ECh. 15.8 - Exercise 5 gave the following data on weekly gross...Ch. 15.8 - The following table reports the price, horsepower,...Ch. 15 - 49. The admissions officer for Clearwater College...Ch. 15 - The personnel director for Electronics Associates...Ch. 15 - Prob. 46SECh. 15 - Recall that in exercise 44, the admissions officer...Ch. 15 - Recall that in exercise 45 the personnel director...Ch. 15 - Fortune magazine publishes an annual list of the...Ch. 15 - The Department of Energy and the U.S....Ch. 15 - The Tire Rack, an online distributor of tires and...Ch. 15 - The National Basketball Association (NBA) records...Ch. 15 - Consumer Research, Inc., is an independent agency...Ch. 15 - Matt Kenseth won the 2012 Daytona 500, the most...Ch. 15 - When trying to decide what car to buy, real value...
Knowledge Booster
Background pattern image
Statistics
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.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Elementary Geometry For College Students, 7e
Geometry
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Cengage,
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License