PERCENTILE.EXC Function Explained
The PERCENTILE.EXC Function in Microsoft Excel calculates the kth percentile for a set of data. It returns the kth percentile, where k is a number between 0 and 1. The PERCENTILE.EXC Function takes two arguments: an array of numbers and the kth percentile to calculate.
PERCENTILE.EXC Function Syntax
PERCENTILE.EXC(array, k)
- array: The array or range of data that is to be evaluated.
- k: The percentile value that is to be found in the array or range of data.