PERCENTRANK
Formulas / PERCENTRANKCalculate 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?
How does the PERCENTRANK function work?
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
