Answer Happy

Is there a relationship between total team salary and team
performance in a sport such as professional basketball?
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 by of the least squares prediction line Wins = bo + b1"Payroll intercept (use 2 decimal places in your answer) slope (use 3 decimal places in your answer) Question 2. If an NBA team spent an additional $8.1 million in team salary, how many more games could the team expect to win? (Use 1 decimal place in your answer). Question 3. Suppose a basketball team spent $113 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) 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 Smillion) needed for basketball team to win 11 more games

1 All payrolls are in millions of dollars 2 Recent BASEBALL Team Payrolls and Wins 3 Team Payroll Wins 4 Boston Red Sox 197.041 93 5 Cleveland Indians 124.116 102 6 Los Angeles Angels 166.375 80 7 New York Yankees 196.39 91 8 Arizona Diamondbacks 127.829 93 9 Colorado Rockies 127.829 87 10 Philadelphia Phillies 100.041 66 11 San Diego Padres 69.624 71 12 Detroit Tigers 199.751 64 13 New York Mets 154.437 70 14 Seattle Mariners 154.319 78 15 Chicago Cubs 172.2 92 16 Atlanta Braves 122.603 72 17 Milwaukee Brewers 63.061 86 18 Toronto Blue Jays 163.382 76 19 Los Angeles Dodgers 241.149 104 20 Minnesota Twins 108.103 85 21 St. Louis Cardinals 148.153 83 22 Oakland Athletics 81.738 75 Recent BASKETBALL Team Payrolls and Wins Team Payroll Wins Cleveland Cavaliers 137.363 50 Los Angeles Lakers 105.355 35 Boston Celtics 115.084 55 Orlando Magic 98.285 25 Denver Nuggets 107.889 46 Portland Trail Blazers 119.109 49 Houston Rockets 119.070 65 San Antonio Spurs 116.154 47 Dallas Mavericks 85.904 24 New Orleans Pelicans 119.800 48 Utah Jazz 107.613 48 Atlanta Hawks 100.414 24 Phoenix Suns 94.818 21 Miami Heat 131.223 44 Chicago Bulls 89.425 27 Philadelphia 76ers 100.794 52 Detroit Pistons 100.086 39 Indiana Pacers 94.430 48 Charlotte Hornets 117.228 36 Recent FOOTBALL Team Payrolls and Wins Teams Payroll Wins Los Angeles Chargers 159.904 9 Baltimore Ravens 148.961 9 Chicago Bears 175.382 5 Indianapolis Colts 155.202 4 New England Patriots 180.07 13 New Orleans Saints 155.884 11 New York Jets 138.837 5 Philadelphia Eagles 174.507 13 Dallas Cowboys 145.203 9 Denver Broncos 161.567 5 Kansas City Chiefs 159.212 10 Seattle Seahawks 180.886 9 Carolina Panthers 200.122 11 Cincinnati Bengals 160.399 7 Green Bay Packers 177.963 7 Jacksonville Jaguars 181.576 10 New York Giants 164.404 3 Pittsburgh Steelers 161.092 13 Los Angeles Rams 155.806 11

44 9 78 101 28 10 97 59 9 68 29 6 67 58 4 165.348 124.344 164.335 95.376 97.8 115.406 180.823 164.326 143.006 95.807 70.065 77 23 Texas Rangers 24 Houston Astros 25 Washington Nationals 26 Cincinnati Reds 27 Chicago White Sox 28 Miami Marlins 29 San Francisco Giants 30 Baltimore Orioles 31 Kansas City Royals 32 Pittsburgh Pirates 33 Tampa Bay Rays 34 35 Milwaukee Bucks 120.805 Brooklyn Nets 96.040 Toronto Raptors 116.575 New York Knicks 107.855 Golden State Warriors 137.495 Minnesota Timberwolves 117.469 Memphis Grizzlies 110.273 Oklahoma City Thunder 134.294 Washington Wizards 124.180 Los Angeles Clippers 118.907 Sacramento Kings 95.628 6 64 75 13 Tennessee Titans 167.004 Atlanta Falcons 175.558 Buffalo Bills 149.558 San Francisco 49ers 166.458 Houston Texans 141.31 Miami Dolphins 188.287 Minnesota Vikings 168.716 Arizona Cardinals 167.723 Washington Redskins 182.306 Cleveland Browns 186.197 Tampa Bay Buccaneer 153.307 Detroit Lions 203.201 Oakland Raider 170.166 47 22 48 43 80 75 42 LUOCO 80 27 6