Actually it’s really easy to determine how to create a rating.
First, determine the range of the in-game rating. For example, you may want to use 25 – 99, 43 – 100, or 50 – 84, etc…
We then create two variables: RatingLow, RatingHigh.
Second, let’s assume we will assign the lowest actual statistic to the lowest rating, and the highest actual statistic to the highest possible rating. So, for example, I noticed on one NCAA stat site assists ranged from 1.2 to 6.7 per game (for all players with 20+ mins). We can then, using a 25 – 99 rating, decide that 1.2 = 25 and 6.7 = 99.
We now create two additional variables: StatLow, StatHigh.
Before discussing the methods, keep the following additional variables and terms in mind:
RatingRange: the total range between the highest and lowest rating (e.g. Awareness in the videogame)
StatRange: the total range between the highest and lowest statistic (e.g. Assists in real life)
RangePart: the ratio that relates each difference in the statistic to a difference in the rating
AttributeRating: the real-life statistic converted to the videogame rating
ActualStat: the real-life statistic for the player
“/” Symbol: divided by, for example; 6 / 2 = 3
Now, before we plug in the numbers, the method is as follows:
RatingRange = RatingHigh – RatingLow
StatRange = StatHigh – StatLow
RangePart = StatRange / RatingRange
AttributeRating = ((ActualStat – StatLow) / RangePart) + RantingLow
Now, we plug in the numbers. Keep in mind that I do perform some rounding of the numbers to keep it clear.
So, let’s say we want to convert a guard with 5.4 assists per game to an awareness rating with the in-game ranges mentioned earlier: 25 to 99, and the stat ranges also mentioned earlier: 1.2 to 6.7.
Using the method above, it’s quite simple:
RatingRange[74] = RatingHigh[99] – RatingLow[25]
StatRange[5.5] = StatHigh[6.7] – StatLow[1.2]
RangePart[.0743] = StatRange[5.5] / RatingRange[74]
AttributeRating[97.7] = ((ActualStat[5.4] – StatLow[1.2]) / RangePart[.0743]) + RatingLow[25]
Keep in mind that, you calculate the part in the parentheses first – starting from the innermost parentheses and working your way out from there to the final answer. So, in the final line of the method where you find “AttributeRating”, first subtract “StatLow” from “ActualStat”, then divide that answer by “RangePart”, and finally add the resulting answer to “RatingLow”. That will give you the “AttributeRating”.
If you have any questions or want to figure out how to reconcile multiple real-life stats into one in-game rating, just let me know. I’m a statistician and do this kind of stuff all day at work for my company.

Comment