A baseball scout wants to assess the talent at 5 local colleges. The scout took the top 6 players at each school and recorded their slugging percentage ($x$) and average exit velocity ($y$) of a hit ball. Use Excel to determine the equation of the linear regression line and round your answers to the nearest hundredth. \begin{tabular}{|c|c|} \hline x & y \\ \hline 0.353 & 89.9 \\ 0.407 & 90.7 \\ 0.421 & 86.3 \\ 0.414 & 89.2 \\ 0.4 & 89.1 \\ 0.319 & 88 \\ 0.323 & 87.7 \\ \hline \end{tabular}
Added by Emily B.
Close
Step 1
Label the first column "x" for slugging percentage and the second column "y" for average exit velocity. Enter the data as follows: x: 0.353, 0.407, 0.421, 0.414, 0.4, 0.319, 0.323 y: 89.9, 90.7, 86.3, 89.2, 89.1, 88, 87.7 Show more…
Show all steps
Your feedback will help us improve your experience
Megha Sharma and 68 other Intro Stats / AP Statistics educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
A baseball scout wants to assess the talent at 5 local colleges. The scout took the top players at each school and recorded their slugging percentage and average exit velocity of a hit ball. Use Excel to find the best fit linear regression equation. Round the slope and intercept to two decimal places.
Kari H.
Tim T.
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. Y = 81.596 + 1.093X1 + 1.646X2, where Y = average number of yards per drive, X1 = ball speed, X2 = launch angle. Adjusted R2 = 0.826. 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. The ball speed of the new player = 170 mph launch angle = 11 degree. The predicted value of the average number of yards per drive is Y = 81.596 + 1.093*170 + 1.646*11 = 285.512. In part (d) of question-2, data contained in the DATAfile PGADrivingDistance (PGA Tour website, November 1, 2012) was used to develop an estimated regression equation to predict the average number of yards per drive given the ball speed and the launch angle. Help with these two questions below: 1. Does the estimated regression equation provide a good fit to the data? Explain. 2. In part (b) of question-2, an estimated regression equation was developed using only ball speed to predict the average number of yards per drive. Compare the fit obtained using just ball speed to the fit obtained using ball speed and the launch angle.
Adi S.
Recommended Textbooks
Elementary Statistics a Step by Step Approach
The Practice of Statistics for AP
Introductory Statistics
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD