- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel/Math question
Posted on 3/20/18 at 6:43 pm
Posted on 3/20/18 at 6:43 pm
I have a number range from 2.58 to 5.88, the lower value should be ranked the highest. I want to put this range on a 1 to 100 scale.
Example 2.58 equals 100 and 5.88 equals 1, and the numbers in between falling somewhere in the range.
I'm dumb, appreciate the help
I know the formula for descending rank is =A1*100/max value, but i need the inverse
Example 2.58 equals 100 and 5.88 equals 1, and the numbers in between falling somewhere in the range.
I'm dumb, appreciate the help
I know the formula for descending rank is =A1*100/max value, but i need the inverse
This post was edited on 3/20/18 at 6:48 pm
Posted on 3/20/18 at 6:44 pm to LSUTigerBait07
Use an abacus. Trust me on this.
Posted on 3/20/18 at 6:44 pm to LSUTigerBait07
Change your number range to be from 1 to 100 and you’re golden.
Posted on 3/20/18 at 6:44 pm to LSUTigerBait07
quote:
. I want to put this range on a 1 to 100 scale.
What's stopping you?
Posted on 3/20/18 at 6:45 pm to LSUTigerBait07
Just set all values to 3.50
Posted on 3/20/18 at 6:45 pm to LSUTigerBait07
The answer is 3 dipshit.
Posted on 3/20/18 at 6:46 pm to LSUTigerBait07
You want to rank it?
Formula for that
=RANK(number being ranked, range of numbers being ranked,1)
The 1 value will reverse rank it so the lowest number is ranked highest.
Edit: your edit made what you want clearer. My post probably isn't what you need.
Formula for that
=RANK(number being ranked, range of numbers being ranked,1)
The 1 value will reverse rank it so the lowest number is ranked highest.
Edit: your edit made what you want clearer. My post probably isn't what you need.
This post was edited on 3/20/18 at 6:50 pm
Posted on 3/20/18 at 6:46 pm to Winston Cup
quote:
Just set all values to 3.50
Approximately.
Posted on 3/20/18 at 6:46 pm to LSUTigerBait07
Any more info? How many numbers in the range? What's the significance of the 1-100 scale?
Posted on 3/20/18 at 6:48 pm to LSUTigerBait07
=(x-2.58)/(5.88-2.58)*99+1
Posted on 3/20/18 at 6:49 pm to LSUTigerBait07
Make a column that goes from 1 to 100
B1 will then be
=5.88 + 3.3*(A1-1)/99
Pull that formula down
B1 will then be
=5.88 + 3.3*(A1-1)/99
Pull that formula down
Posted on 3/20/18 at 6:50 pm to slackster
700 numbers in the data set, 1 to 100 is arbitrary. I have several other columns with vastly higher values and trying to value them the same
Posted on 3/20/18 at 6:51 pm to LSUTigerBait07
quote:
700 numbers in the data set, 1 to 100 is arbitrary. I have several other columns with vastly higher values and trying to value them the same
What not convert everything to percent values?
This post was edited on 3/20/18 at 6:52 pm
Posted on 3/20/18 at 6:51 pm to LSUTigerBait07
My formula above is generalizable for any number of samples (n)
It’s just be instead of dividing by 99 at the end, divide by n-1
It’s just be instead of dividing by 99 at the end, divide by n-1
Posted on 3/20/18 at 6:52 pm to GetCocky11
quote:
What not convert everything to percent values?
Why not z-scores?
Posted on 3/20/18 at 6:59 pm to LSUTigerBait07
quote:
700 numbers in the data set, 1 to 100 is arbitrary. I have several other columns with vastly higher values and trying to value them the same
PercentRank might help.
However, would figuring out the standard deviation make more sense, especially if trying to compare vastly different sets of data?
Popular
Back to top
Follow TigerDroppings for LSU Football News