Professional basketball has truly become a sport that generates interest among fans around the world. More and more players come from outside the United States to play in the National Basketball Association (NBA). You want to develop a regression model to predict the number of wins achieved by each NBA team, based on field goal (shots made) percentage and three-point field goal percentage. The data are stored in NBA.xlsx .

12) Suppose, the Chicago bulls has 45% field goal and 35% of three-point field goal, what are the predicted wins from the regression models in 1), 11) and 12)?

13) Compare R square and adjusted R square for the three regression models 1),11), and 12). Explain which model is the best in terms of the goodness-to-fit.

14) Using the NBA data, develop the best model to predict the number of wins using the variables given. You can add/remove any variables or even combine variables if necessary. There two criteria to evaluate the model.

First, the highest adjusted r square among any alternative models.

Second, all included independent variables are significant at least at 10 % and have meaningful signs and magnitude.

B C D E F G H K Team Code Wins Field Goal % Field Goal % Game Per Game Per Game Rebounds Turnovers W N H Atlanta Hawks ATL 60 46.6 38.0 102.5 97.1 5.4 40.8 14.2 EASTERN Boston Celtics BOS 40 44.3 32.7 101.4 101.2 0.2 43.8 13.8 EASTERN Brooklyn Nets BKN 38 45.1 33.1 98.0 100.9 -2.9 42.4 13.8 EASTERN 5 Charlotte Hornets CHA 33 42.0 31.8 94.2 97.1 -2.9 44.1 11.8 EASTERN 6 Chicago Bulls CHI 50 44.2 35.3 100.8 97.8 3.0 45.7 14.0 EASTERN Cleveland Cavaliers CLE 53 45.8 36.7 103.1 98.7 4.4 43.0 14.3 EASTERN 8 Dallas Mavericks DAL 50 46.3 39.2 105.2 102.3 2.9 42.3 13.0 WESTERN 9 Denver Nuggets DEN 30 43.3 32.5 101.5 105.0 -3.5 44.7 14.2 WESTERN Detroit Pistons DET 32 43.2 34.4 98.5 99.5 -1.0 44.9 13.4 EASTERN Golden State Warriors GSW 67 47.8 39.8 110.0 99.9 10.1 44.7 14.5 WESTERN 12 Houston Rockets HOU 56 44.4 34.8 103.9 100.5 3.4 43.7 16.7 WESTERN 13 Indiana Pacers IND 38 43.9 35.2 97.3 97.0 0.3 44.9 14.0 EASTERN Los Angeles Clippers LAC 56 47.3 37.6 106.7 100.1 6.6 42.6 12.9 WESTERN 15 Los Angeles Lakers LAL 21 43.5 34.4 98.5 105.3 -6.8 43.9 13.2 WESTERN 16 Memphis Grizzlies MEM 55 45.8 33.9 98.3 95.1 3.2 42.6 13.3 WESTERN Miami Heat MIA 37 45.6 33.5 94.7 97.3 -2.6 39.1 14.8 EASTERN 18 Milwaukee Bucks MIL 41 45.9 36.3 97.8 97.4 0.4 42.1 16.7 EASTERN 19 Minnesota Timberwolves MIN 16 43.8 33.2 97.8 106.5 -8.7 10.9 15.0 WESTERN 20 New Orleans Pelicans NOH 45 45.7 37.0 99.4 98.6 0.8 43.5 13.3 WESTERN New York Knicks NYK 17 42.8 34.7 91.9 101.2 -9.3 40.4 14.7 EASTERN 22 Oklahoma City Thunder OKC 45 44.7 33.9 104.0 101.8 2.2 47.5 14.7 WESTERN Orlando Magic ORL 25 45.3 34.7 95.7 101.4 -5.7 41.8 14.9 EASTERN 24 Philadelphia 76ers PHI 18 40.8 32.0 92.0 101.0 -9.0 42.9 17.7 EASTERN 25 Phoenix Suns PHX 39 45.2 34.1 102.4 103.3 -0.9 43.2 15.1 WESTERN Portland Trail Blazers POR 51 45.0 36.2 102.8 98.6 4.2 45.9 13.6 WESTERN Sacramento Kings SAC 29 45.5 34.1 101.3 105.0 -3.7 44.2 16.3 WESTERN 28 San Antonio Spurs SAS 55 46.8 36.7 103.2 97.0 6.2 43.6 14.0 WESTERN 29 Toronto Raptors TOR 49 45.5 35.2 104.0 100.9 3.1 41.5 12.9 EASTERN 30 Utah Jazz UTA 38 44.7 34.3 95.1 94.9 0.2 44.0 15.3 WESTERN Washington Wizards WAS 46 46.2 36.0 98.5 97.8 0.7 44.7 15.0 EASTERN 32