PERCENTILE

PERCENTILE determines the 100*k-th percentile of the given data points

Synopsis

PERCENTILE(array,k)

Arguments

array: data points

k: which percentile to calculate

Note

If array is empty, this function returns a #NUM! error. If k < 0 or k > 1, this function returns a #NUM! error.

Microsoft Excel Compatibility

This function is Excel compatible.

See also

QUARTILE.