Question 2:

Using the data that is provided (Thunder Dataset below)

answer the following:

(a) Define what each variable is in the able below: Qualitative/Quantitative

The data consist of 7 variables on the 133 games for the Thunder for the 2017-19 seasons

Variable	Qual or Quant
+/-
Year
Game
Home vs Away
Points
AST
TOV
STL

(b) Create a frequency distribution for the variable Points using the classes 80 -89, 90-99, 100-109, 110-119, 120-129, 130-139 and 140-149. Using your frequency distribution create a histogram. What do you notice about the shape of the histogram? Use your values for mean and median from (C) to aid in your explanation. Make sure to put both the table and figure here.

(c) Find the min, max, average, median, mode, variance and standard deviation for the variables +/-, PTS, AST. Interpret what the value for standard deviation tells you. Place the chart of your results here.

Variable	Min	Max	Mean	Median	Variance	SD
+/-
Points
AST

Only use 1 decimal place

(d) In excel or using R, find the correlations between +/-, PTS, AST, TOV. What does this tell you about how each of the variables are related? Explain. Put the correlation matrix here.

Variable	+/-	Points	AST	TOV
+/-
Pts
AST
TOV

*use 3 decimal places

(e)Would it be appropriate to also include Home/Away in correlation? Explain

(f) Use the data provided to create 4 regression models to predict how PTS and AST are related to +/- .

In model 1 and 2 you consider Points and AST alone; Model 3 consider AST and Points together; Model 4 consider Points and Assists and their squared terms along with an interaction (Pts*Ast). Put your results in the table below.

*to create model 4, you need to create new columns for Points-Sq. and AST-Sq. and also create a column where you multiply points*AST if you are using excel. You can then use those in the regression. In R you simply need to change the model statement appropriately.

Model	Variable	Coefficient	T-Stat	P-Value	Adj-R2
1	Intercept Points
2	Intercept AST
3	Intercept Points AST
4	Intercept Points Points-Sq AST AST-Sq Points*Assists

*for Coeff, T-stat use 2 decimal places, p-value 4 decimals, Adj-R2 3 decimals

**note that the variables noted in the 2^nd column are the variables that are to be used in each model. So the number of coefficients, t-test and p-values should reflect that. For example, in model 1 there should be 2 coefficients, t-stats and p-values for the 2 corresponding variables.

g) Which model does the best job of predicting +/-. Explain. Which variables are influential in predicting +/-?

Year Home (1) 0 0 0 0 0 0 0 0 PTS AST TOV STL +/- 1 113 18 4 -3 1 95 16 13 5 -2 1 124 25 12 9 17 1 112 21 15 9 5 0 103 18 8 9 14 1 120 24 19 11 3 1 107 23 14 15 28 1 95 13 10 9 1 0 96 18 14 9-15 0 119 28 18 10 2 0 100 26 14 10 1 103 16 14 4 -13 0102 18 10 7 1 0 95 18 12 6 -5 Game Dec 31, 2017 - OKC vs. DAL Dec 29, 2017 - OKC vs. MIL Dec 27, 2017 - OKC vs. TOR Dec 25, 2017 - OKC vs. HOU Dec 23, 2017 - OKC @UTA Dec 22, 2017 - OKC vs. ATL Dec 20, 2017 - OKC vs. UTA Dec 18, 2017 - OKC vs. DEN Dec 16, 2017 - OKC @NYK Dec 15, 2017 - OKC @ PHI Dec 13, 2017 - OKC @ IND Dec 11, 2017 - OKC vs. CHA Dec 09, 2017 - OKC @ MEM Dec 07, 2017 - OKC @ BKN Dec 05, 2017 - OKC vs. UTA Dec 03, 2017 - OKC vs. SAS Dec 01, 2017 - OKC vs. MIN Nov 29, 2017 - OKC @ ORL Nov 25, 2017 - OKC @ DAL Nov 24, 2017 - OKC vs. DET 0 0 0 0 0 0 0 1 100 18 19 11 0 1 90 21 20 8 0 28 19 1 111 0 108 7 4 8 -13 0 17 13 0 0 81 24 17 12 -16 15 13 0 1 98 22 0 0 107 22 14 14 -7 0 24 9 7 -3 0 101 1 92 0 15 14 0 21 1 112 1 120 0 94 17 10 13 11 8 9 0 23 do oo w w 0 16 0 0 86 15 18 15 17 16 11 11 0 0 99 17 -4 0 1 94 20 12 - 7 0 0 110 24 16 6 19 Nov 20, 2017 - OKC @ NOP Nov 17, 2017 - OKC @ SAS Nov 15, 2017 - OKC vs. CHI Nov 12, 2017 - OKC vs. DAL Nov 10, 2017 - OKC vs. LAC Nov 09, 2017 - OKC @ DEN Nov 07, 2017 - OKC @ SAC Nov 05, 2017 - OKC @ POR Nov 03, 2017 - OKC vs. BOS Oct 31, 2017 - OKC @ MIL Oct 28, 2017 - OKC @ CHI Oct 27, 2017 - OKC @ MIN Oct 25, 2017 - OKC vs. IND Oct 22, 2017 - OKC vs. MIN Oct 21, 2017 - OKC @UTA Oct 19, 2017 - OKC vs. NYK Apr 11, 2018 - OKC vs. MEM Apr 09, 2018 - OKC @MIA Apr 07, 2018 - OKC @ HOU Apr 03, 2018 - OKC vs. GSW Apr 01, 2018 - OKC @ NOP 0 28 12 16 32 14 8 -3 0 19 0 26 0 26 0 87 15 0 0 101 0 116 1 114 1 113 0 1 105 1 137 0 115 0 108 1 107 0109 26 0 32 20 8 18 11 9 -2 17 14 -9 20 14 21 14 8 14 10 9 22 12 11 6 16 8 -4 18 13 5 0 21 0 21 13 O O 24 0 1 125 25 13 -1 0 0 99 19 11 -4 0 1 105 9 -3 16 17 0 1 105 7 6 0 19 6 -1 0 99 0 132 0 27 18 11 7 0 1 121 30 14 17 8 0 27 9 12 0 119 0 133 0 36 9 12 37 4 10 0 0 127 23 14 Mar 30, 2018 - OKC vs. DEN Mar 29, 2018 - OKC @ SAS Mar 25, 2018 - OKC vs. POR Mar 23, 2018 - OKC vs. MIA Mar 20, 2018 - OKC @ BOS Mar 18, 2018 - OKC @TOR Mar 16, 2018 - OKC vs. LAC Mar 13, 2018 - OKC @ ATL Jan 03, 2018 - OKC @ LAL Jan 04, 2018 - OKC @ LAC Jan 07, 2018 - OKC @ PHX Jan 09, 2018 - OKC vs. POR Jan 10, 2018 - OKC @ MIN Jan 13, 2018 - OKC @ CHA Jan 15, 2018 - OKC vs. SAC Jan 17, 2018 - OKC vs. LAL Jan 20, 2018 - OKC @ CLE Jan 23, 2018 - OKC vs. BKN Jan 25, 2018 - OKC vs. WAS Jan 27, 2018 - OKC @ DET Jan 28, 2018 - OKC vs. PHI 0 0 100 23 12 0 1 106 20 14 7-14 6 -11 9 -16 8 10 0 0 88 13 19 0 17 9 0 101 1 95 0 20 20 10 7 17 10 24 0 1 114 22 0 0 148 37 14 9 24 0 1 109 12 1 4 7 14 16 0 1 121 18 9 0 0 121 23 10 9 13 0 1 122 21 11 7 10 0 19 21 7 -6 0 34 0 24 0 17 0 96 0 124 1 100 1 104 0 125 0 81 1 110 1 112 0 17 0 16 14 0 21 7 5 -3 16 6 -14 18 13 -4 13 14 20 6 -25 6 18 11 6 -8 9 7 7 11 6 3 16 8 -32 20 6 7 10 0 23 0 0 121 0 110 26 26 Jan 30, 2018 - OKC @ WAS Feb 01, 2018 - OKC @ DEN Feb 02, 2018 - OKC vs. NOP Feb 04, 2018 - OKC vs. LAL Feb 06, 2018 - OKC @ GSW Feb 08, 2018 - OKC @ LAL Feb 11, 2018 - OKC vs. MEM Feb 13, 2018 - OKC vs. CLE Feb 14, 2018 - OKC @ MEM Feb 22, 2018 - OKC @SAC Feb 24, 2018 - OKC @ GSW Feb 26, 2018 - OKC vs. ORL Feb 28, 2018 - OKC @ DAL Mar 02, 2018 - OKC @ PHX Mar 03, 2018 - OKC @ POR Mar 06, 2018 - OKC vs. HOU Mar 08, 2018 - OKC vs. PHX Mar 10, 2018 - OKC vs. SAS Mar 12, 2018 - OKC vs. SAC 4/10/2019 4/9/2019 0 0 0 80 19 0 1 112 24 0 0 111 19 22 7 1 0 22 11 0 124 0 100 1 112 5 8 6 - 8 0 18 12 18 20 12 -10 0 0 1 115 21 18 6 28 0 1 104 24 15 8 10 0 1 106 21 11 5 5 1 0 127 40 13 7 11 1 1 112 20 12 5 1 1 0 132 27 14 6 6 1 1 123 30 17 10 13 1 33 12 15 16 1 19 8 6 -3 1 19 13 1 119 1 103 1 105 1 107 0 103 0 116 1 114 5 -10 7 8 1 29 7 1 17 10 8 -12 1 13 9 7 1 30 22 21 17 6 -9 1 1 107 19 4 -9 4/7/2019 4/5/2019 4/2/2019 3/31/2019 3/29/2019 3/27/2019 3/25/2019 3/22/2019 3/20/2019 3/18/2019 3/16/2019 3/14/2019 3/13/2019 3/11/2019 3/8/2019 3/7/2019 3/5/2019 3/3/2019 3/2/2019 2/28/2019 2/26/2019 1 18 16 4 -22 1 24 18 11 -2 1 21 12 9 12 1 18 16 8 9 1 20 11 3 -8 1 88 0 106 1 108 0 98 0 110 0 129 0 120 1 99 0 102 1 104 1 14 16 7 8 1 20 12 4 -11 1 19 14 10 4 1 17 13 7-14 1 28 12 5 -4 1 0 112 31 17 10 -9 1 18 11 9 1 1 0 111 0 107 1 122 22 11 8 7 1 22 10 13 20 1/4/2019 1/2/2019 12/31/2018 12/30/2018 12/28/2018 12/25/2018 1 0 103 17 11 15 -2 1 22 0 118 0 109 17 12 16 15 12 -4 1 23 Year Home (1) 0 0 0 0 0 0 0 0 PTS AST TOV STL +/- 1 113 18 4 -3 1 95 16 13 5 -2 1 124 25 12 9 17 1 112 21 15 9 5 0 103 18 8 9 14 1 120 24 19 11 3 1 107 23 14 15 28 1 95 13 10 9 1 0 96 18 14 9-15 0 119 28 18 10 2 0 100 26 14 10 1 103 16 14 4 -13 0102 18 10 7 1 0 95 18 12 6 -5 Game Dec 31, 2017 - OKC vs. DAL Dec 29, 2017 - OKC vs. MIL Dec 27, 2017 - OKC vs. TOR Dec 25, 2017 - OKC vs. HOU Dec 23, 2017 - OKC @UTA Dec 22, 2017 - OKC vs. ATL Dec 20, 2017 - OKC vs. UTA Dec 18, 2017 - OKC vs. DEN Dec 16, 2017 - OKC @NYK Dec 15, 2017 - OKC @ PHI Dec 13, 2017 - OKC @ IND Dec 11, 2017 - OKC vs. CHA Dec 09, 2017 - OKC @ MEM Dec 07, 2017 - OKC @ BKN Dec 05, 2017 - OKC vs. UTA Dec 03, 2017 - OKC vs. SAS Dec 01, 2017 - OKC vs. MIN Nov 29, 2017 - OKC @ ORL Nov 25, 2017 - OKC @ DAL Nov 24, 2017 - OKC vs. DET 0 0 0 0 0 0 0 1 100 18 19 11 0 1 90 21 20 8 0 28 19 1 111 0 108 7 4 8 -13 0 17 13 0 0 81 24 17 12 -16 15 13 0 1 98 22 0 0 107 22 14 14 -7 0 24 9 7 -3 0 101 1 92 0 15 14 0 21 1 112 1 120 0 94 17 10 13 11 8 9 0 23 do oo w w 0 16 0 0 86 15 18 15 17 16 11 11 0 0 99 17 -4 0 1 94 20 12 - 7 0 0 110 24 16 6 19 Nov 20, 2017 - OKC @ NOP Nov 17, 2017 - OKC @ SAS Nov 15, 2017 - OKC vs. CHI Nov 12, 2017 - OKC vs. DAL Nov 10, 2017 - OKC vs. LAC Nov 09, 2017 - OKC @ DEN Nov 07, 2017 - OKC @ SAC Nov 05, 2017 - OKC @ POR Nov 03, 2017 - OKC vs. BOS Oct 31, 2017 - OKC @ MIL Oct 28, 2017 - OKC @ CHI Oct 27, 2017 - OKC @ MIN Oct 25, 2017 - OKC vs. IND Oct 22, 2017 - OKC vs. MIN Oct 21, 2017 - OKC @UTA Oct 19, 2017 - OKC vs. NYK Apr 11, 2018 - OKC vs. MEM Apr 09, 2018 - OKC @MIA Apr 07, 2018 - OKC @ HOU Apr 03, 2018 - OKC vs. GSW Apr 01, 2018 - OKC @ NOP 0 28 12 16 32 14 8 -3 0 19 0 26 0 26 0 87 15 0 0 101 0 116 1 114 1 113 0 1 105 1 137 0 115 0 108 1 107 0109 26 0 32 20 8 18 11 9 -2 17 14 -9 20 14 21 14 8 14 10 9 22 12 11 6 16 8 -4 18 13 5 0 21 0 21 13 O O 24 0 1 125 25 13 -1 0 0 99 19 11 -4 0 1 105 9 -3 16 17 0 1 105 7 6 0 19 6 -1 0 99 0 132 0 27 18 11 7 0 1 121 30 14 17 8 0 27 9 12 0 119 0 133 0 36 9 12 37 4 10 0 0 127 23 14 Mar 30, 2018 - OKC vs. DEN Mar 29, 2018 - OKC @ SAS Mar 25, 2018 - OKC vs. POR Mar 23, 2018 - OKC vs. MIA Mar 20, 2018 - OKC @ BOS Mar 18, 2018 - OKC @TOR Mar 16, 2018 - OKC vs. LAC Mar 13, 2018 - OKC @ ATL Jan 03, 2018 - OKC @ LAL Jan 04, 2018 - OKC @ LAC Jan 07, 2018 - OKC @ PHX Jan 09, 2018 - OKC vs. POR Jan 10, 2018 - OKC @ MIN Jan 13, 2018 - OKC @ CHA Jan 15, 2018 - OKC vs. SAC Jan 17, 2018 - OKC vs. LAL Jan 20, 2018 - OKC @ CLE Jan 23, 2018 - OKC vs. BKN Jan 25, 2018 - OKC vs. WAS Jan 27, 2018 - OKC @ DET Jan 28, 2018 - OKC vs. PHI 0 0 100 23 12 0 1 106 20 14 7-14 6 -11 9 -16 8 10 0 0 88 13 19 0 17 9 0 101 1 95 0 20 20 10 7 17 10 24 0 1 114 22 0 0 148 37 14 9 24 0 1 109 12 1 4 7 14 16 0 1 121 18 9 0 0 121 23 10 9 13 0 1 122 21 11 7 10 0 19 21 7 -6 0 34 0 24 0 17 0 96 0 124 1 100 1 104 0 125 0 81 1 110 1 112 0 17 0 16 14 0 21 7 5 -3 16 6 -14 18 13 -4 13 14 20 6 -25 6 18 11 6 -8 9 7 7 11 6 3 16 8 -32 20 6 7 10 0 23 0 0 121 0 110 26 26 Jan 30, 2018 - OKC @ WAS Feb 01, 2018 - OKC @ DEN Feb 02, 2018 - OKC vs. NOP Feb 04, 2018 - OKC vs. LAL Feb 06, 2018 - OKC @ GSW Feb 08, 2018 - OKC @ LAL Feb 11, 2018 - OKC vs. MEM Feb 13, 2018 - OKC vs. CLE Feb 14, 2018 - OKC @ MEM Feb 22, 2018 - OKC @SAC Feb 24, 2018 - OKC @ GSW Feb 26, 2018 - OKC vs. ORL Feb 28, 2018 - OKC @ DAL Mar 02, 2018 - OKC @ PHX Mar 03, 2018 - OKC @ POR Mar 06, 2018 - OKC vs. HOU Mar 08, 2018 - OKC vs. PHX Mar 10, 2018 - OKC vs. SAS Mar 12, 2018 - OKC vs. SAC 4/10/2019 4/9/2019 0 0 0 80 19 0 1 112 24 0 0 111 19 22 7 1 0 22 11 0 124 0 100 1 112 5 8 6 - 8 0 18 12 18 20 12 -10 0 0 1 115 21 18 6 28 0 1 104 24 15 8 10 0 1 106 21 11 5 5 1 0 127 40 13 7 11 1 1 112 20 12 5 1 1 0 132 27 14 6 6 1 1 123 30 17 10 13 1 33 12 15 16 1 19 8 6 -3 1 19 13 1 119 1 103 1 105 1 107 0 103 0 116 1 114 5 -10 7 8 1 29 7 1 17 10 8 -12 1 13 9 7 1 30 22 21 17 6 -9 1 1 107 19 4 -9 4/7/2019 4/5/2019 4/2/2019 3/31/2019 3/29/2019 3/27/2019 3/25/2019 3/22/2019 3/20/2019 3/18/2019 3/16/2019 3/14/2019 3/13/2019 3/11/2019 3/8/2019 3/7/2019 3/5/2019 3/3/2019 3/2/2019 2/28/2019 2/26/2019 1 18 16 4 -22 1 24 18 11 -2 1 21 12 9 12 1 18 16 8 9 1 20 11 3 -8 1 88 0 106 1 108 0 98 0 110 0 129 0 120 1 99 0 102 1 104 1 14 16 7 8 1 20 12 4 -11 1 19 14 10 4 1 17 13 7-14 1 28 12 5 -4 1 0 112 31 17 10 -9 1 18 11 9 1 1 0 111 0 107 1 122 22 11 8 7 1 22 10 13 20 1/4/2019 1/2/2019 12/31/2018 12/30/2018 12/28/2018 12/25/2018 1 0 103 17 11 15 -2 1 22 0 118 0 109 17 12 16 15 12 -4 1 23