Converting data to a specified range

[Ronni]

Hi,

I am trying to convert data to a particular range of 0-10.

Actual Data may vary from - 50000 - 26214400. I have broken this down into 4 parts as follows -

50000 - 1048576 -----> 0 - 2.5
1048577 - 5242880 -----> 2.6 - 5
5242881 - 15728640 ----->5.1 - 7.5
15728641 - 26214400 ----->7.6 - 10

How can i convert this data ? Is there any formula to do this? I found a way to normalize data to a range of [ 0 - 1 ] but am not able to apply the same to this.

 

[HallsofIvy]

Your numbers range from 50000 to 26214400? (I'm no certain if that is a dash or a negative in front of the "5000".

First subtract 50000 from each of your numbers to get them between 0 and 26214400- 50000= 26164400.
If you now divide each of your numbers by 26164400 they will be between 0 and 1. Is that what you say you can do? To get them between 0 and 10, now multiply by 10 which is the same as having divided by 2616440 instead of 26164400.

 

[Ronni]

That is a dash.
This converting of whole data to a range of 0-10 is ok but the intervals are irregular that's why i divided the data into the mentioned intervals.