PERCENTRANK.EXC

Try it

When to use it

When should I use PERCENTRANK.EXC instead of PERCENTRANK.INC?

Use PERCENTRANK.EXC when you want an exclusive percentile rank that excludes the endpoints 0 and 1, making it more appropriate for statistical comparisons where values at the exact minimum or maximum should not be ranked as 0% or 100%.

Used in

science · education

Syntax

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

Examples

=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},5) // => 0.455
=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},3,4) // => 0.2727
=PERCENTRANK.EXC({10,20,30,40,50},10) // => 0.167