PERCENTRANK

Formulas / PERCENTRANK
Calculate the percentile rank of a value in a data set.
=PERCENTRANK(array, x, [significance])
  • array - range of data defining relative standing
  • x - value to find its rank in
  • significance - [OPTIONAL] parameter used to determine the number of significant digits to round the result

Examples

  • =PERCENTRANK(A2:A11,2)

    PERCENTRANK is a Sourcetable function used to calculate the rank of a value in a dataset relative to other values in the same dataset. In the example given, , the function will return the percent rank of the value 2 within the range A2:A11. This means that 2 is ranked at what percent of the values in the range A2:A11. This function is useful for finding the rank of a number within a dataset without having to manually calculate it.

  • =PERCENTRANK(A2:A11,4)

    The PERCENTRANK function can also be used to find the relative rank of multiple values within a dataset. For example, this will return the percent rank of the value 4 within the range A2:A11.

    • The PERCENTRANK function can also be used to compare the relative rank of different values within a dataset.

Summary

The PERCENTRANK function is used to measure the relative standing of a value in a data set as a percentage. It can be used to compare the rank of a value with other values in the data set and new functions can provide improved accuracy.

  • The PERCENTRANK function returns a calculated rank as a decimal value, and is commonly used to interpret a value's standing in standardized tests.
  • The array and x arguments are both required, while the significance argument is optional.


Frequently Asked Questions

What is the PERCENTRANK function?
The PERCENTRANK function is a statistical function that returns the rank of a value in a data set, expressed as a percentage. This function can be used to evaluate the relative standing of a value within a data set.
How does the PERCENTRANK function work?
The PERCENTRANK function returns the rank of a value in a data set as a percentage of all the values in the data set. This is done by determining the proportion of values in the data set that are less than or equal to the value being evaluated.
What are the benefits of using the PERCENTRANK function?
  • Improved accuracy
  • Ability to quickly evaluate the relative standing of a value within a data set
  • Simple and easy to use

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