mm, i was afraid something like that might be the case. 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?
thanks for any continued insight here! -- *John Blythe* Product Manager & Lead Developer 251.605.3071 | j...@curvolabs.com www.curvolabs.com 58 Adams Ave Evansville, IN 47713 On Mon, Dec 19, 2016 at 3:12 PM, Toke Eskildsen <t...@statsbiblioteket.dk> wrote: > John Blythe <j...@curvolabs.com> wrote: > > <long name="count">102</long> > ... > > <long name="countDistinct">6</long> > > 102 values, but only 6 distinct (aka unique): 3900, 3998, 4098, 4200, 4305 > and 4413. > > > <lst name="percentiles"> > > <double name="25.0">4305.0</double> > > <double name="50.0">4413.0</double> > > <double name="75.0">4413.0</double> > > > - the 50th and 75% are the same value as the max > > - the 50th and 75th % are the same number as one another > > That is not a sign of an error. But it does tell us that at least half of > your 102 values are 4413. Forgetting your 25% and your mean value for a > moment, the 102 values could be > 3900, 3998, 4098, 4200, 4305, 4413, 4413, 4413... (94 more repeats of > 4413). > > - Toke Eskildsen >
