PERCENTRANK

Returns the rank of a value in a dataset as a percentage (0 to 1) of the dataset

Syntax

PERCENTRANK(data, value, [significance])

Arguments

Argument Description Required
data Array or range of numerical data Required
value Value whose rank you want to find Required
significance Number of significant digits for the result (default 3) Optional

Examples

Rank at 50th percentile

=PERCENTRANK(A1:A5, 3)

Result ⇒0.5
A
1 1
2 2
3 3
4 4
5 5

Interpolated rank between values

=PERCENTRANK(A1:A5, 2.5)

Result ⇒0.375
A
1 1
2 2
3 3
4 4
5 5

With custom significance

=PERCENTRANK(A1:A5, 25, 4)

Result ⇒0.375
A
1 10
2 20
3 30
4 40
5 50

Related Functions

Other Statistical functions:

  • AVEDEV - Returns the average of the absolute deviations of data points from their mean
  • AVERAGE - Returns the average of given arguments. Text is ignored.
  • CORREL - Returns the correlation coefficient between two data sets
  • COUNT - Returns the count of numeric values in a dataset.
  • COUNTA - Returns the count of values in a list of arguments including text, logical values, error values, and empty text.
  • COUNTIF - Returns the count of cells that meet a specified criteria
  • COUNTIFS - Returns the count of criteria_ranges based on the given criterions.
  • FORECAST - Calculates, or predicts, a future value by using existing values
  • LARGE - Returns the k-th largest value in a data set
  • MAX - Returns the largest number from the provided arguments
  • MEDIAN - Returns the median of the given numbers
  • MIN - Returns the smallest number from the provided arguments
  • MINIFS - Returns the minimum value from a range that meets multiple criteria.
  • MODE - Returns the most frequently occurring value in a data set
  • PERCENTILE - Returns the k-th percentile of values in a range
  • RANK - Returns the rank of a number from the list of other numeric values
  • SMALL - Returns the k-th smallest value in a data set
  • STDEV - Returns the estimated standard deviation based on a sample
  • STDEVP - Calculates standard deviation based on the entire population
  • SUMIF - Returns the sum of a range depending on criteria
  • SUMPRODUCT - Returns the sum of products for a list of arguments
  • VAR - Returns the estimated variance for a sample of data
  • VARP - Calculates variance based on the entire population