Need Help with this question
iiiV gz' y ! A Is there a relationship between total team salary and team performance in a sport such as professional football? 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 Football League (NFL). The data are in this Excel le. 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 Wins = be + b1*Payroll. 11.96 X intercept (use 3 decimal places in your answer) slope (use 4 decimal places in your answer) Question 2. If an NFL team spent an additional $52 million in team salary, how many more games could the team expect to win? (Use 1 decimal place in your answer). 4.27 X Question 3. Suppose a football team spent $50 million on salaries and won 7 games. Part a. Based on their payroll would they have done better or worse than predicted? (only 1 submission allowed). 0 Worse than predicted 0 Better than predicted Part b. What is the residual for this football team? (use 2 decimal places in your answer) l:l Question 4. All teams have a goal to make the postseason playoffs. A football team thinks that it can make the playoffs next year if it wins 2 more games. How much should the football 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 $mi|lion) needed for football team to win 2 more games 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 Tennessee Titans 167.004 9 Atlanta Falcons 175.558 10 Buffalo Bills 149.558 9 San Francisco 49ers 166.458 6 Houston Texans 141.31 4 Miami Dolphins 188.287 6 Minnesota Vikings 168.716 13 Arizona Cardinals 167.723 8 Washington Redskins 182.306 7 Cleveland Browns 186.197 0 Tampa Bay Buccaneers 153.307 5 Detroit Lions 203.201 9 Oakland Raider 170.166 6
