Is there a relationship between total team salary and team performance in a sport such as...

Transcribed Image Text:

Is there a relationship between total team salary and team performance in a sport such as professional basketball? To answer this question we will examine the number of wins and total team payroll in a recent season for all the teams in the National Basketball Association (NBA). The data are in this Excel file. Question 1. Let the x-variable be the team payroll and let the y-variable be the team wins. Find the intercept bo and slope b of the least squares prediction line Wins = b + b*Payroll. intercept (use 2 decimal places in your answer) X slope (use 3 decimal places in your answer) Question 2. If an NBA team spent an additional $11.9 million in team salary, how many more games could the team expect to win? (Use 1 decimal place in your answer). X Question 3. Suppose a basketball team spent $115 million on salaries and won 46 games. Part a. Based on their payroll would they have done better or worse than predicted? (only 1 submission allowed). Better than predicted O Worse than predicted Part b. What is the residual for this basketball team? (use 2 decimal places in your answer) X Question 4. All teams have a goal to make the postseason playoffs. A basketball team thinks that it can make the playoffs next year if it wins 11 more games. How much should the basketball team increase its payroll if it wants to make the playoffs next year? Note: Use 2 decimal places. Your answer should be in units of $1 million; do NOT include a dollar sign in the answer; for example, if a team should increase its payroll by $5,250,000, then the answer is 5.25. $ increase in team payroll (in $million) needed for basketball team to win 11 more games All payrolls are in millions of dollars Recent BASEBALL Team Payrolls and Wins Team Boston Red Sox Cleveland Indians Recent BASKETBALL Team Payrolls and Wins Recent FOOTBALL Team Payrolls and W Payroll Wins Team Los Angeles Angels New York Yankees Arizona Diamondbacks Colorado Rockies Philadelphia Phillies San Diego Padres 197.041 124.116 102 166.375 80 93 Cleveland Cavaliers Los Angeles Lakers Boston Celtics 196.39 91 127.829 93 Orlando Magic Denver Nuggets 127.829 87 100.041 66 69.624 71 Detroit Tigers 199.751 64 Portland Trail Blazers Houston Rockets San Antonio Spurs Dallas Mavericks Payroll Wins 137.363 105.355 35 115.084 55 98.285 25 107.889 46 119.109 119.070 116.154 47 Teams Payroll Wins 50 Los Angeles Chargers 159.904 9 Baltimore Ravens 148.961 9 Chicago Bears 175.382 5 49 Indianapolis Colts New England Patriots New Orleans Saints 155.202 180.07 13 155.884 59 New York Jets 138.837 Philadelphia Eagles 174.507 11 5 13 85.904 24 Dallas Cowboys 145.203 9 New York Mets 154.437 70 New Orleans Pelicans Seattle Mariners 154.319 78 Utah Jazz Chicago Cubs 172.2 92 Atlanta Hawks Atlanta Braves 122.603 72 Phoenix Suns Milwaukee Brewers 63.061 86 Miami Heat 119.800 48 107.613 100.414 24 94.818 21 131.223 44 Denver Broncos 161.567 5 48 Kansas City Chiefs 159.212 10 Seattle Seahawks 180.886 9 Carolina Panthers Cincinnati Bengals 200.122 11 160.399 7 Toronto Blue Jays Los Angeles Dodgers 163.382 76 Chicago Bulls 89.425 27 Green Bay Packers 177.963 7 241.149 104 Philadelphia 76ers Minnesota Twins St. Louis Cardinals 108.103 85 Detroit Pistons 148.153 83 Indiana Pacers Oakland Athletics 81.738 75 Texas Rangers 165.348 78 Houston Astros 124.344 101 Washington Nationals 164.335 97 Cincinnati Reds 95.376 68 Chicago White Sox Miami Marlins 97.8 67 115.406 77 San Francisco Giants Baltimore Orioles Kansas City Royals Pittsburgh Pirates Tampa Bay Rays 180.823 64 164.326 75 143.006 80 95.807 75 70.065 80 Charlotte Hornets Milwaukee Bucks Brooklyn Nets Toronto Raptors New York Knicks Golden State Warriors Minnesota Timberwolves Memphis Grizzlies Oklahoma City under Washington Wizards Los Angeles Clippers Sacramento Kings 100.794 52 100.086 39 94.430 48 117.228 36 120.805 44 96.040 28 116.575 59 107.855 29 137.495 58 117.469 47 110.273 22 134.294 48 124.180 43 118.907 42 95.628 17 Jacksonville Jaguars New York Giants Pittsburgh Steelers Los Angeles Rams Tennessee Titans Atlanta Falcons Buffalo Bills San Francisco 49ers Houston Texans 181.576 10 164.404 E 166.458 161.092 13 155.806 11 167.004 9 175.558 10 149.558 9 6 141.31 4 Miami Dolphins Minnesota Vikings Arizona Cardinals 188.287 6 168.716 13 167.723 00 8 Washington Redskins Cleveland Browns Tampa Bay Buccaneers 153.307 Detroit Lions 182.306 7 186.197 0 5 Oakland Raider 203.201 170.166 9 6 Is there a relationship between total team salary and team performance in a sport such as professional basketball? To answer this question we will examine the number of wins and total team payroll in a recent season for all the teams in the National Basketball Association (NBA). The data are in this Excel file. Question 1. Let the x-variable be the team payroll and let the y-variable be the team wins. Find the intercept bo and slope b of the least squares prediction line Wins = b + b*Payroll. intercept (use 2 decimal places in your answer) X slope (use 3 decimal places in your answer) Question 2. If an NBA team spent an additional $11.9 million in team salary, how many more games could the team expect to win? (Use 1 decimal place in your answer). X Question 3. Suppose a basketball team spent $115 million on salaries and won 46 games. Part a. Based on their payroll would they have done better or worse than predicted? (only 1 submission allowed). Better than predicted O Worse than predicted Part b. What is the residual for this basketball team? (use 2 decimal places in your answer) X Question 4. All teams have a goal to make the postseason playoffs. A basketball team thinks that it can make the playoffs next year if it wins 11 more games. How much should the basketball team increase its payroll if it wants to make the playoffs next year? Note: Use 2 decimal places. Your answer should be in units of $1 million; do NOT include a dollar sign in the answer; for example, if a team should increase its payroll by $5,250,000, then the answer is 5.25. $ increase in team payroll (in $million) needed for basketball team to win 11 more games All payrolls are in millions of dollars Recent BASEBALL Team Payrolls and Wins Team Boston Red Sox Cleveland Indians Recent BASKETBALL Team Payrolls and Wins Recent FOOTBALL Team Payrolls and W Payroll Wins Team Los Angeles Angels New York Yankees Arizona Diamondbacks Colorado Rockies Philadelphia Phillies San Diego Padres 197.041 124.116 102 166.375 80 93 Cleveland Cavaliers Los Angeles Lakers Boston Celtics 196.39 91 127.829 93 Orlando Magic Denver Nuggets 127.829 87 100.041 66 69.624 71 Detroit Tigers 199.751 64 Portland Trail Blazers Houston Rockets San Antonio Spurs Dallas Mavericks Payroll Wins 137.363 105.355 35 115.084 55 98.285 25 107.889 46 119.109 119.070 116.154 47 Teams Payroll Wins 50 Los Angeles Chargers 159.904 9 Baltimore Ravens 148.961 9 Chicago Bears 175.382 5 49 Indianapolis Colts New England Patriots New Orleans Saints 155.202 180.07 13 155.884 59 New York Jets 138.837 Philadelphia Eagles 174.507 11 5 13 85.904 24 Dallas Cowboys 145.203 9 New York Mets 154.437 70 New Orleans Pelicans Seattle Mariners 154.319 78 Utah Jazz Chicago Cubs 172.2 92 Atlanta Hawks Atlanta Braves 122.603 72 Phoenix Suns Milwaukee Brewers 63.061 86 Miami Heat 119.800 48 107.613 100.414 24 94.818 21 131.223 44 Denver Broncos 161.567 5 48 Kansas City Chiefs 159.212 10 Seattle Seahawks 180.886 9 Carolina Panthers Cincinnati Bengals 200.122 11 160.399 7 Toronto Blue Jays Los Angeles Dodgers 163.382 76 Chicago Bulls 89.425 27 Green Bay Packers 177.963 7 241.149 104 Philadelphia 76ers Minnesota Twins St. Louis Cardinals 108.103 85 Detroit Pistons 148.153 83 Indiana Pacers Oakland Athletics 81.738 75 Texas Rangers 165.348 78 Houston Astros 124.344 101 Washington Nationals 164.335 97 Cincinnati Reds 95.376 68 Chicago White Sox Miami Marlins 97.8 67 115.406 77 San Francisco Giants Baltimore Orioles Kansas City Royals Pittsburgh Pirates Tampa Bay Rays 180.823 64 164.326 75 143.006 80 95.807 75 70.065 80 Charlotte Hornets Milwaukee Bucks Brooklyn Nets Toronto Raptors New York Knicks Golden State Warriors Minnesota Timberwolves Memphis Grizzlies Oklahoma City under Washington Wizards Los Angeles Clippers Sacramento Kings 100.794 52 100.086 39 94.430 48 117.228 36 120.805 44 96.040 28 116.575 59 107.855 29 137.495 58 117.469 47 110.273 22 134.294 48 124.180 43 118.907 42 95.628 17 Jacksonville Jaguars New York Giants Pittsburgh Steelers Los Angeles Rams Tennessee Titans Atlanta Falcons Buffalo Bills San Francisco 49ers Houston Texans 181.576 10 164.404 E 166.458 161.092 13 155.806 11 167.004 9 175.558 10 149.558 9 6 141.31 4 Miami Dolphins Minnesota Vikings Arizona Cardinals 188.287 6 168.716 13 167.723 00 8 Washington Redskins Cleveland Browns Tampa Bay Buccaneers 153.307 Detroit Lions 182.306 7 186.197 0 5 Oakland Raider 203.201 170.166 9 6