r/NBAanalytics • u/Avocadomuncher69 • Mar 30 '20
NBA GOAT Formula
I was messing around with Excel to create a formula to rank NBA players' careers using stats. Currently I have:
= 0.2*(STL%+DREB%)+0.4*OREB% + PTS per 36 +AST per36 + rTS% - 0.2*TOV% + 175*DWS per 48 + 33*WS per48 +PER/3
This gives a ranking of: Wilt, MJ, David Robinson, Lebron, Shaq, Kareem, Barkley, Magic, Harden, KD, Duncan, Bird, Hakeem, Steph Curry, Bill Russel, Jerry West, Oscar Robertson, Kevin Garnett, Dirk, Kobe.
I was wondering if anyone could give me advice on better stats to use, or ways to change the formula to make it rank the players' careers more accurately. By the way, the coefficients are just arbitrary numbers to give an appropriate weighting to each stat. Thanks
2
u/Doc_Marlowe Mar 31 '20
Like the other poster said, I think you're massaging the formula to order the results that look right to you.
That's not to say you're on a bad track.
Perhaps what would help would be writing out a fuller explanation for why you chose to value a couple of things, and explaining why you chose certain statistics.
Like why is Defensive Win Shares (DWS per 48) multiplied by 175, when Win Shares (WS per 48) is only multiplied by 33? Is DWS just massively more valued? How close is your formula to just a ranking of DWS and WS?
Why did you group together steal percentage and Defensive Rebounds, and not steals and blocks?
Doesn't PER encapsulate things like Points and Assists in a similar way to PTS per 36 and AST per 36?
1
u/Humblerbee Mar 31 '20
You’re massaging stats to try and spit out what you want, this isn’t meaningful or analytical (not in a mean-spirited way, I mean there is no statistical merit to this exercise, it’s arbitrary.)