CLASS:
MATH225N – Statistical Reasoning for the Health Sciences
MATH225N Week 8 Performing Linear Regressions with Technology Excel
Question
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 launch angle and batted barrel rate of a hit ball. This sample data is provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
Launch Angle Barrel Batted Rate
5.1 5.2
7.7 10.6
13.1 6.1
12.2 7.9
19.2 7.8
13.4 3.1
16.5 2.1
8.2 2.3
21 8.2
8.5 7.1
13.2 13.1
16.3 12.3
15.8 8.4
9.8 2.5
7.5 6.4
13.9 10.6
14 11
3.4 6
18.6 11
9.1 21.1
21 6
3 6.7
15.5 13.8
18.4 6.9
14.3 12.8
19.7 3.3
14.6 5.7
2.9 4.8
19.4 6.3
13.7 8.4
Ans: r=0.08
Question
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.
x y
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
0.349 86.1
0.383 88.7
0.386 91.6
0.499 89.7
0.492 90.4
0.43 86
0.334 84.2
0.421 86.9
0.396 90.6
0.567 91.6
0.44 89.3
0.466 90
0.522 95.1
0.375 88.6
0.37 88.4
0.489 89.4
0.397 87.2
0.454 88.2
0.293 86.6
0.348 88
0.365 88.4
0.37 86.7
0.414 88.8
Ans:
yˆ=19.56x+80.76
Question
The heights (in inches) and weights (in pounds) of 25 baseball players are given below. Use Excel to find the best fit linear regression equation, where height is the explanatory variable. Round the slope and intercept to two decimal places.
Height Weight
71 186
72 211
73 220
70 165
72 180
72 195
70 175
74 202
78 240
71 170
74 180
73 185
76 257
77 215
76 287
77 220
73 200
76 223
76 200
70 220
75 215
71 195
77 194
75 195
75 225
Ans
yˆ=6.53x−275.47.
Question
A news reporter wants to assess the top 30 college quarterbacks. The reporter recorded the number of plays and the number of passes a quarterback completed in one season.
This sample data is provided below. Use Excel to calculate
Plays Passes
519 104.3
678 109.4
373 50.7
319 43.7
496 83.6
430 47.4
542 49.4
357 74.7
642 99.6
592 54.3
417 62.5
701 84.7
457 48
815 119.8
394 45.8
514 59.4
527 55.7
494 44.4
487 49.6
305 43.5
565 46.7
551 68.9
644 86.3
403 45.7
605 51.7
819 100.5
479 67.5
468 46.6
544 57.7
532 68.1
Ans
r≈0.71…………………………..purchase all the questions and answers at $10 only
Reviews
There are no reviews yet.