Help with conditional formatting with 2000

  • Thread starter Thread starter agroves
  • Start date Start date
A

agroves

Any help would be greatly appreciated.

I am trying to group data together into increments of 10% of th
numbers and then chart them based on these groups. For example, I hav
300 data points that vary from 20 to 500 in value. I want them t
appear in a chart based on the number of values that fall in the lowes
10% of numbers (ie. 20-40) then the next 10% (ie. 40-60) etc. up to th
top 10% of numbers, but I do not want to manually determine what thes
ranges are. I want to see a distribution of how many numbers fal
within each 10% of values.

I am not sure if this makes sense, please let me know if you have an
ideas or need further clarification.

Thank you very much.

AK
 
Any help would be greatly appreciated.

I am trying to group data together into increments of 10% of the
numbers and then chart them based on these groups. For example, I have
300 data points that vary from 20 to 500 in value. I want them to
appear in a chart based on the number of values that fall in the lowest
10% of numbers (ie. 20-40) then the next 10% (ie. 40-60) etc. up to the
top 10% of numbers, but I do not want to manually determine what these
ranges are. I want to see a distribution of how many numbers fall
within each 10% of values.

I am not sure if this makes sense, please let me know if you have any
ideas or need further clarification.

Thank you very much.

AKG
Click to expand...

Take a look at the Histogram tool.
--ron
 
Back
Top