PERCENTILE

Syntax:

PERCENTILE ( array , k )

Description: Computes the kth percentile of a set of values in a range.

Arguments:

Name

Type

Description

array

array, reference

The set of numerical data that defines relative standing.

k

number

The percentile value in the range 0–1, inclusive. If k is not a multiple of 1/(n - 1), PERCENTILE interpolates to determine the value at the kth percentile.

Return Type and Value: number – The kth percentile of a set of values in a range.

However, if

  • array is empty, the return value is unspecified.

  • k is < 0 or > 1, #NUM! is returned.

example: