Sorting by range

  • Thread starter Thread starter planetdust
  • Start date Start date
P

planetdust

Hi everyone!

I'm looking for hints on the following:
I have a list with a large number of values and I would like to sort
these into four groups by size.

Thanks in advance!
 
And what would be the lower and upper ranges of size?

Or you just want 4 equal sized groups?

Like 1 through 12 would be grouped 1-4, 5-8 amd 9-12


Gord Dibben MS Excel MVP
 
The groups would be minimum value to 1/4 of the max. value, 1/4 of the
max. value to 2/4 of the max. value, 2/4 of the max. value to 3/4 of
the max. value, and finally 3/4 of the max. value to the max. value. I
suppose, that the number of values that end up in each group will be
different.
Sorting in ascending order by size shows, that the minimum value in
this specific list is 0,01841 and the max. is 0,05388.
 
Perhaps you can use MAX to find the largest number in your range, MIN
to find the smallest number, so the difference between these will give
you the total range of numbers. Dividing by 4 will give you the range
of numbers within each group (if you wanted to categorise them this
way). So, if your minimum was -10 and your maximum was 200, each group
would be (200 - -10)/4 wide, i.e. 210/4 or 52.5. So, your first group
would be from -10 to 42.5, second group 42.5 to 95, third group 95 to
147.5 and final group 147.5 to 200.

Of course, you might want to group them by frequency and have the same
number of values within each group ...

Hope this helps.

Pete
 
Back
Top