ReferenceFunctionsStatistics Functions
PERCENTRANK.EXC
PERCENTRANK.EXC: Returns the exclusive percentile rank of `x` within a numeric data array.
Summary
PERCENTRANK.EXC uses an open ranking scale that excludes exact 0 and 1 endpoints.
Remarks
xmust lie within the observed min/max range; otherwise returns#N/A.- Output is based on position divided by
n + 1, with interpolation between points. - Optional
significancedefaults to3and must be at least1. - Returns
#NUM!for invalid setup such as empty numeric input.
Examples
Exact exclusive percentile rank
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.5
Interpolated exclusive percentile rank
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.416
Related functions
Runtime metadata
Category
Statistics
Signature
PERCENTRANK.EXC(arg1, arg2, ... argN: Number (Range))This function accepts a repeating argument pattern (min args: 2).
Arity
min 2, max variadic
Arguments
arg1Number · Range · coercion NumberLenientText
Caps
PURENUMERIC_ONLY
Source