Results 1 to 2 of 2

Math Help - Noramalisation of a score in a number range with variable number ranges

  1. #1
    Newbie
    Joined
    Jan 2012
    Posts
    3

    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
    Last edited by HughAJWood; January 11th 2012 at 04:10 AM.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Jan 2012
    Posts
    3

    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.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Range of a 3-digit number set is 000-999
    Posted in the Statistics Forum
    Replies: 4
    Last Post: February 15th 2011, 10:25 PM
  2. Replies: 7
    Last Post: April 13th 2009, 03:57 AM
  3. translate number range to percentage
    Posted in the Pre-Calculus Forum
    Replies: 1
    Last Post: March 12th 2008, 10:56 AM
  4. translate number range to percentage
    Posted in the Statistics Forum
    Replies: 1
    Last Post: March 12th 2008, 10:52 AM
  5. [SOLVED] range of number of tries
    Posted in the Advanced Math Topics Forum
    Replies: 1
    Last Post: November 30th 2005, 01:32 AM

Search Tags


/mathhelpforum @mathhelpforum