PERCENTILE.INC Function Explained
The PERCENTILE.INC Function in Microsoft Excel calculates the kth percentile of a given set of values. It takes two arguments: an array of values and the percentile value (k) to be calculated. The function returns the kth percentile of the given array of values.
PERCENTILE.INC Function Syntax
PERCENTILE.INC(array, k)
- array: The array or range of data for which you want to determine the k-th percentile.
- k: The percentile value that you want to find. This number must be between 0 and 1.