percentile(T.a : number; b : number) 🡒 number, aggregator
Returns the value below which the given percentage of observations in the group of observations falls. The second argument must be between 0 and 1 (inclusive).
table T = with [| as A |] [| 0 |] [| 0 |] [| 1 |] [| 2 |] show summary "" a1a4 with percentile(T.A; 0.25) percentile(T.A; 0.50) percentile(T.A; 0.75) percentile(T.A; 1.0)
- The PERCENTILE.INC function in Excel.