Returns the rank of a value in a data set as a percentage of the data set.
Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.
PERCENTRANK(array, x, [significance])The PERCENTRANK function calculates the relative standing of a value within a data set. It is useful for evaluating the relative position of a specific data point compared to the rest of the array.
=PERCENTRANK({1, 2, 3, 4, 5}, 3)Resultaat: 0.5
The value 3 is exactly in the middle of the set, representing the 50th percentile.
PERCENTRANK is included for compatibility with older versions; PERCENTRANK.INC is the modern equivalent that includes the bounds of the array.