Returns the k-th percentile of values in a range.
構文
PERCENTILE(array, k)引数
array必須
The array or range of data that defines relative standing.
k必須
The percentile value in the range 0 to 1, inclusive.
The PERCENTILE function calculates the value below which a given percentage of data points fall. It is useful for establishing a threshold or identifying relative standing within a dataset.
=PERCENTILE({1,2,3,4,5}, 0.5)→3Returns the median value of the dataset.
Select a cell
Click on the cell where you want the result to appear.
Enter the formula
Type =PERCENTILE( and select your data range, followed by the percentile k value.
Excel interpolates between the two nearest values to determine the percentile.