Question

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 10 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 10 more games

Is there a relationship between total team salary and team performance in a sport such as professional basketbali? 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 bi of the least squares prediction line Wins-bo + b1*Payroll 21.11 .558 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.9 million in team salary, how many more games could the team expect to win? (Use 1 decimal place in your answer) 5.0 Question 3. Suppose a basketball team spent $110 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 Worse than predicted Part b. What is the residual for this basketball team? (use 2 decimal places in your answer) 5.72 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 10 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 7.307 Xincrease in team payroll (in $million) needed for basketball team to win 10 more games

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
Milwaukee Bucks	120.805	44
Brooklyn Nets	96.040	28
Toronto Raptors	116.575	59
New York Knicks	107.855	29
Golden State Warriors	137.495	58
Minnesota Timberwolves	117.469	47
Memphis Grizzlies	110.273	22
Oklahoma City Thunder	134.294	48
Washington Wizards	124.180	43
Los Angeles Clippers	118.907	42
Sacramento Kings	95.628	27

Answer 1

Solution :-

Question-4 :-

Given data :

From question-1, Slope = 0.558

Here we need to calculate the increase in payoff when we want increase 10 more wins.

Then , Increase in payoffs = Number of games win / Slope

Increase in payoffs = 10 / 0.558

   Increase in payoffs = 17.92

$\therefore$  $ 17.92 increase in team payroll ( in $million ) needed for basketball team to win 7 more games.