Situational change in attempt/ assist rate

Home for all your discussion of basketball statistical analysis.
TeamEd
Posts: 21
Joined: Tue Jan 27, 2015 2:33 pm
Location: Toronto

Situational change in attempt/ assist rate

Post by TeamEd »

Hi there. I've been running with this idea on Reddit (here: http://www.reddit.com/r/nba/comments/2v ... p_players/) and other forums. I put more effort into synthesis there, but now I'm looking for some feedback from people who can give some real criticism. So, I'll skip most of the storytelling.

Up front, I'm handy with Excel, but I don't have any real statistical training to know where I'm making my embarrassing rookie mistakes.

I'm attempting to show how players change their offence in comeback situations. I'm using a simple formula that shows the percentage change in a player's True Shooting Attempt rate behind or tied, vs. their overall rate. I adjust that number to the leaguewide average, which is solidly positive. This way a 0 rating tells you a player increases his shooting at an expected rate in comebacks. Leaguewide, the average player's TSA rate is %5.2 higher when trailing .

This, I think, gives a number that reveals you how a player changes his offence situationally, in a comeback situation. Here's what that looks like for the top 50 players by total FGAs:

Image

Earlier this year I noticed that Kyle Lowry seemed to look to his own offence more when trailing. As you can see, he has in fact done this. So far this year, his TSA rate increases by 5.8% more than an average player while trailing. To me, this show that Lowry and Conley and the others at the top of the list have a more aggressive shooting mentality when their teams are down. That's why I'm calling this number "Shooting Mentality."

John Wall, on the other hand has taken -6.78% fewer TSAs in the same situation. He seems to have played with a much less aggressive shooting mentality.

For the sake of curiosity, I compared that rate to the players' change in TS% in comeback situations. Here's that chart:

Image

As you can see, there's no obvious correlation here. Players like Conley and Lowry increase both efficiency and aggressiveness, others like Griffin and Rose are both less efficient and less aggressive when trailing. And, there's people in between.

This is also corrected for average. An average player shoots -.5 points worse by TS% in comebacks.

Finally, I think the method works for any box score stat where I have situational splits. In that vein, here's a chart showing the percentage change in assist rate while trailing vs. overall. This is for the top 30 players in the NBA by assists this season:

Image

I think John Wall is especially interesting here, since his much increased assist rate is in contrast to his much lower shooting rate. He seems to look to pass in comebacks. Lowry seems to look to shoot over passing (though he was much more extreme in this earlier in the year). And someone like Conley seems to just get the ball a heck of a lot more often overall in comebacks. Lebron, meanwhile both shoots and passes less aggressively in comebacks.

This is corrected for the NBA average increase in assist rate of 3.65% in comebacks.

Anyway. What do you think? Is this interesting at all, or is it just noise? Are my assumptions valid? Are there holes in my method? I know I've made mistakes here. I'm sure I have sample size issues (especially with the assists and with players on really good teams). What advice can you give someone who's looking to learn more about this kind of analysis.

I also have a ton of questions about finding data. This is all manually pulled from NBA.com's in-game-splits. There's gotta be an easier way to get this and better data. Shooting mentality would be better on a per possession basis. The passing metric would work better if it looked at total passes. I don't know where to find that data, but I think it would be really useful. What do you suggest?
@EdTubb edwardtubb at gmail
DSMok1
Posts: 1119
Joined: Thu Apr 14, 2011 11:18 pm
Location: Maine
Contact:

Re: Situational change in attempt/ assist rate

Post by DSMok1 »

Excellent effort! The mentality question is a great topic to look into.

I'm sure there is some noise shown here, particularly in the TS%, since I'd expect that to stabilize much slower than shooting or passing mentality. Can you compare, say, half season splits to see how well these correlate with themselves?

As for data source question--I'm not an expert on that; I'm sure others here have more insight.
Developer of Box Plus/Minus
APBRmetrics Forum Administrator
Twitter.com/DSMok1
TeamEd
Posts: 21
Joined: Tue Jan 27, 2015 2:33 pm
Location: Toronto

Re: Situational change in attempt/ assist rate

Post by TeamEd »

DSMok1 wrote:Excellent effort! The mentality question is a great topic to look into.

I'm sure there is some noise shown here, particularly in the TS%, since I'd expect that to stabilize much slower than shooting or passing mentality. Can you compare, say, half season splits to see how well these correlate with themselves?

As for data source question--I'm not an expert on that; I'm sure others here have more insight.
I can do half season splits. It takes about an hour to pull the data with my current set up, so I'll do that with last years' numbers when I get a spare few hours.
@EdTubb edwardtubb at gmail
Crow
Posts: 10533
Joined: Thu Apr 14, 2011 11:10 pm

Re: Situational change in attempt/ assist rate

Post by Crow »

Very good topic and interesting results. Wonder though if it might be even better to also show performance when tie or ahead vs. when ahead. Player time splits will vary so it is not clear from the overall performance data how much was in each situation.
TeamEd
Posts: 21
Joined: Tue Jan 27, 2015 2:33 pm
Location: Toronto

Re: Situational change in attempt/ assist rate

Post by TeamEd »

Crow wrote:Very good topic and interesting results. Wonder though if it might be even better to also show performance when tie or ahead vs. when ahead. Player time splits sill vary so it is not clear from the overall performance data how much was in each situation.
What would be the best way to measure situational performance? I got into a data quirk awhile back trying to use NetRtg to assess overall team performance (changes in lead ring up +s on the trailing side and -s on the leading side so that every team looks wildly better while trailing). That left me stumped for a way to measure effectiveness on score splits with the data I have.

On the time splits, it's definitely an issue. Especially for players on the better teams. The sample ranges from ~1300 minutes while behind or tied for Wiggins to around just ~500 minutes for the Warriors and Hawks' players.

Anyway, here's my data for the shooting mentality chart. Seeing that might help you understand any issues I'm having. The Shooting Mentality formula is ((TSA/MP)-(TSA <=/MP <=))/(TSA/MP)*-100. The final rating is just that minus the leaguewide average, which is currently +5.19.

Code: Select all

╔══════════════╦════════╦════════╦══════╦═══════╦═══════╦═══════════╗
║    Player    ║  TSA   ║ TSA <= ║  MP  ║ MP <= ║  SM   ║ SM-LEAGUE ║
╠══════════════╬════════╬════════╬══════╬═══════╬═══════╬═══════════╣
║ J. Harden    ║ 1143.6 ║ 485.1  ║ 1859 ║   772 ║ 2.14  ║ -3.05     ║
║ M. Ellis     ║ 1027.0 ║ 513.8  ║ 1808 ║   864 ║ 4.69  ║ -0.50     ║
║ L. Aldridge  ║ 1024.7 ║ 599.3  ║ 1664 ║   911 ║ 6.82  ║ 1.63      ║
║ B. Griffin   ║ 1044.0 ║ 445.8  ║ 1800 ║   743 ║ 3.44  ║ -1.76     ║
║ D. Lillard   ║ 998.4  ║ 548.4  ║ 1896 ║  1009 ║ 3.20  ║ -1.99     ║
║ K. Irving    ║ 943.6  ║ 472.6  ║ 1885 ║   862 ║ 9.52  ║ 4.33      ║
║ S. Curry     ║ 922.8  ║ 333.1  ║ 1629 ║   569 ║ 3.34  ║ -1.86     ║
║ K. Thompson  ║ 891.6  ║ 322.3  ║ 1564 ║   545 ║ 3.75  ║ -1.44     ║
║ K. Lowry     ║ 913.9  ║ 479.0  ║ 1824 ║   861 ║ 11.03 ║ 5.84      ║
║ L. James     ║ 957.2  ║ 407.5  ║ 1583 ║   658 ║ 2.41  ║ -2.78     ║
║ A. Davis     ║ 926.5  ║ 499.8  ║ 1647 ║   824 ║ 7.81  ║ 2.62      ║
║ C. Anthony   ║ 888.1  ║ 655.6  ║ 1396 ║   963 ║ 7.02  ║ 1.82      ║
║ T. Evans     ║ 855.0  ║ 455.7  ║ 1731 ║   907 ║ 1.72  ║ -3.47     ║
║ R. Westbrook ║ 904.2  ║ 469.6  ║ 1212 ║   590 ║ 6.68  ║ 1.49      ║
║ N. Vucevic   ║ 833.3  ║ 604.2  ║ 1644 ║  1122 ║ 6.24  ║ 1.05      ║
║ J. Wall      ║ 840.4  ║ 396.6  ║ 1858 ║   891 ║ -1.59 ║ -6.78     ║
║ R. Gay       ║ 845.0  ║ 492.5  ║ 1617 ║   949 ║ -0.68 ║ -5.87     ║
║ G. Hayward   ║ 857.9  ║ 530.2  ║ 1789 ║  1088 ║ 1.62  ║ -3.57     ║
║ B. Knight    ║ 801.7  ║ 442.4  ║ 1626 ║   836 ║ 7.33  ║ 2.14      ║
║ P. Gasol     ║ 818.7  ║ 499.5  ║ 1719 ║   983 ║ 6.69  ║ 1.49      ║
║ K. Bryant    ║ 819.0  ║ 608.1  ║ 1207 ║   809 ║ 10.78 ║ 5.58      ║
║ C. Paul      ║ 791.6  ║ 363.0  ║ 1795 ║   772 ║ 6.61  ║ 1.42      ║
║ C. Bosh      ║ 802.7  ║ 428.0  ║ 1482 ║   727 ║ 8.70  ║ 3.51      ║
║ M. Morris    ║ 761.3  ║ 436.1  ║ 1629 ║   866 ║ 7.75  ║ 2.56      ║
║ D. Nowitzki  ║ 789.7  ║ 417.8  ║ 1459 ║   722 ║ 6.90  ║ 1.71      ║
║ M. Gasol     ║ 835.3  ║ 364.0  ║ 1739 ║   684 ║ 10.79 ║ 5.60      ║
║ D. Rose      ║ 767.0  ║ 462.3  ║ 1266 ║   756 ║ 0.94  ║ -4.25     ║
║ K. Walker    ║ 785.3  ║ 455.8  ║ 1495 ║   853 ║ 1.72  ║ -3.47     ║
║ J. Butler    ║ 849.4  ║ 512.7  ║ 1906 ║  1053 ║ 9.25  ║ 4.06      ║
║ D. Cousins   ║ 828.8  ║ 488.0  ║ 1309 ║   741 ║ 4.02  ║ -1.17     ║
║ A. Wiggins   ║ 774.1  ║ 595.1  ║ 1753 ║  1301 ║ 3.58  ║ -1.61     ║
║ A. Jefferson ║ 721.7  ║ 409.0  ║ 1317 ║   755 ║ -1.14 ║ -6.33     ║
║ K. Love      ║ 785.3  ║ 364.8  ║ 1786 ║   780 ║ 6.37  ║ 1.18      ║
║ W. Mathews   ║ 720.6  ║ 408.2  ║ 1771 ║   959 ║ 4.62  ║ -0.57     ║
║ T. Harris    ║ 748.6  ║ 525.4  ║ 1626 ║  1077 ║ 5.96  ║ 0.76      ║
║ G. Dragic    ║ 723.4  ║ 417.2  ║ 1696 ║   932 ║ 4.94  ║ -0.25     ║
║ J. Johnson   ║ 713.5  ║ 401.5  ║ 1699 ║   889 ║ 7.55  ║ 2.36      ║
║ E. Bledsoe   ║ 783.8  ║ 447.0  ║ 1756 ║   950 ║ 5.42  ║ 0.23      ║
║ J. Crawford  ║ 751.5  ║ 358.8  ║ 1358 ║   570 ║ 13.74 ║ 8.55      ║
║ T. Burke     ║ 693.6  ║ 440.8  ║ 1591 ║   956 ║ 5.76  ║ 0.57      ║
║ J. Sullinger ║ 701.6  ║ 413.5  ║ 1435 ║   820 ║ 3.14  ║ -2.05     ║
║ J. Smith     ║ 712.8  ║ 421.8  ║ 1492 ║   797 ║ 10.79 ║ 5.60      ║
║ A. Afflalo   ║ 705.1  ║ 392.1  ║ 1697 ║   935 ║ 0.92  ║ -4.27     ║
║ T. Lawson    ║ 759.1  ║ 440.2  ║ 1805 ║  1024 ║ 2.21  ║ -2.98     ║
║ R. Anderson  ║ 695.1  ║ 368.1  ║ 1453 ║   750 ║ 2.60  ║ -2.59     ║
║ P. Milsap    ║ 752.9  ║ 293.8  ║ 1697 ║   596 ║ 11.12 ║ 5.93      ║
║ W. Chandler  ║ 669.0  ║ 395.4  ║ 1585 ║   880 ║ 6.45  ║ 1.26      ║
║ M. Conley    ║ 710.6  ║ 345.6  ║ 1506 ║   642 ║ 14.07 ║ 8.88      ║
║ C. Parsons   ║ 692.9  ║ 330.2  ║ 1653 ║   764 ║ 3.10  ║ -2.09     ║
║ A. Horford   ║ 672.6  ║ 259.5  ║ 1533 ║   536 ║ 10.34 ║ 5.15      ║
╚══════════════╩════════╩════════╩══════╩═══════╩═══════╩═══════════╝
@EdTubb edwardtubb at gmail
Crow
Posts: 10533
Joined: Thu Apr 14, 2011 11:10 pm

Re: Situational change in attempt/ assist rate

Post by Crow »

If you want to keep mining this vein and have the detail, you could look at how much of the ts% change comes from ftas, 3s, inside shots, 2s (especially long 2s).,You could also take this to the level of pts per possession to include turnovers.

You might also look at avg. bench strength for these players and mostly starter / mostly bench lineup strength ratios. This will affect % time behind / ahead but also strength of lineups with them to deal with failing behind. Could look at avg. combined usage for lineups with these players to see who has more or less "help" / "competition" /decoys for usage.
Crow
Posts: 10533
Joined: Thu Apr 14, 2011 11:10 pm

Re: Situational change in attempt/ assist rate

Post by Crow »

Irving with more time behind than ahead is not that surprising. For the lead Blazers it is worth noting.
TeamEd
Posts: 21
Joined: Tue Jan 27, 2015 2:33 pm
Location: Toronto

Re: Situational change in attempt/ assist rate

Post by TeamEd »

Crow wrote:If you want to keep mining this vein and have the detail, you could look at how much of the ts% change comes from ftas, 3s, inside shots, 2s (especially long 2s).,You could also take this to the level of pts per possession to include turnovers.

You might also look at avg. bench strength for these players and mostly starter / mostly bench lineup strength ratios. This will affect % time behind / ahead but also strength of lineups with them to deal with failing behind. Could look at avg. combined usage for lineups with these players to see who has more or less "help" / "competition" /decoys for usage.
That's a lot to digest, but all good stuff to look at moving forward.

My first problem is access to data. Right now, I'm manually pulling player data from NBA.com. That takes over an hour a run. Any idea where I might go to find per possession data with ahead/ behind splits?
@EdTubb edwardtubb at gmail
Crow
Posts: 10533
Joined: Thu Apr 14, 2011 11:10 pm

Re: Situational change in attempt/ assist rate

Post by Crow »

Folks who have or probably have it: 82games, JE, Justin Rao.

Might have it: Evan Z, talkingpractice, others here.

Wait n see or ask around.
Crow
Posts: 10533
Joined: Thu Apr 14, 2011 11:10 pm

Re: Situational change in attempt/ assist rate

Post by Crow »

When and if digestion, data and time allow, one could potentially look at performance when behind by quarter (how much of the total effect occurs in 4th, how much is clutch time vs garbage time?) home/road, quality of opponent, referees (for foul calls and no calls), by 2-4 minute blocks of each time behind, by month, by impact on playoff status, in the playoffs (by round and maybe game number)...

Keep the CPU cool, bring some food and maybe some Pepto...
AcrossTheCourt
Posts: 237
Joined: Sat Feb 16, 2013 11:56 am

Re: Situational change in attempt/ assist rate

Post by AcrossTheCourt »

What I would is compare the stats for every player in 2015 to another season to see how much of this is noise and how much isn't.
TeamEd
Posts: 21
Joined: Tue Jan 27, 2015 2:33 pm
Location: Toronto

Re: Situational change in attempt/ assist rate

Post by TeamEd »

AcrossTheCourt wrote:What I would is compare the stats for every player in 2015 to another season to see how much of this is noise and how much isn't.
That's the next step. I'm sitting at a cafe editing and listening to conversations in Portuguese. In March, when I get back, I'll do a set of runs going back as far as I can reasonably manage for exactly this reason.
@EdTubb edwardtubb at gmail
TeamEd
Posts: 21
Joined: Tue Jan 27, 2015 2:33 pm
Location: Toronto

Re: Situational change in attempt/ assist rate

Post by TeamEd »

Ok. I tried to learn Python and Scrapy, failed to get anywhere, and then jerry rigged a process to get the data using a batch link downloader, TextPad and some creative Excel work. It maybe took longer than it should, but by this afternoon I'll have NBA.com's entire database of player in-game splits organized in an Excel sheet that calculates situational change in shooting, passing and rebounds (among other things) for everyone since the 1996-97 season.

I want to go about this the right way. But, I don't have a lot of statistical savvy. So, my first check is to see if these numbers are valid. My guess is I need look at noise see to see if these measures predict themselves season to season. How do I do that quantitatively? I'll preview my data so you can see what I'm looking at.

Here are a sample of stars' situational shooting mentalities (behind/tied) since the 08-09 season, which is as far back as my data goes while my computer is working on the rest. As you can see, there's a fair amount of consistency here. Bosh and Durant are consistently above average; Melo is consistently around average; Lebron is consistently below average, as examples.

Code: Select all

╔═════════╦═══════════════════╦════════╗
║  Year   ║       NAME        ║ SSM <= ║
╠═════════╬═══════════════════╬════════╣
║ 2010-11 ║ Blake Griffin     ║ 1.35   ║
║ 2011-12 ║ Blake Griffin     ║ 2.151  ║
║ 2012-13 ║ Blake Griffin     ║ 4.010  ║
║ 2013-14 ║ Blake Griffin     ║ 3.338  ║
║ 2008-09 ║ Carmelo Anthony   ║ -2.79  ║
║ 2009-10 ║ Carmelo Anthony   ║ 0.701  ║
║ 2010-11 ║ Carmelo Anthony   ║ 2.87   ║
║ 2011-12 ║ Carmelo Anthony   ║ 2.004  ║
║ 2012-13 ║ Carmelo Anthony   ║ 1.215  ║
║ 2013-14 ║ Carmelo Anthony   ║ 1.087  ║
║ 2008-09 ║ Chris Bosh        ║ 3.91   ║
║ 2009-10 ║ Chris Bosh        ║ 2.601  ║
║ 2010-11 ║ Chris Bosh        ║ 2.32   ║
║ 2011-12 ║ Chris Bosh        ║ 6.969  ║
║ 2012-13 ║ Chris Bosh        ║ 3.749  ║
║ 2013-14 ║ Chris Bosh        ║ 3.856  ║
║ 2008-09 ║ Dirk Nowitzki     ║ -0.53  ║
║ 2009-10 ║ Dirk Nowitzki     ║ -2.732 ║
║ 2010-11 ║ Dirk Nowitzki     ║ 8.06   ║
║ 2011-12 ║ Dirk Nowitzki     ║ -0.527 ║
║ 2013-14 ║ Dirk Nowitzki     ║ 5.562  ║
║ 2008-09 ║ Dwight Howard     ║ 1.70   ║
║ 2009-10 ║ Dwight Howard     ║ -0.500 ║
║ 2010-11 ║ Dwight Howard     ║ -2.28  ║
║ 2011-12 ║ Dwight Howard     ║ -0.617 ║
║ 2012-13 ║ Dwight Howard     ║ -8.116 ║
║ 2013-14 ║ Dwight Howard     ║ 0.677  ║
║ 2008-09 ║ Dwyane Wade       ║ -1.69  ║
║ 2009-10 ║ Dwyane Wade       ║ -0.751 ║
║ 2010-11 ║ Dwyane Wade       ║ -1.91  ║
║ 2011-12 ║ Dwyane Wade       ║ -3.135 ║
║ 2012-13 ║ Dwyane Wade       ║ 0.005  ║
║ 2012-13 ║ James Harden      ║ 3.052  ║
║ 2013-14 ║ James Harden      ║ -1.518 ║
║ 2008-09 ║ Kevin Durant      ║ -0.14  ║
║ 2009-10 ║ Kevin Durant      ║ 4.475  ║
║ 2010-11 ║ Kevin Durant      ║ 1.17   ║
║ 2011-12 ║ Kevin Durant      ║ 9.785  ║
║ 2012-13 ║ Kevin Durant      ║ 7.346  ║
║ 2013-14 ║ Kevin Durant      ║ 9.671  ║
║ 2008-09 ║ Kobe Bryant       ║ 0.44   ║
║ 2009-10 ║ Kobe Bryant       ║ 2.538  ║
║ 2010-11 ║ Kobe Bryant       ║ -0.69  ║
║ 2011-12 ║ Kobe Bryant       ║ -4.444 ║
║ 2012-13 ║ Kobe Bryant       ║ 5.054  ║
║ 2008-09 ║ LeBron James      ║ -0.32  ║
║ 2009-10 ║ LeBron James      ║ 3.930  ║
║ 2010-11 ║ LeBron James      ║ -7.33  ║
║ 2011-12 ║ LeBron James      ║ -4.419 ║
║ 2012-13 ║ LeBron James      ║ -1.294 ║
║ 2013-14 ║ LeBron James      ║ -1.649 ║
║ 2008-09 ║ Russell Westbrook ║ 2.79   ║
║ 2009-10 ║ Russell Westbrook ║ 2.852  ║
║ 2010-11 ║ Russell Westbrook ║ 4.71   ║
║ 2011-12 ║ Russell Westbrook ║ 2.089  ║
║ 2012-13 ║ Russell Westbrook ║ 1.360  ║
║ 2009-10 ║ Stephen Curry     ║ -2.989 ║
║ 2010-11 ║ Stephen Curry     ║ -1.70  ║
║ 2012-13 ║ Stephen Curry     ║ 2.715  ║
║ 2013-14 ║ Stephen Curry     ║ 6.580  ║
╚═════════╩═══════════════════╩════════╝
And here's a similar preview of situational assist mentality for a sample of prolific passers. There appears to be a more noise here. Paul, Lowry and Calderon have wild swings. Nash is the only one showing solid consistency:

Code: Select all

╔═════════╦═══════════════════╦════════╗
║  Year   ║       NAME        ║ SAM <= ║
╠═════════╬═══════════════════╬════════╣
║ 2008-09 ║ Chris Paul        ║ 2.78   ║
║ 2009-10 ║ Chris Paul        ║ 6.072  ║
║ 2010-11 ║ Chris Paul        ║ 3.84   ║
║ 2011-12 ║ Chris Paul        ║ -6.499 ║
║ 2012-13 ║ Chris Paul        ║ -5.676 ║
║ 2008-09 ║ Deron Williams    ║ 2.29   ║
║ 2009-10 ║ Deron Williams    ║ 0.820  ║
║ 2010-11 ║ Deron Williams    ║ 0.21   ║
║ 2011-12 ║ Deron Williams    ║ 3.069  ║
║ 2012-13 ║ Deron Williams    ║ -1.105 ║
║ 2011-12 ║ Goran Dragic      ║ 14.180 ║
║ 2012-13 ║ Goran Dragic      ║ -3.912 ║
║ 2013-14 ║ Goran Dragic      ║ 0.618  ║
║ 2008-09 ║ Jose Calderon     ║ -1.86  ║
║ 2009-10 ║ Jose Calderon     ║ 6.687  ║
║ 2010-11 ║ Jose Calderon     ║ 1.55   ║
║ 2011-12 ║ Jose Calderon     ║ -1.728 ║
║ 2012-13 ║ Jose Calderon     ║ -7.647 ║
║ 2010-11 ║ Kyle Lowry        ║ -0.34  ║
║ 2011-12 ║ Kyle Lowry        ║ -6.363 ║
║ 2012-13 ║ Kyle Lowry        ║ -8.546 ║
║ 2013-14 ║ Kyle Lowry        ║ 6.804  ║
║ 2008-09 ║ Rajon Rondo       ║ 1.75   ║
║ 2009-10 ║ Rajon Rondo       ║ -1.610 ║
║ 2010-11 ║ Rajon Rondo       ║ 2.73   ║
║ 2011-12 ║ Rajon Rondo       ║ -5.334 ║
║ 2012-13 ║ Rajon Rondo       ║ 6.062  ║
║ 2008-09 ║ Russell Westbrook ║ -4.19  ║
║ 2009-10 ║ Russell Westbrook ║ -0.712 ║
║ 2010-11 ║ Russell Westbrook ║ 1.13   ║
║ 2011-12 ║ Russell Westbrook ║ 6.207  ║
║ 2012-13 ║ Russell Westbrook ║ 3.018  ║
║ 2008-09 ║ Steve Nash        ║ 3.07   ║
║ 2009-10 ║ Steve Nash        ║ 2.860  ║
║ 2010-11 ║ Steve Nash        ║ 3.83   ║
║ 2011-12 ║ Steve Nash        ║ 2.345  ║
║ 2008-09 ║ Tony Parker       ║ 3.00   ║
║ 2010-11 ║ Tony Parker       ║ 0.56   ║
║ 2011-12 ║ Tony Parker       ║ 9.800  ║
║ 2012-13 ║ Tony Parker       ║ 1.520  ║
╚═════════╩═══════════════════╩════════╝
And finally, here's a sample of top rebounders over this period. This is the same formula as the others: it's the percent difference in rebound rate while trailing vs. overall adjusted for seasonal league average. There's noise here, but it's better than I thought it would be. I wasn't expecting much from the rebounding measure.

Code: Select all

╔═════════╦═══════════════════╦═════════╗
║  Year   ║       NAME        ║ SRM <=  ║
╠═════════╬═══════════════════╬═════════╣
║ 2009-10 ║ Al Jefferson      ║ 1.529   ║
║ 2010-11 ║ Al Jefferson      ║ 3.91    ║
║ 2011-12 ║ Al Jefferson      ║ -1.255  ║
║ 2012-13 ║ Al Jefferson      ║ -0.696  ║
║ 2013-14 ║ Al Jefferson      ║ -0.402  ║
║ 2010-11 ║ Blake Griffin     ║ -0.29   ║
║ 2011-12 ║ Blake Griffin     ║ 3.494   ║
║ 2012-13 ║ Blake Griffin     ║ -12.640 ║
║ 2013-14 ║ Blake Griffin     ║ 0.079   ║
║ 2009-10 ║ Carlos Boozer     ║ 4.761   ║
║ 2011-12 ║ Carlos Boozer     ║ 2.873   ║
║ 2012-13 ║ Carlos Boozer     ║ -3.817  ║
║ 2008-09 ║ Chris Bosh        ║ 1.76    ║
║ 2009-10 ║ Chris Bosh        ║ 1.592   ║
║ 2010-11 ║ Chris Bosh        ║ -2.38   ║
║ 2011-12 ║ Chris Bosh        ║ -0.685  ║
║ 2009-10 ║ David Lee         ║ -0.975  ║
║ 2010-11 ║ David Lee         ║ -1.61   ║
║ 2011-12 ║ David Lee         ║ 4.754   ║
║ 2012-13 ║ David Lee         ║ 1.328   ║
║ 2013-14 ║ David Lee         ║ -2.116  ║
║ 2010-11 ║ DeMarcus Cousins  ║ 1.98    ║
║ 2011-12 ║ DeMarcus Cousins  ║ 6.253   ║
║ 2012-13 ║ DeMarcus Cousins  ║ 1.205   ║
║ 2013-14 ║ DeMarcus Cousins  ║ 0.854   ║
║ 2008-09 ║ Dwight Howard     ║ -2.90   ║
║ 2009-10 ║ Dwight Howard     ║ 1.199   ║
║ 2010-11 ║ Dwight Howard     ║ -0.52   ║
║ 2011-12 ║ Dwight Howard     ║ -3.187  ║
║ 2012-13 ║ Dwight Howard     ║ -3.833  ║
║ 2013-14 ║ Dwight Howard     ║ -1.860  ║
║ 2011-12 ║ Greg Monroe       ║ -4.424  ║
║ 2012-13 ║ Greg Monroe       ║ -0.519  ║
║ 2013-14 ║ Greg Monroe       ║ -2.346  ║
║ 2010-11 ║ Kevin Love        ║ 1.19    ║
║ 2011-12 ║ Kevin Love        ║ 5.046   ║
║ 2013-14 ║ Kevin Love        ║ 0.419   ║
║ 2008-09 ║ LaMarcus Aldridge ║ -7.11   ║
║ 2009-10 ║ LaMarcus Aldridge ║ -4.292  ║
║ 2010-11 ║ LaMarcus Aldridge ║ 1.72    ║
║ 2011-12 ║ LaMarcus Aldridge ║ -7.674  ║
║ 2012-13 ║ LaMarcus Aldridge ║ 2.232   ║
║ 2013-14 ║ LaMarcus Aldridge ║ 1.835   ║
║ 2008-09 ║ Pau Gasol         ║ -2.74   ║
║ 2010-11 ║ Pau Gasol         ║ -0.63   ║
║ 2011-12 ║ Pau Gasol         ║ 1.919   ║
║ 2008-09 ║ Tim Duncan        ║ -2.89   ║
║ 2009-10 ║ Tim Duncan        ║ 2.974   ║
║ 2011-12 ║ Tim Duncan        ║ -6.728  ║
║ 2012-13 ║ Tim Duncan        ║ 3.714   ║
║ 2009-10 ║ Zach Randolph     ║ 2.263   ║
║ 2010-11 ║ Zach Randolph     ║ -0.73   ║
║ 2012-13 ║ Zach Randolph     ║ -1.080  ║
║ 2013-14 ║ Zach Randolph     ║ 4.169   ║
╚═════════╩═══════════════════╩═════════╝
So, what do you guys think so far? How do I quantitatively measure the noise in this data?
@EdTubb edwardtubb at gmail
Crow
Posts: 10533
Joined: Thu Apr 14, 2011 11:10 pm

Re: Situational change in attempt/ assist rate

Post by Crow »

Glad you are still working on it. Hope you get the further advice you seek.

Would be curious to see the trends for J Kidd on all three stats. And Magic Johnson if you get back that far.
TeamEd
Posts: 21
Joined: Tue Jan 27, 2015 2:33 pm
Location: Toronto

Re: Situational change in attempt/ assist rate

Post by TeamEd »

Crow wrote:Glad you are still working on it. Hope you get the further advice you seek.

Would be curious to see the trends for J Kidd on all three stats. And Magic Johnson if you get back that far.
Unfortunately, NBA.com data only goes as far back as 1996-97. So, no data for Magic.

My data is finished compiling. So, here's the Situational Shooting Mentality for every player who finished a season in the top 100 by TSAs and had more than 650 TSAs total (sample sizes get pretty small in strike years). I've done splits behind and tied, which was my original forumla, and for close, which I've defined as +/- 5 points for sample size reasons (roughly 40% of NBA minutes happen within +/- 5 points.) I'll do a full treatment of this including this season's data, and passing and rebound mentality with analysis when I get a chance. In the meantime, enjoy playing around with this first set:

https://public.tableausoftware.com/view ... _count=yes

*Edit: The Tableau link is being updated as I continue
@EdTubb edwardtubb at gmail
Post Reply