John Blythe <j...@curvolabs.com> wrote: > if the range is 0 to 100 then, for my current purposes, i don't care if the > vast majority of the values are 92, i would want 25%=>25, 50%=>50, and > 75%=>75. so is there an out-of-the-box way to get the percentiles to > correspond to the range itself rather than the concentration of distinct > values?
Then it is not percentiles. And I don't know of any build-in function that returns them directly. But as you have the min and max, you can just do 25%: (max-min)*0.25+min 50%: (max-min)*0.5+min 75%: (max-min)*0.75+min But of course, that won't guarantee that you match the distinct values. If you want that, you'll have to iterate the list of distinct values (hope it's not too large) and pick out the nearest ones. - Toke Eskildsen
