# Noramalisation of a score in a number range with variable number ranges

• Jan 11th 2012, 01:06 AM
HughAJWood
Normalisation of a score in a number range with variable number ranges
I am not sure on the correct method for calculating a normalised value from a data range.

For example:

65 ~ 122
75 ~ 140

The value can be anywhere in those ranges, and I need a single value from 0~1, the ranges have in theory any possible maximum but the score needs to increase with the ranges.

I don't have a math degree only computer science so I am a little limited in my mathematical notation, also note my spelling is because I am English!

Since I use vbscript/vba/excel the most I have managed to write it out in such, and I hope someone can help correct me if I am wrong (I am sure I am).

Score = rand(Min, Max)
Value_Range = abs(Min)+abs(Max)
Normalised_Value = (Score - Min) / Value_Range

Kind regards,
Hugh Wood
• Jan 16th 2012, 01:21 AM
HughAJWood
Re: Noramalisation of a score in a number range with variable number ranges
Okay. Since I have had no replies I will add some details as to what I would mean.

A random score is produced between a range of numbers that can be a undetermined amount.

The number range at one point could be 10 in size (30~40) or it could be 20 in size (40~60) the number range is unknown and is susceptible to change.

A uniform value needs to be calculated for each random score inside that range or any range that always gives a 0~1 value no matter the range numbers or the score.

The higher the score the larger the value needs to be in the 0~1 range.

To me this is the same as normalisation, perhaps I am using the wrong word for this, however getting a unit length of 1 for no matter what the range is to me would be just that.