Excel functions / Statistics
PERCENTRANK.INC function
Where a value stands in a list, from 0 (the lowest) to 1 (the highest).
Syntax
=PERCENTRANK.INC(array, x, [significance])
Arguments
array: The numbers.x: The value to place.significance(optional): How many digits to give (default 3).
When to use it
PERCENTRANK.INC gives the share of the data below a value, from 0 for the lowest to 1 for the highest. A score with a percent rank of 0.75 did better than three quarters of the others.
Examples
Where Ana's score stands
A B C D 1 Name Score 2 Ana 72 50% 3 Ben 48 4 Chloe 90 5 Dev 65 6 Eve 81 In D2:
=PERCENTRANK.INC(B2:B6, B2)→ 50%The top score
A B C D 1 Name Score 2 Ana 72 100% 3 Ben 48 4 Chloe 90 5 Dev 65 6 Eve 81 In D2:
=PERCENTRANK.INC(B2:B6, MAX(B2:B6))→ 100%
Common mistakes
- Argument order. The range comes first and the value second, the reverse of RANK.
PERCENTRANK.INC in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: PERCENTRANK.INC
- Danish: PROCENTPLADS.MEDTAG
- Dutch: PROCENTRANG.INC
- Finnish: PROSENTTIJÄRJESTYS.SIS
- French: RANG.POURCENTAGE.INCLURE
- German: QUANTILSRANG.INKL
- Hungarian: SZÁZALÉKRANG.TARTALMAZ
- Italian: INC.PERCENT.RANGO
- Norwegian: PROSENTDEL.INK
- Polish: PROC.POZ.PRZEDZ.ZAMK
- Portuguese (Brazil): ORDEM.PORCENTUAL.INC
- Portuguese (Portugal): ORDEM.PERCENTUAL.INC
- Russian: ПРОЦЕНТРАНГ.ВКЛ
- Spanish: RANGO.PERCENTIL.INC
- Swedish: PROCENTRANG.INK
- Turkish: YÜZDERANK.DHL
Also written as PERCENTRANK.
Try PERCENTRANK.INC in the playground
Related functions
- PERCENTILE: The value below which a given percentage of the data falls.
- RANK: The position of a number in a list (1 = largest by default).
- PERCENTRANK.EXC: Where a value stands in a list, between 0 and 1 without ever reaching either.
- QUARTILE: A quartile of the data (0 = min, 2 = median, 4 = max).