Question
A news reporter wants to assess the top 30 college quarterbacks. The reporter recorded the number of plays (x) and the number of passes (y)
A news reporter wants to assess the top 30 college quarterbacks. The reporter recorded the number of plays (x) and the number of passes (y) a quarterback completed in one season. Use Excel to find the best fit linear regression equation. Round the slope and intercept to two decimal places.
x y 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started