Excel File Edit View Insert Format Tools Data Window Help G OX L FORMon NOV 28 10:13 AM AutoSave O OFF A A P . C ... baseball_football_basketball_payrolls_wins.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments & Cut 11 2 7 V Wrap Text v General Normal Bad Good _ AutoSum A YO. Calibri (Body) AA Fill [A Copy Conditional Format Neutral Calculation Check Cell Insert Delete Format Sort & Find & Analyze Paste Format B Uv MVAv Merge & Center $ ~ % 9 00 -20 Clear v Filter Select Data Formatting as Table P25 + X V fx M N O P Q R S A B C D E F G H K 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 3 Team Payroll Wins Team Payroll Wins Teams Payroll Wins 4 Boston Red Sox 197.041 93 Cleveland Cava 137.363 50 Los Angeles Chargers 159.904 5 Cleveland Indians 124.116 102 Los Angeles Lakers 105.355 35 Baltimore Ravens 148.961 166.375 80 Boston Celtics 115.084 55 Chicago Bears 175.382 A UI O 6 Los Angeles Angels 155.202 7 New York Yankees 196.39 91 Orlando Magic 98.285 25 Indianapolis Colts 8 Arizona Diamondbacks 127.829 93 Denver Nuggets 107.889 46 New England Patriots 180.07 13 87 11 9 Colorado Rockies 127.829 Portland Trail Blazers 119.109 49 New Orleans Saints 155.884 UT 100.041 99 Houston Rockets 119.070 65 New York Jets 138.837 10 Philadelphia Phillies 11 San Diego Padres 69.624 71 San Antonio Spurs 116.154 47 Philadelphia Eagles 174.507 13 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 Broncos 161.567 14 Seattle Mariners 154.319 78 Utah Jazz 107.613 48 Kansas City Chiefs 159.212 LO 15 Chicago Cubs 172.2 92 Atlanta Hawks 100.414 24 Seattle Seahawks 180.886 122.603 72 94.818 olina Panthers 200.122 11 16 Atlanta Br Phoenix Suns 21 160.399 17 Milwaukee 63.061 86 Miami Heat 131.223 44 Cincinnati Bengals 27 Green Bay Packers 177.963 18 Toronto Blue Jays 163.382 76 Chicago Bulls 89.425 241.149 104 Philadelphia 76ers 100.794 52 Jacksonville Jaguars 181.576 10 19 Los Angeles Dodgers w 20 Minnesota Twins 108.103 85 Detroit Pistons 100.086 39 New York Giants 164.404 148.153 83 Indiana Pacers 94.430 48 Pittsburgh Steelers 161.092 13 21 St. Louis Cardinals 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 14 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 166.458 26 Cincinnati Reds 95.376 68 New York Knicks 107.855 29 San Francisco 49ers 97.8 67 137.495 58 Houston Texans 141.31 27 Chicago White Sox Golden State Warriors 28 Miami Marlins 115.406 77 Minnesota Timberwolves 117.469 47 Miami Dolphins 188.287 13 29 San Francisco Giants 180.823 64 Memphis Grizzlies 110.273 22 Minnesota Vikings 168.716 75 134.294 Arizona Cardinals 30 Baltimore Orioles 164.326 Oklahoma City Thunder 48 167.723 182.306 31 Kansas City Royals 143.006 80 Washington Wizards 124.180 43 Washington Redskins 32 Pittsburgh Pirates 95.807 75 Los Angeles Clippers 118.907 42 Cleveland Browns 186.197 33 Tampa Bay Rays 70.065 80 Sacramento Kings 95.628 27 Tampa Bay Buccaneers 153.307 34 Detroit Lions 203.201 170.166 35 Oakland Raider ar Sheet1 Sheet2 Sheet3 + + 149% Ready &? Accessibility: Unavailable C 11,078 28 as tvSporlsE X DIMETllI X ST 350l X i Coursel X C Cheggt X ' Course X _= Module X ' ACC Pla X e whatar' X C Cheggt X m 2023 S! X NCAAB X 2022-2 X F) New Tab X + e C u webassignnetlb'icbi'Studclit/AsslgrimentrRospClilsesilasi'Zdcp:30558705#questlon12i5587 to x': I El \" (Update Woliware . Fantasy Labs ' PRT 375 section 2.\" l5 VilalSource ST 350 I Login All Sports DlMETIME 8. [0.48/1 Points] PREVIOUS ANSWERS Is there a relationship between total team sa _ry all the teams In the National Basketball Association (NBA). The data are In this Excel ill am 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 Question 1. Let the x-varlable be the team payroll and let the y-yariable be the team Wins. Find the intercept bu and slope b1 or the least squares prediction line ll'in = b0 + b1*Payroll. 21,12 Intercept (use 2 decimal places In your answer) 0 558 slope (use 3 decimal places in your answer) Question 2. If an NBA team spent an additional $12 million in team salary, how many more games could the team expect to win7 (Use 1 decimal place in your answer). :l Question 3. Suppose a basketball team spent $111 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 9 more games. How much should the basketball team increase its payroll it 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. 35 increase in team payroll (in $ml|llnn) needed for basketball team to win 9 more games SubIVIlt