I HAVE BEEN USING STANDARDIZATION IN THE WINDOWS EXCEL.

I WOULD LIKE TO CORRELATE A DESIRED HIGH NUMBER WITH A DESIRED LOW NUMBER. IS A RECIPROCAL OF THE HIGH NUMBER THE SOLUTION.

SAMPLE:


119 1900
123 1600
116 7800
119 1300
119 2000
119 3900
120 3000
120 1900
125 1200

I AM TRYING TO GET A BETTER FIGURE TO USE AS A COMPONENT OF PERCENTILE. I WAS LOOKING FOR A MORE ACCURATE FIGURE, USING THIS INSTEAD OF THE RANKING FIGURE REQUIRED BY PERCENTILE, THE RESULT HAS TO BE FROM ZERO TO ONE, NOTHING MORE THAN ONE AND NOTHING WITH A MINUS RESULT.

THANK YOU FOR ANY SUGGESTIONS.
=======================