PERCENTRANK.INC

Formulas / PERCENTRANK.INC
Calculate 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

    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.

  • =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.


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?
The PERCENTRANK.INC function is used to return the rank of a value in a data set as a percentage of all values in the data set.
How does the PERCENTRANK.INC function work?
The PERCENTRANK.INC function takes two arguments; an array of values and a number that is to be evaluated against the array. The function returns the rank of the number as a percentage of all values in the array.
What happens if the array argument is empty?
The PERCENTRANK.INC function will return a #NUM! error if the array argument is empty.
Can the PERCENTRANK.INC function interpolate?
Yes, the PERCENTRANK.INC function can interpolate to return the correct percentage rank if the x argument does not match one of the values in the array.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV