- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Statistical - PERCENTRANK.INC Function
Description
The PERCENTRANK.INC function returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. This function can be used to evaluate the relative standing of a value within a data set.
Syntax
PERCENTRANK.INC (array,x,[significance])
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Array | The array or range of data with numeric values that defines relative standing. | Required |
| X | The value for which you want to know the rank. | Required |
| Significance | A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.INC uses three digits (0.xxx). | Optional |
Notes
If x does not match one of the values in array, PERCENTRANK.INC interpolates to return the correct percentage rank.
If array is empty, PERCENTRANK.INC returns the #NUM! error value.
If significance < 1, PERCENTRANK.INC returns the #NUM! error value.
If the supplied x is smaller than the minimum, or greater than the maximum value in the supplied array, PERCENTRANK.INC returns the #N/A error value.
Applicability
Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_statistical_functions.htm
Advertisements