APBRmetrics

Chronz1 · Joined: 22 May 2006 Posts: 201

Meaning on a scale of 25-99 how would one go about scaling rebound rate onto this platform? Its totally irrelevant I know but if your wondering why I would want to do this, its for a video game. Im recreating the 2001 season. And Im starting off with rebounding;

http://www.basketball-reference.com/play-index/tiny.cgi?id=aJQgb

Deke is obviously #1 with a +30 rebounding%, and Wesley is the marker for 25. But Im struggling with the middle grouping.

Any help?

DSMok1 · Posted: Wed Mar 31, 2010 3:21 pm Post subject:

Rebound rate is linear, so you can scale it directly.

That said, total rebound% may be what you want; a "league average" player on total rebound% is by definition 10%.

Chronz1 · Joined: 22 May 2006 Posts: 201

DSMok1 · Posted: Wed Mar 31, 2010 4:00 pm Post subject:

Chronz1 · Joined: 22 May 2006 Posts: 201

I was hoping you could offer an excel alternative, Im downloading the free trial as I type but because its the whole MS Office package its going to take awhile.

Ed **Küpfer** · Joined: 30 Dec 2004 Posts: 785 Location: Toronto

I don't think I'm following. Do you want Wesley's DR% to equal 25 and Mutombo's to equal 99?
_________________
ed

Chronz1 · Joined: 22 May 2006 Posts: 201

jsill · Joined: 19 Aug 2009 Posts: 73

If I understand correctly, you have a bunch of players ranked according to some stat (DReb %, in this case), and you want to translate that stat into the range 25 through 99, where the guy with the highest value=99 and the guy with the lowest value=25.

There are a few different ways you could do this, but this should work:

1) Subtract the value for the top guy (Mutombo, with DReb%=30.5%) from the value for the bottom guy (Wesley, 5.9%). This gives you the range of values, which in this case is 30.5%-5.9%=24.6%

2) For each player, subtract the bottom value (5.9%, Wesley's DReb%) from their value (their DReb%) to compute how much better they are on the stat than the worst player. For instance, Jason Kidd's DReb% is 15.2% so his additional DReb% relative to Wesley is 15.2%-5.9%=9.3%

3) Divide the result in (2) (9.3%) by the result in (1) (24.6%) to get the percentage of the total range by which the player exceeds the minimum. In Kidd's case, this is 0.378, or 37.8%. Note: this is not 37.8% in units of DReb%; this is 37.8% of the total range of this stat.

4) Take the result in 3 and multiply it by 74 (we get 74 by subtracting 25 from 99). For Kidd, we get 74*0.378=27.97

5) Add the result in (4) to 25. For Kidd, we get 25 + 27.97=52.97.

Of course, the results here will be sensitive to what we call "outliers", i.e. , the values for the top guy and bottom guy. I think that's OK as long as they played a lot of minutes, though. Hypothetically, if you had a 9-foot-tall mega-superstar rebounder whose DReb% were 60%, and Mutombo were number 2 at 30%, then the 9-foot guy would be a 99 and Mutombo (even though he's second in the league) would be below 50. I think that's desirable, though, because that guy really would be twice as good as anyone else in the league at defensive rebounding. If you're working with very low-minutes guys who might have a DReb% of 60% just as a random fluke, that might be more problematic, but presumably for a video game you're only working with well-known players.

For what it's worth, if you find yourself encountering these kinds of problems frequently, it probably would be worth your while to brush up on your algebra so you can solve this kind of stuff on your own.

Ed **Küpfer** · Joined: 30 Dec 2004 Posts: 785 Location: Toronto

If Column A is where the rebounding numbers are, and they start in cell A2, then paste this beside A2 and copy it all the way down.
=(A2-MIN(A:A))/(MAX(A:A)-MIN(A:A))*74+25
_________________
ed

Chronz1 · Joined: 22 May 2006 Posts: 201

Awesome jsill, that made perfect sense, my 2k brethren thank you.

DSMok1 · Posted: Thu Apr 01, 2010 9:44 am Post subject: