Lakers-Cavs Interview Task

Sheet1

REGULAR SEASON																				REGULAR SEASON
	LeBron On																			LeBron Off
		Left Corner 3 (total)			Right Corner 3			Above the Break 3			20-24 ft			25-29 ft			30+ ft				Left Corner 3			Right Corner 3			Above the Break 3			20-24 ft			25-29 ft			30+ ft
Player	MPG	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	MPG	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%
Jordan Clarkson	14	10	16	62.5	3	9	33.3	17	48	35.4	22	41	53.7	14	39	35.9	0	1	0	9.1	2	4	50	1	1	100	12	37	32.4	9	22	40.9	8	26	30.8	0	1	0
Jose Calderon	16.2	2	4	50	6	10	60	29	68	42.6	17	33	51.5	24	56	42.9	0	0	undef	4.9	0	0	0	1	1	100	6	13	46.2	4	8	50	4	9	44.4	1	1	100
George Hill	26.4	9	17	52.9	10	21	47.6	9	41	22.0	25	55	45.5	5	32	15.6	0	0	undef	3.1	0	2	0	0	0	undef	0	2	0	0	4	0	0	2	0	0	0	undef
Kyle Korver	8.9	22	40	55.0	11	24	45.8	76	165	46.1	51	111	45.9	62	125	49.6	3	6	50	13.2	7	14	50	4	10	40	44	122	36.1	24	56	42.9	34	98	34.7	2	6	33.3
JR Smith	24.6	26	58	44.8	34	62	54.8	73	221	33.0	90	193	46.6	56	166	33.7	0	8	0	4.6	0	2	0	2	4	50	8	33	24.2	8	23	34.8	6	26	23.1	0	0	undef
Kevin Love	25.9	27	63	42.9	12	37	32.4	91	209	43.5	58	144	40.3	73	172	42.4	3	5	60	2.7	0	2	0	0	2	0	7	17	41.2	3	10	30	6	15	40	0	0	undef
Rodney Hood	20.4	3	7	42.9	5	9	55.6	16	46	34.8	11	26	42.3	12	37	32.4	1	2	50	6.1	1	2	50	0	0	undef	7	23	30.4	3	8	37.5	5	17	29.4	0	2	0
Jeff Green	14.6	7	24	29.2	11	32	34.4	20	54	37.0	26	80	32.5	15	41	36.6	0	0	undef	8.9	1	4	25	5	11	45.5	9	37	24.3	11	34	32.4	9	28	32.1	0	6	0
PLAYOFFS																				PLAYOFFS
	LeBron On																			LeBron Off
		Left Corner 3 (total)			Right Corner 3			Above the Break 3			20-24 ft			25-29 ft			30+ ft				Left Corner 3			Right Corner 3			Above the Break 3			20-24 ft			25-29 ft			30+ ft
Player	MPG	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	MPG	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%	Made	Attempted	%
Jordan Clarkson	5.3	0	3	0	1	6	16.7	6	17	35.3	2	15	13.3	6	14	42.9	0	0	undef	10.3	0	1	0	0	0	undef	4	19	21.1	3	8	37.5	4	17	23.5	0	0	undef
Jose Calderon	14.4	0	1	0	1	2	50	3	11	27.3	1	4	25	3	10	30	0	0	undef	3.2	0	1	0	0	0	undef	0	3	0	0	1	0	0	2	0	0	1	0
George Hill	26.8	1	8	12.5	3	10	30	8	23	34.8	6	28	21.4	8	17	47.1	0	0	undef	3	1	2	50	1	1	100	2	7	28.6	3	5	60	1	5	20	0	0	undef
Kyle Korver	20.9	7	12	58.3	3	14	21.4	32	73	43.8	17	39	43.6	27	65	41.5	1	2	50	3.2	0	0	undef	0	0	undef	2	8	25	1	3	33.3	1	6	16.7	1	1	100
JR Smith	31.1	7	16	43.8	12	21	57.1	24	81	29.6	27	58	46.6	15	62	24.2	2	6	33.3	1.8	0	0	undef	0	0	undef	0	4	0	0	0	undef	0	2	0	1	2	50
Kevin Love	28	2	12	16.7	4	12	33.3	25	70	35.7	8	35	22.9	21	60	35	2	3	66.7	3.8	1	3	33.3	0	1	0	4	7	57.1	2	8	25	3	6	50	0	0	undef
Rodney Hood	12.3	0	1	0	1	5	20	1	7	14.3	3	9	33.3	0	5	0	0	1	0	5.5	0	0	undef	0	0	undef	2	10	20	0	5	0	2	9	22.2	0	0	undef
Jeff Green	5.8	5	13	38.5	7	12	58.3	7	26	26.9	13	34	38.2	6	17	35.3	0	4	0	18.6	0	0	undef	0	1	0	2	14	14.3	1	3	33.3	2	13	15.4	0	2	0
High Minutes			When evaluating LeBron's impact on his teammates' 3PT shooting abilities, it is most important to consider the % change with him on/off the court. I decided to show both the regular season and the playoffs, since LeBron tends to play heavier minutes in a different style come playoff time.
Low Minutes			I also only showed the teammates that shot more than 20 threes per sample since anything smaller than that isn't good data. Any teammates that were excluded from this sheet either didn't get enough minutes or don't shoot threes.
			Doing my best to isolate the single variable of LeBron being on and off the court, I labelled any improvements of shooting percentages with green and any regression with red. I decided to leave any data I considered irrelevant or unfair to this argument in white.
			It is clear that the left side, when LeBron shares the court with his teammates, is more often green than red. Any cases of improvements with him off the court are small sample sizes, with n<30.
			One could easily run a 2 sample t-test to see the liklihood of LeBron having an effect on his teammates shooting, but I feel as if the results speak for themselves and I was told to keep the sheet simple, user-friendly, and I know not everyone understands the gravity of a high t-score.
			Sheet is currently locked to avoid any data moving around by accident. Password to unlock sheet is "lakers"

Sheet2

		Catch and Shoot			Pull Up			Closest Defender 0-2 ft				2-4 ft			4-6 ft			6+ ft			Time Touch Range 0-2 sec				2-6 sec			6+ sec			LEGEND
Player	Min	3PM	3PA	3P%	3PM	3PA	3P%		3PM	3PA	3P%	3PM	3PA	3P%	3PM	3PA	3P%	3PM	3PA	3P%		3PM	3PA	3P%	3PM	3PA	3P%	3PM	3PA	3P%
Lonzo Ball	34.2	1.1	3.4	32.8	0.6	2.1	28.7		-	-	-	0.1	0.4	27.3	0.8	2.5	30.5	0.9	2.6	32.6		1.3	3.8	33.5	0.2	1	24.5	0.3	0.9	28.9	High%	10	High MPG	10
Kentavious Caldwell-Pope	33.2	1.7	4.2	40.3	0.4	1.3	30.9		0	0.1	11.1	0.2	0.8	27.3	0.7	1.8	36.6	1.2	2.8	43.6		1.8	4.6	39.3	0.3	0.7	35.2	0	0.1	20		9		9
Derrick Williams	4.3	0	1	0	0	0	0		-	-	-	-	-	-	0	0.5	-	-	-	-		0	0.5	0	-	-	-	-	-	-		8		8
Alex Caruso	15.2	0.2	0.6	31.8	0.2	0.6	28.6		-	-	-	-	-	-	0	0.3	0	0.3	0.8	43.3		0.2	0.7	30.8	0.1	0.3	18.2	0.1	0.1	60		7		7
Channing Frye	13.1	0.7	2	34.3	0	0.1	28.6		-	-	-	0	0.1	16.7	0.2	0.7	28.6	0.5	1.3	39.4		0.7	2.1	35.1	0	0	0	-	-	-		6		6
Julius Randle	26.7	0.1	0.4	27.8	0	0.1	0		-	-	-	0	0	33.3	0	0.1	20	0.1	0.4	21.9		0.1	0.4	27.8	0	0.1	0	0	0	-		5		5
Josh Hart	23.2	1.1	2.7	40.7	0.1	0.5	31		-	-	-	0	0.1	28.6	0.6	1.4	39.3	0.7	1.6	41		1.2	2.8	42	0.1	0.3	22.2	0	0.1	25		4		4
Gary Payton II	9.6	0.3	1	27.3	0	0.1	0		-	-	-	-	-	-	0	0.3	14.3	0.2	0.7	29.4		-	-	-	0	0	0	-	-	-		3		3
Travis Wear	13.4	0.8	2.2	36.8	0.1	0.3	40		-	-	-	-	-	-	0.1	0.8	7.7	0.9	1.9	48.4		0.9	2.6	34.1	0.1	0.2	66.7	-	-	-		2		2
Andre Ingram	32.1	2.5	4	62.5	0	0.5	0		-	-	-	-	-	-	1.5	2.5	60	1	2	50		2.5	4	62.5	0	0.5	0	-	-	-		1		1
Andrew Bogut	9	0	0	0	0	0	0		-	-	-	-	-	-	-	-	-	-	-	-		-	-	-	-	-	-	-	-	-	Low%	0	Low MPG	0
Vander Blue	9	0	0.4	0	0	0	0		-	-	-	-	-	-	-	-	-	0	0.4	0		0	0.4	0	-	-	-	-	-	-
Thomas Bryant	4.8	0.1	0.5	12.5	0	0.1	0		-	-	-	-	-	-	0	0.1	-	0.1	0.6	11.1		0.1	0.6	11.1	0	0.1	0	-	-	-	Outlier
Luol Deng	13.1	0	0	0	0	0	0		-	-	-	-	-	-	-	-	-	-	-	-		-	-	-	-	-	-	-	-	-
Kyle Kuzma	31.2	1.7	4.6	37.6	0.3	1	30.7		0	0	100	0.1	0.4	20.7	1	2.7	36.5	1	2.6	39		1.8	4.8	36.7	0.3	0.6	40.4	0	0.2	23.1
Brook Lopez	23.4	1.4	4.2	34.1	0	0.1	37.5		-	-	-	0.1	0.1	55.6	0.2	0.8	25	1.2	3.4	35.9		1.5	4.3	34.4	0	0.1	20	0	0	100
Ivica Zubac	9.5	0	0	0	0	0	0		-	-	-	-	-	-	-	-	-	-	-	-		-	-	-	-	-	-	-	-	-
Tyler Ennis	12.7	0.2	0.6	25.7	0.1	0.4	15.8		-	-	-	0	0.1	0	0	0.3	7.1	0.2	0.6	32.4		0.2	0.7	25.7	0	0.2	8.3	0	0.1	33.3
Brandon Ingram	33.5	0.6	1.6	39.4	0.1	0.2	36.4		-	-	-	0.1	0.3	40	0.2	0.5	37.5	0.4	1	40.4		0.6	1.5	41.8	0	0.2	20	0	0.1	33.3
Isaiah Thomas	26.9	0.7	2.6	28	1	3.3	30.8		0	0.1	50	0.4	1.7	24.1	0.7	2.5	30.3	0.6	1.5	38.3		0.9	3	29.8	0.7	2	32.8	0.2	0.8	29.2
		Catch and Shoot			Pull Up			Closest Defender 0-2 ft				2-4 ft			4-6 ft			6+ ft			Time Touch Range 0-2 sec				2-6 sec			6+ sec
Player	Min	3PM	3PA	3P%	3PM	3PA	3P%		3PM	3PA	3P%	3PM	3PA	3P%	3PM	3PA	3P%	3PM	3PA	3P%		3PM	3PA	3P%	3PM	3PA	3P%	3PM	3PA	3P%
Jordan Clarkson	23.3	1	2.5	38.4	0.4	1.4	29.8		0	0.1	50	0.1	0.6	26.1	0.5	1.7	31.6	0.7	1.6	42.2		1.1	2.8	38	0.2	0.7	32.1	0.1	0.4	22.6
Okaro White	13.3	0.7	1.8	36.4	-	-	-		-	-	-	-	-	-	0	0.3	0	0.7	1.5	44.4		0.7	1.8	36.4	-	-	-	-	-	-
Kendrick Perkins	14.5	-	-	-	-	-	-		-	-	-	-	-	-	-	-	-	-	-	-		-	-	-	-	-	-	-	-	-
London Perrantes	4.7	0	0.1	0	0	0.1	0		-	-	-	-	-	-	-	-	-	0	0.2	0		0	0.1	0	-	-	-	0	0.1	0
Jose Calderon	16	0.6	1.2	52.1	0.1	0.5	30.8		-	-	-	0.1	0.2	54.5	0.3	0.7	37.8	0.4	0.8	52.1		0.7	1.3	49.3	0.1	0.2	36.4	0.1	0.2	36.4
George Hill	27	0.9	2.3	41.4	0.3	0.8	42.3		-	-	-	0.1	0.2	33.3	0.3	0.8	45.1	0.8	2	41.9		1	2.3	41.6	0.2	0.4	40.7	0.1	0.3	45.5
Kyle Korver	21.6	2	4.4	45	0.3	0.8	36.2		0.1	0.1	55.6	0.4	1.1	36.3	0.9	2.1	44.5	0.8	1.7	50		2.2	4.8	45	0.1	0.2	38.5	-	-	-
JR Smith	28.1	1.5	3.7	39.3	0.3	1	30		-	-	-	0.3	1	31.6	0.8	2	41.3	0.6	1.7	37.5		1.6	4.2	37.2	0.2	0.5	40	0	0.1	40
Cedi Osman	11	0.5	1.3	37.2	0	0.1	33.3		-	-	-	0	0.1	0	0.1	0.3	18.8	0.5	1.1	42.6		0.5	1.3	37	0	0.1	25	0	0	50
Rodney Hood	26.9	1.5	3.8	38.7	0.7	1.8	37		0.1	0.1	75	0.4	1	40.7	0.7	2.3	31.9	0.9	2.2	42.7		1.5	3.9	38.1	0.4	1	41	0.2	0.6	34.3
Larry Nance Jr.	21.5	0	0.2	20	-	-	-		-	-	-	-	-	-	-	-	-	0	0.2	18.2		0	0.1	25	0	0.1	0	-	-	-
Tristan Thompson	20.2	-	-	-	-	-	-		-	-	-	-	-	-	-	-	-	-	-	-		-	-	-	-	-	-	-	-	-
Kevin Love	28	2.1	5.1	41.1	0.2	0.5	43.3		0	0	0	0.1	0.5	20.7	0.6	1.7	35	1.6	3.3	48.7		2.1	5.2	41	0.2	0.4	54.5	-	-	-
Jeff Green	23.4	0.6	1.9	33.1	0	0.2	15.8		0	0	-	0	0.1	30	0.1	0.6	21.7	0.5	1.5	35.1		0.6	1.9	32.5	0.1	0.2	25	0	0	0
LeBron James	36.9	0.6	1.6	38.3	1.2	3.3	36		0	0	-	0.2	0.7	32.1	0.9	2.5	34.3	0.7	1.7	42.3		0.5	1.2	42	0.6	1.7	36.9	0.7	2	33.5
Ante Zizic	6.7	-	-	-	-	-	-		-	-	-	-	-	-	-	-	-	-	-	-		-	-	-	-	-	-	-	-	-
John Holland	7.3	0.3	1.1	26.9	0.2	0.4	44.4		0	0	0	0	0.2	25	0.1	0.5	27.3	0.3	0.8	35		0.3	1.3	25.8	0.1	0.2	50	0	0	100