apoc icon indicating copy to clipboard operation
apoc copied to clipboard

Strange behavior of apoc.agg.statistics

Open ivan-kleshnin opened this issue 1 year ago • 4 comments

apoc.agg.statistics looks broken. At least with custom percentiles:

Screenshot 2023-11-13 at 13 41 24

Pls. correct me if I'm wrong. To my understanding, passing 0.1 percentile is a request to evaluate a threshold between lowest 10% of the population and the rest of the population. 0.5 percentile is a median.

There's no way in which values for 0.1 and 0.25 could be below (or even equal to) min.

Is it a rounding issue went too far or what? There's a large dispersion, yes, but median & other percentiles should be unaffected by outliers 🤔

ivan-kleshnin avatar Nov 13 '23 10:11 ivan-kleshnin