PERCENTRANK.EXC

PERCENTRANK.EXC(array, x [,significance])

Returns the rank of a value as a percentage (exclusive).

arrayThe array of values.
xThe value for which you want to know the rank.
significance(Optional) The number of significant digits for the returned percentage value.

REMARKS
* If "array" is empty, then #NUM! is returned.
* If "significance" < 1, then #NUM! is returned.
* If "significance" is left blank", then 3 is used (i.e. 0.xxx%).
* If "x" does not match one of the values in array, the functions interpolates to return the correct percentage rank.
* You can use the PERCENTILE.EXC function to return the number corresponding to a particular percentage from an array of numbers (exclusive).
* You can use the PERCENTRANK.INC function to return the percentage rank of a value in an array of numbers (inclusive).
* You can use the QUARTILE.EXC function to return the quartile of a data set (exclusive).
* You can use the RANK.EQ function to return the rank of a value in descending order (equal ranking).
* You can use the RANK.AVG function to return the rank of a value in descending order (average ranking).
* This function was added in Excel 2010
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=PERCENTRANK.EXC({1,2,3, 4,5,6,7,8,9,10},1) = 0.090
2=PERCENTRANK.EXC({1,2,3, 4,5,6,7,8,9,10},1.5) = 0
3=PERCENTRANK.EXC({1,2,3, 4,5,6,7,8,9,10},2) = 0.181
4=PERCENTRANK.EXC({1,2,3, 4,5,6,7,8,9,10},3) = 0.272
5=PERCENTRANK.EXC({1,2,3, 4,5,6,7,8,9,10},4) = 0.363
6=PERCENTRANK.EXC({1,2,3, 4,5,6,7,8,9,10},9) = 0.818
7=PERCENTRANK.EXC({1,2,3, 4,5,6,7,8,9,10},10) = 0.909
8=PERCENTRANK.EXC({1,2,3, 4,5,6,7,8,9,10},15) = #N/A
9=PERCENTRANK.EXC({1,2,3, 4,5,6,7,8,9,10},"some text") = #VALUE!


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top