Manuals/calci/PERCENTRANK
Jump to navigation
Jump to search
PERCENTRANK(Array, X ,k)
where,
Array - represents set of data.
X - represents the rank for value.
k - represents the number of significant digit for the returned percentage value.If omitted, it returns 3 digit after decimal point.
It returns the rank for data set as a percentage of the data set.
If k < 1, PERCENTRANK returns the #ERROR.
PERCENTRANK
Lets see an example in (Column2, Row1)
=PERCENTRANK(R1C1:R6C1, 4)
PERCENTRANK returns 0.66667.
Cosider an another example
=PERCENTRANK([1,2,3,4,5,6], -1)
It returns #ERROR(K=-1).
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5 | 0.066667 | ||
| Row2 | 7 | |||
| Row3 | 18 | |||
| Row4 | 23 | |||
| Row5 | 41 | |||
| Row6 | 2 |
