Excel e Edit View Insert Format Tools Data Window Help Q Mon Nov 22 5:50 PM AutoSave OFF - 0... baseball_football_basketball_payrolls_wins.xIs - Compatibility Mode Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 AA = =1 ab Wrap Text v General Insert v Ex A- O. Ex Delete v V Z Paste BIUV DVAv EE Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data K3 4 X V fx Teams B D E F G H I J K M N 0 P Q R S T U V W X 1 All payrolls are in millions of dollars 2 Recent BASEBALL Team Payrolls and Wins Recent BASKETBALL Team Payrolls and Wins Recent FOOTBALL Team Payrolls and Wins Team Payroll Wins Team Payroll Wins Teams Payroll Wins 4 Boston Red Sox 197.041 93 Cleveland Cavaliers 137.363 50 Los Angeles Chargers 159.904 5 Cleveland Indians 124.116 102 Los Angeles Lakers 105.355 35 Baltimore Ravens 148.961 6 Los Angeles Angels 166.375 80 Boston Celtics 115.084 55 Chicago Bears 175.382 7 New York Yankees 196.39 91 Orlando Magic 98.285 25 Indianapolis Colts 155.202 Arizona Diamondbacks 127.829 93 Denver Nuggets 107.889 46 New England Patriots 180.07 9 Colorado Rockies 127.829 87 Portland Trail 119.109 49 rleans Saints 155.884 10 Philadelphia Phillies 100.041 99 Houston Rockets 119.070 65 New York Jets 138.837 11 San Diego Padres 69.624 71 San Antonio Spurs 116.154 47 Philadelphia Eagles 174.507 w 12 Detroit Tigers 199.751 64 Dallas Mavericks 85.904 24 Dallas Cowboy 145.203 13 New York Mets 154.437 70 New Orleans Pelicans 119.800 48 Denver Bronco: 61.567 14 Seattle Mariners 154.319 78 Utah Jazz 107.613 48 Kansas City Chiefs 159.212 15 Chicago Cubs 172.2 92 Atlanta Hawks 100.414 24 Seattle Seahawks 180.886 16 Atlanta Braves 122.603 72 Phoenix Suns 94.818 21 Carolina Panthers 200.122 17 Milwaukee Brewers 63.061 86 Miami Heat 131.223 44 Cincinnati Bengals 160.399 18 Toronto Blue Jays 163.382 76 Chicago Bulls 89.425 27 Green Bay Packers 177.963 19 Los Angeles Dodgers 241.149 104 Philadelphia 76ers 100.794 52 Jacksonville Jaguars 181.576 10 20 Minnesota Twins 108.103 85 Detroit Pistons 100.086 39 New York Giants 164.404 21 St. Louis Cardinals 148.153 83 Indiana Pacers 94.430 48 Pittsburgh Steelers 161.092 22 Oakland Athletics 81.738 75 Charlotte Hornets 117.228 36 Los Angeles Rams 155.806 23 Texas Rangers 165.348 78 Milwaukee Bucks 120.805 44 Tennessee Titans 167.004 24 Houston Astros 124.344 101 Brooklyn Nets 96.040 28 Atlanta Falcons 175.558 25 Washington Nationals 164.335 97 Toronto Raptors 116.575 59 Buffalo Bills 149.558 26 Cincinnati Reds 95.376 68 New York Knicks 107.855 29 San Francisco 49ers 166.458 27 Chicago White Sox 97.8 67 Golden State Warriors 137.495 58 Houston Texan 141.31 28 Miami Marlins 115.406 77 Minnesota Timberwolves 117.469 47 Miami Dolphins 188.287 29 San Francisco Giants 180.823 64 Memphis Grizzlies 110.273 22 Minnesota Vikings 168.716 30 Baltimore Orioles 164.326 75 Oklahoma City Thunder 134.294 48 Arizona Cardinals 167.723 31 Kansas City Royals 143.006 80 Washington Wizards 124.180 43 Washington Redskins 182.306 32 Pittsburgh Pirates 95.807 75 Los Angeles Clippers 118.907 42 Cleveland Browns 186.197 D UT O V DO 33 Tampa Bay Rays 70.065 80 Sacramento Kings 95.628 27 Tampa Bay Buccaneers 153.307 34 Detroit Lions 203.201 35 Oakland Raider 170.166 36 37 38 20 Sheet1 Sheet2 Sheet3 + + 100% Ready - 5 NOV 22' chrome File Edit View History Bookmarks Profiles Tab Window Help m Course: ACC 2201 X I G thisexcelle D1B X l u Course Hero X E 2021 NFL Playof X l u Course Hero x l u ST 311-301 Home\\ x VA ST 350 Homewor x i webassmnnet/web/Student/ASSIgnmentResponses/su bmit?de 8092094&tags=autosave#Q9 Is there a relationship between total team salary and team performance in a sport such as professionaLbas 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 Major League Baseball (MLB). The data are in thi Question 1. Let the x-variable be the team payroll and let the y-variable be the team wins. Find the intercept b0 and slope b1 of the least squares prediction line W'Ens = b0 + b1*PayroII. 11.91 x intercept (use 2 decimal places in your answer) .132 x slope (use 4 decimal places in your answer) Question 2. If an MLB team spent an additional $29 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 baseball team spent $140 million on salaries and won 75 games. Part a. Based on their payroll would they have done better or worse than predicted? (only 1 submission allowed). 0 Better than predicted O Worse than predicted Part b. What is the residual for this baseball team? (use 2 decimal places in your answer) Question 4. All teams have a goal to make the postseason playoffs. A baseball team thinks that it can make the playoffs next year if it wins 7 more games. How much should the baseball 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 baseball team to win 7 more games Submit