Return the value at a percentile, including the 0th and 100th percentiles.
Syntax
PERCENTILE.INC(array, k)Arguments
arrayrequired
The range of numeric values.
krequired
The percentile between 0 and 1.
PERCENTILE.INC finds the value below which a chosen percentage of observations fall. Use k as a decimal between 0 and 1, such as 0.9 for the 90th percentile.
=PERCENTILE.INC(A2:A100, 0.9)→92Returns the 90th percentile value.
Select the data
Point array at the numeric range to rank.
Enter k
Use 0.25, 0.5, 0.75, or another percentile as a decimal.
Use PERCENTILE.INC for most spreadsheet reporting because it includes the endpoints and works on smaller datasets.