I work with groups of scores in the thousands and want to find a method of breaking the whole into percentile ranges and then finding the average of each range.
I can use =average(c1:c60), =average(c61:c120) in each cell up to 100 for a group of 6000, but my problem is that the 6000 is not fixed and will increase over time.
Plus I would like to find the averages for percentile ranges of subsets of varying sizes of the large group.
I'm hoping there is a simple way to do this, but this new user's searches have not found an answer.
Thanks.
Bookmarks