# percentile

## 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). If the percentage falls between two observations, interpolates linearly between the two.

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)


## percentile(T.a : date; b : number) 🡒 date, 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). If the percentage falls between two observations, interpolates linearly between the two.

table T = with
[| as A |]
[| date(2013,10, 8) |]
[| date(2016, 7,27) |]
[| date(2011, 6,11) |]
[| date(2011, 5,15) |]

show summary "" a1a4 with
percentile(T.A; 0.25)
percentile(T.A; 0.50)
percentile(T.A; 0.75)
percentile(T.A; 1.0)


## percentile(T.a : week; b : number) 🡒 week, 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). If the percentage falls between two observations, interpolates linearly between the two.

table T = with
[| as A |]
[| week(2013,27) |]
[| week(2016,13) |]
[| week(2011, 8) |]
[| week(2011,11) |]

show summary "" a1a4 with
percentile(T.A; 0.25)
percentile(T.A; 0.50)
percentile(T.A; 0.75)
percentile(T.A; 1.0)


## percentile(T.a : month; b : number) 🡒 month, 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). If the percentage falls between two observations, interpolates linearly between the two.

table T = with
[| as A |]
[| month(2013,10) |]
[| month(2016, 7) |]
[| month(2011, 6) |]
[| month(2011, 5) |]

show summary "" a1a4 with
percentile(T.A; 0.25)
percentile(T.A; 0.50)
percentile(T.A; 0.75)
percentile(T.A; 1.0)


## percentile(T.a : text; b : number) 🡒 text, 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). Observations are sorted in lexicographical order. If the percentage falls between two observations, the lower of the two is taken.

table T = with
[| as A     |]
[| "A runner"  |]
[| "B mainstream" |]
[| "C slow mover" |]