plotting a number on a new scale: 10 = 100 9 = 93 8 = 86 7 = 79 6 = 72 5= 65

td3201

New member
Joined
Nov 25, 2017
Messages
4
I have a series of numbers between 5 and 10. I want to plot them on a new scale from 65-100 (yes a grade). I'm doing this in excel. Can someone help me with a formula?

Here's roughly how things should work out but I'd like a formula to automate it as there are going to be decimals involved.

10 = 100
9 = 93
8 = 86
7 = 79
6 = 72
5= 65

Thanks!
 

Subhotosh Khan

Super Moderator
Staff member
Joined
Jun 18, 2007
Messages
18,184
I have a series of numbers between 5 and 10. I want to plot them on a new scale from 65-100 (yes a grade). I'm doing this in excel. Can someone help me with a formula?

Here's roughly how things should work out but I'd like a formula to automate it as there are going to be decimals involved.

10 = 100
9 = 93
8 = 86
7 = 79
6 = 72
5= 65

Thanks!
Plot it in x-y plane - and you'll see the relationship! Make the domain [5,10] and range [100,65]
 
Last edited:

td3201

New member
Joined
Nov 25, 2017
Messages
4
Here's the excel formula:

=(((G2-5))*(100-65)/((1*10)-5))+65

G2 = the value you're evaluating
5 = bottom of that number's range
10 = top of that number's range
100 = top of new range
65 = bottom of new range
 
Top