Manuals/calci/PERCENTILE

PERCENTILE(Array, k)

where,

Array - is the set of data.

k - represents the percentile in between 0 and 1 inclusive.

Returns thethe k-th percentile of value from set of data.

If k is nonnumeric, PERCENTILE returns #ERROR.

If k< 0 or k > 1, it returns #ERROR.

PERCENTILE

Lets see an example in (Column1, Row5)

=PERCENTILE(R1C1:R4C1,0.8)

PERCENTILE returns 80-th of given array is 15.8.

Syntax

Remarks

Examples

Description