I have a range in one column of numbers. I don't want to average the whole range of numbers (~1500 entries), I want to know if there is a way to average a certain percentile.
so for instance if out of the 1500 numbers 160 of them are the top 10% How would I do this?
or If I wanted to know what the average is of the percentile between 10% - 15%.
I imagine that there is a formula where based on my icon set I could specify what the averages for each set of the icon set (that would also be helpful).