Manuals/calci/PERCENTILE
Jump to navigation
Jump to search
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
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 11 | |||
| Row2 | 23 | |||
| Row3 | 1 | |||
| Row4 | 5 | |||
| Row5 | 15.8 | |||
| Row6 |
