PERCENTILE

Definition: PERCENTILE is a function that returns the k-th percentile of a set of data.

Syntax: =PERCENTILE(array, k)

Situation: This formula is appropriate when you need to find the k-th percentile of a set of data.

Example: If you have a set of data in array A1:A10, and want to find the 75th percentile, the formula =PERCENTILE(A1:A10, 0.75) can be used.