PERCENTILE.EXC returns the k-th percentile but treats 0 and 1 as out of range. On small samples its results sit slightly wider than PERCENTILE.INC, which is why two analysts can report different “90th percentile” numbers from the same data.
Syntax
=PERCENTILE.EXC(array, k)
Argument
What it means
array
Numbers.
k
Between 0 and 1, exclusive.
Examples
Example 1
=PERCENTILE.EXC(C2:C200, 0.9)
90th-percentile delivery time.
Common errors and fixes
You see
Why, and the fix
#NUM!
k is too close to 0 or 1 for the number of values (e.g. k=0.99 on 20 values).
