PERCENTRANK.INC
Formulas / PERCENTRANK.INCCalculate the relative rank of a value in a data set as a percentage.
PERCENTRANK.INC(array, x, [significance])
- array - required, an array of data values
- x - required, the value to rank
- significance - [OPTIONAL] number of significant digits in the result
Examples
=PERCENTRANK.INC(A2:A11,8)The function can also be used to find the percent rank of a value that is not among the values in the range. For example, if the range A2:A11 contains the values 1, 2, 3, 4, 5, 6, 7, 8, 9, and 10, then the PERCENTRANK.INC function can be used to calculate the percent rank of 8 in the range. The formula would return 0.889. This is because 8 is the 8th value in the range when counting from the leftmost column.
The function can be used to find a given value's rank in a range of values. For example, if the range A2:A11 contains the values 1, 2, 3, 4, 5, 6, 7, 8, 9, and 10, then the PERCENTRANK.INC function can be used to calculate the percent rank of 2 in the range. The formula would return 0.333. This is because 3 of the values in the range are smaller than 2, and 6 of the values in the range are larger than 2; 3 divided by (3+6) is 0.333.
Summary
The PERCENTRANK.INC function is used to calculate the relative rank of a value within a data set. It returns the rank of a value as a percentage of the whole set and can interpolate if the value does not match one of the values in the array. It returns a #NUM! error if the array is empty.
- The PERCENTRANK.INC function calculates the relative rank of a value in a data set as a percentage, which is used to interpret standing in standardized tests. The arguments for this function are array (required), x (required), and significance (optional). It will calculate the rank as a decimal value.
Frequently Asked Questions
What is the PERCENTRANK.INC function?
How does the PERCENTRANK.INC function work?
What happens if the array argument is empty?
Can the PERCENTRANK.INC function interpolate?
