need math help
 

i'm drawing a blank here.. at the back of my mind i know what the answer is but i can't put it into words

i need to scale a bunch of numbers in terms of a scale of 0-100%

my min number is 5 and my maximum number is 90... what's the formula to break it down? (so 5=0% and 90=100%)

i'm so close i can feel it...

um i'm in calc 3 but never taken stats, i would assume it would have to do with the total spread ? so your total spread is 85...and if you had say 10 of 85 it would be 10/85 = 11.76%

so for example you would add 10 to your min (5) to make it 15. 15 would be 11.76% of your spread? i have no clue.

no, what you're doing is when you're not concerned with min and max and are just working within a set parameter,

in my case, the 5 is the 1% and the 90 is the 100%


did some internet digging.. couldn't find a math formula but i found an excel formula


NewValue = (((OldValue - OldMin) * (NewMax - NewMin)) / (OldMax - OldMin)) + NewMin

lets see if this bitch works

IT WORKS!

good to hear, come back to me when you need calc help haha never took stats :P

Y= m*X+b

You have two data points, (5,0%), (90,100%)

m= 100/85 (rise over run) = 1.1765
b= where the formula hits zero, so take your 'm' value and plug in one of the two points and solve for b

I got the following:
Y=1.1765*X-5.8824