I have millions of scores which range from
0.015 to 244660.58, but I'd like to score them on a scale from
I came up with a
y=m(x)+b linear formula, but most of the scores did not turn out right. The second highest score got a grade of 16 and everything else got a grade < 1. I did not feel it represented the data well:
y=0.000408729764760079(X) + (-0.0000613094647140119)
Eventually, I looked into turning this into a log function and I ended up with this formula (after playing around with wolfram alpha):
This is a reasonable equation, but I'm still finding, however, that it's not representing the scoring correctly.
The problem in my dataset is that most of the scores are greater than 0.15 but less than 1, and the above equation returns -0.04236893409, for example, for a value like
How can I correctly turn my linear function into a log function? How can I better represent than the millions of rows which are less than 1? Any feedback is greatly appreciated.