Returns the rank of a value in a data set as a percentage of the data set.
ไวยากรณ์
PERCENTRANK(array, x, [significance])อาร์กิวเมนต์
arrayจำเป็น
The array or range of data with numeric values.
xจำเป็น
The value for which you want to find the rank.
significanceไม่บังคับ
The number of significant digits for the returned percentage value.
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.5The value 3 is exactly in the middle of the set, representing the 50th percentile.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =PERCENTRANK( followed by your data range, the target value, and optional significance.
PERCENTRANK is included for compatibility with older versions; PERCENTRANK.INC is the modern equivalent that includes the bounds of the array.