APBRmetrics

Hi everybody!!!

I'm here again with my doubts!!! I'm making calculations about Offensive Rating and Defensive Rating aplying Dean Oliver's formulas. With Offensive Rating I haven't any doubt but with Defensive Rating ... I've got strange results in some cases. I'm applying the formula just only for a game right now, so ... ¿is it possible that I've got strange results because I'm making calulations for only one game? The strange result is that I've got a negative defensive rating with a player that only play two minutes. I have revised the formula several times, and all the intermedia calculations are right but the negative result occurs when I calculate the last step:

DRtg = Team_Defensive_Rating + 0.2 * (100 * D_Pts_per_ScPoss * (1 - Stop%) - Team_Defensive_Rating

So, what can I do in this cases? I mean, what is the more elegant solution to show in this cases? Show a negative value? Convert negative values to zero? Don't show anything?

And my second question about Offensive Rating and Defensive Rating is ... When I will make calculations to get the Offensive Rating or Defensive Rating about 5, 10, 20 games or all a regular season. What is better ... to sum all the Offensive Rating and Defensive Rating of each game and get the average or apply the formulas to all the games? I guess is the second option, but I would like to know how do you work in this cases if you previously have all the Offensive Rating and Defensive Rating previously calculated by game.

That's all!!! Thanks in advance for your appreciated help!!!

Could you share the inputs for the player getting the negative result?

Yes, of course!!! Here is the data ...

Anyboby has any answer about my questions?

"is it possible that I've got strange results because I'm making calulations for only one game?"

Yes. And for only 2 minutes. 2 blocks and 2 steals in 2 minutes is just tremendous low sample size results and sorta breaks the normal scale. Accept that as a relative result and don't worry about it being negative.

"What is better ... to sum all the Offensive Rating and Defensive Rating of each game and get the average or apply the formulas to all the games?" I am not sure there is a certain "better" answer. Applying the formula to all games at once is most common but players actually play in and impact individual games. If it is easier for you, do the sum and average. In long run the difference will probably be small. The same method is applied to everyone. Might make slight difference between most consistent player and most inconsistent (consistent with themselves game to game or consistent with team within games) but I don't think many cases would be affected much. If you did it both ways you could find out and probably be the only one who knows.

Your questions show thoroughness, attention to detail. Asking questions is good but won't always work. Trust your own judgments. Lay out your methods and if someone offers a suggestion or opinion, listen to it & evaluate it. Go where you want with your analysis. Certainly don't let non-response to questions stop you for long. Do your best and listen. Asking twice shows persistence and persistence is good but even that won't always work. If you can't get an answer here, try reddit, real gm or use twitter to ask someone good at analysis. Not many post here anymore. Read here? Some still do, some don't.

Thank you so much Crow for your help again!!! You are very kind with me and my doubts!!! ))

Do you have any suggestion about any thread in reddit?

I don't know much about reddit but you could start here and explore https://www.reddit.com/r/NBAanalytics/

At realGM this is the place https://forums.realgm.com/boards/viewforum.php?f=344

Thank you!!!