Sorting by range
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
On Oct 20, 11:50 am, planetdust wrote:
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!
--
planetdust
|