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

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

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!

2. Originally Posted by td3201
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]

3. 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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•