SOLUTION: Can you please help me to come up with a formula for transmuting raw scores into percentages the conditions are :(lowest possible score is zero and its equivalent is 85% and the hi

Algebra ->  Subset -> SOLUTION: Can you please help me to come up with a formula for transmuting raw scores into percentages the conditions are :(lowest possible score is zero and its equivalent is 85% and the hi      Log On


   

Question 982007: Can you please help me to come up with a formula for transmuting raw scores into percentages the conditions are :(lowest possible score is zero and its equivalent is 85% and the highest possible score is 100 and its equivalent is 100% only. using excel formulas please!!! thank you.)
Answer by josgarithmetic(39620) About Me  (Show Source):
You can put this solution on YOUR website!
The description suggests a linear relationship. This can define two data points as (x,y); x being the raw percentage score, y being the rescaled score.

These points are (85,0) and (100,100).

Next objective is find the equation of the line which contains these two points.
m=%28100-0%29%2F%28100-85%29=100%2F15=20%2F3

Pick any or either point:
point-slope form line, y-100=%2820%2F3%29%28x-100%29
y-100=20x%2F3-2000%2F3
y=%2820%2F3%29x%2B100-2000%2F3
y=%2820%2F3%29x%2B300%2F3-2000%2F3
highlight%28y=%2820%2F3%29x-1700%2F3%29 or highlight%28y=%2820%2F3%29x-566%262%2F3%29