Functions
PERCENTILE
k-th percentile (inclusive)
Try it
When to use it
When should I use PERCENTILE?
Use PERCENTILE to find the value below which a given fraction of your data falls — for example, the 90th-percentile response time, or the median (50th percentile) of a score distribution. PERCENTILE is the inclusive form: k=0 and k=1 are valid.
Used in
Syntax
PERCENTILE(array,k)Examples
=PERCENTILE({1,2,3,4,5,6,7,8,9,10},0.5) // => 5.5
=PERCENTILE({1,2,3,4,5,6,7,8,9,10},0.67) // => 7.03