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 .TEAMWinsField Goal %Three-Point Field Goal %Points Per GameReboundFreedrawTurnoverHouston Rockets654636.2112.443.519.613.8Toronto Raptors5947.235.8111.74417.313.4Golden State Warriors5850.339.1113.543.516.615.4Boston Celtics554537.710444.51614Philadelphia 76ers5247.236.9109.847.417.116.5Cleveland Cavaliers5047.637.2110.942.118.113.7Portland Trail Blazers4945.236.6105.645.516.713.5Indiana Pacers4847.236.9105.642.314.913.3New Orleans Pelicans4848.336.2111.744.316.114.9Oklahoma City Thunder4845.335.4107.945.117.314Utah Jazz4846.236.6104.143.316.814.7Minnesota Timberwolves4747.635.7109.54219.412.5San Antonio Spurs4745.735.2102.744.216.113.1Denver Nuggets464737.111044.517.115Miami Heat4445.536103.443.514.714.4Milwaukee Bucks4447.835.5106.539.818.313.8Washington Wizards4346.737.5106.643.116.814.6LA Clippers4247.135.410943.91914.7Detroit Pistons394537.3103.843.714.713.4Charlotte Hornets364536.9108.245.520.212.7Los Angeles Lakers3546.134.5108.146.416.615.8New York Knicks2946.435.2104.54414.914.7Brooklyn Nets2844.135.6106.644.417.415.2Chicago Bulls2743.535.5102.944.714.614Sacramento Kings274537.598.840.912.313.7Orlando Magic2545.235.1103.441.615.514.5Atlanta Hawks2444.636103.441.915.815.5Dallas Mavericks2444.436102.341.314.212.3Memphis Grizzlies2244.435.299.340.516.615Phoenix Suns2144.233.4103.944.117.715.71)  Estimate the following multiple regression model (copy and paste the results from either Minitab or Excel).2) Interpret the meanings of the coefficients of the regression model.   3) Predict the mean number of wins for a team that has a field goal percentage of 45% and a three-point field goal percentage of 35%.1)  Estimate the following multiple regression model (copy and paste the results from either Minitab or Excel).2) Interpret the meanings of the coefficients of the regression model.   3) Predict the mean number of wins for a team that has a field goal percentage of 45% and a three-point field goal percentage of 35%.

Question
Asked Nov 16, 2019
1 views

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 .

TEAM Wins Field Goal % Three-Point Field Goal % Points Per Game Rebound Freedraw Turnover
Houston Rockets 65 46 36.2 112.4 43.5 19.6 13.8
Toronto Raptors 59 47.2 35.8 111.7 44 17.3 13.4
Golden State Warriors 58 50.3 39.1 113.5 43.5 16.6 15.4
Boston Celtics 55 45 37.7 104 44.5 16 14
Philadelphia 76ers 52 47.2 36.9 109.8 47.4 17.1 16.5
Cleveland Cavaliers 50 47.6 37.2 110.9 42.1 18.1 13.7
Portland Trail Blazers 49 45.2 36.6 105.6 45.5 16.7 13.5
Indiana Pacers 48 47.2 36.9 105.6 42.3 14.9 13.3
New Orleans Pelicans 48 48.3 36.2 111.7 44.3 16.1 14.9
Oklahoma City Thunder 48 45.3 35.4 107.9 45.1 17.3 14
Utah Jazz 48 46.2 36.6 104.1 43.3 16.8 14.7
Minnesota Timberwolves 47 47.6 35.7 109.5 42 19.4 12.5
San Antonio Spurs 47 45.7 35.2 102.7 44.2 16.1 13.1
Denver Nuggets 46 47 37.1 110 44.5 17.1 15
Miami Heat 44 45.5 36 103.4 43.5 14.7 14.4
Milwaukee Bucks 44 47.8 35.5 106.5 39.8 18.3 13.8
Washington Wizards 43 46.7 37.5 106.6 43.1 16.8 14.6
LA Clippers 42 47.1 35.4 109 43.9 19 14.7
Detroit Pistons 39 45 37.3 103.8 43.7 14.7 13.4
Charlotte Hornets 36 45 36.9 108.2 45.5 20.2 12.7
Los Angeles Lakers 35 46.1 34.5 108.1 46.4 16.6 15.8
New York Knicks 29 46.4 35.2 104.5 44 14.9 14.7
Brooklyn Nets 28 44.1 35.6 106.6 44.4 17.4 15.2
Chicago Bulls 27 43.5 35.5 102.9 44.7 14.6 14
Sacramento Kings 27 45 37.5 98.8 40.9 12.3 13.7
Orlando Magic 25 45.2 35.1 103.4 41.6 15.5 14.5
Atlanta Hawks 24 44.6 36 103.4 41.9 15.8 15.5
Dallas Mavericks 24 44.4 36 102.3 41.3 14.2 12.3
Memphis Grizzlies 22 44.4 35.2 99.3 40.5 16.6 15
Phoenix Suns 21 44.2 33.4 103.9 44.1 17.7 15.7

1)  Estimate the following multiple regression model (copy and paste the results from either Minitab or Excel).

2) Interpret the meanings of the coefficients of the regression model.   

3) Predict the mean number of wins for a team that has a field goal percentage of 45% and a three-point field goal percentage of 35%.

1)  Estimate the following multiple regression model (copy and paste the results from either Minitab or Excel).

2) Interpret the meanings of the coefficients of the regression model.   

3) Predict the mean number of wins for a team that has a field goal percentage of 45% and a three-point field goal percentage of 35%.

check_circle

Expert Answer

Step 1

a)

The multiple regression model is obtained as follows:

Step-by-step procedure to find multiple regression equation using MINITAB software:

Step 2
  • Choose Stat > Regression > Regression.
  • In Response, enter the column of Wins.
  • In Predictors, enter the columns of Field Goal% and Three-Point Field Goal%.
  • Click OK.

Output using MINITAB software is shown below:

Regression Analysis: Wins versus Field Geal %.-Point Field Goal %
nalysis of Variance
Source
Regression
ield Goal
Three-Point Field Goal
-Value P-alue
Ads a
DP
Adj M
12.47
2000.11
1040.05
1050.14
1050.14
12.59
9.001
239.34
239,34
2.87
.102
1.
27
2251.09
03.4
Lack-of-rit
26
2243.89
86.3
10.79
0.237
Pure Error
1
4332
Total
29
Model umary
R-sq(adj) R-q(pred)
44.17
R-sg
13254 48.02
35.30
coetticients
Coef
SE Coef
-value
-4.18
-Value
Term
Constans
Field Goal
Three-Point Field Goal
263.5
63.1
0
3.55
0.001
4.41
1.24
1-22
A.66
2.01
1.69
0.102
-22
egression Equation
Wins
Fits and Diagnostics for eusual cbservations
-263.54.4 Field Goal 1+2.01 Three-Point Field Goal
ins
rit
Resid std Besid
Oba
1
65
40.96
24.04
2.68 R
60.06
3
10.06
-1.41
help_outline

Image Transcriptionclose

Regression Analysis: Wins versus Field Geal %.-Point Field Goal % nalysis of Variance Source Regression ield Goal Three-Point Field Goal -Value P-alue Ads a DP Adj M 12.47 2000.11 1040.05 1050.14 1050.14 12.59 9.001 239.34 239,34 2.87 .102 1. 27 2251.09 03.4 Lack-of-rit 26 2243.89 86.3 10.79 0.237 Pure Error 1 4332 Total 29 Model umary R-sq(adj) R-q(pred) 44.17 R-sg 13254 48.02 35.30 coetticients Coef SE Coef -value -4.18 -Value Term Constans Field Goal Three-Point Field Goal 263.5 63.1 0 3.55 0.001 4.41 1.24 1-22 A.66 2.01 1.69 0.102 -22 egression Equation Wins Fits and Diagnostics for eusual cbservations -263.54.4 Field Goal 1+2.01 Three-Point Field Goal ins rit Resid std Besid Oba 1 65 40.96 24.04 2.68 R 60.06 3 10.06 -1.41

fullscreen
Step 3

From the MINITAB output, the multiple r...

Wins -263.54.41(Field Goal%)+2.81(Three-point Field Goal%
_
help_outline

Image Transcriptionclose

Wins -263.54.41(Field Goal%)+2.81(Three-point Field Goal% _

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Math

Statistics

Advanced Topics in Statistics

Related Statistics Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: Suppose the age that children learn to walk is normally distributed with mean 12 months and standard...

A: NoteHello there! For 2nd part we need part d to answer this question. Upload the complete question s...

question_answer

Q: Part D

A: The provided information is:

question_answer

Q: 9.22 Parts B, C, and D.

A: Solution:It is given that the garlic is more effective with 37 subjects and placebo is more effectiv...

question_answer

Q: Sg-Group Assignment #11 - How Fast? Instructions: In 1974, Loftus and Palmer conducted a classic stu...

A: Hello. Since your question has multiple sub-parts, we will solve first three sub-parts for you. If y...

question_answer

Q: A fraternity at a university lobbies Start a hockey team 9.76 the administration to start a hockey t...

A: The provided information are:

question_answer

Q: You want to obtain a sample to estimate a population proportion. Based on previous evidence, you bel...

A: Step-by-step procedure to obtain the value of z using MINITAB:Choose Graph > Probability Distribu...

question_answer

Q: in a sample random sample of size 80, there were 54 individuals in the category of interest. a, comp...

A: Given Datan = 80, x= 54,a) sample proportion is given by

question_answer

Q: what do researchers do to create a design requiring a two-way chi square?

A: The two-way chi square is also known as chi-square test for independence. It is a procedure for test...

question_answer

Q: Most graduate schools of business require applicants for admission to take the Graduate Management A...

A: Given dataMean (µ)= 527Standard Deviation (σ) = 112n = 49