Manuals/calci/PERCENTRANK

PERCENTRANK (Array,Number,Significance)


  • is the set of data and is the value to find the rank.
    • PERCENTRANK(),returns the percentage rank of a value in a data set.

Description

  • This function gives the percentage rank of a value in a given set of numbers.
  • To calculate the relative standing of a data set we can use this function.
  • For example, a test score that is greater than or equal to 50% of the scores of people taking the test is said to be at the 50th percentile rank.
  • Percentile ranks are commonly used to clarify the interpretation of scores on standardized tests.
  • To find the percentile rank of a score is : 

Where,   = Number of below rank,   = Number of same rank,   = Total numbers.

  • In  ,   is the array of numeric values and   is the value to find the rank.
  • This function gives the result as error when array is empty .

Examples

1.

Spreadsheet
A B C D E
1 3 4 1 2 1
=PERCENTRANK(A1:E1,2) = 0.5

2.

Spreadsheet
A B C D E F
1 7 6 2 5 9 1
=PERCENTRANK(A1:F1,3) = 0.267

Related Videos

PERCENTRANK

See Also

References

Percentile Rank