Returns the rank of a value in a data set as a percentage of the data set.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: 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.