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.
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
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.