Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > PERCENTRANK
 

PERCENTRANK(array, x [,significance])

 
 Returns the rank of a value in a data set as a percentage of the data set.

 arrayThe array of values.
 xThe value for which you want to know the rank.
 significanceThe number of significant digits for the returned percentage value.

 REMARKS
 
  		• Returns the rank of a value in a data set as a percentage of the data set.
     
  		• If "array" is empty, then #NUM! is returned.
     
  		• If "significance" < 1, then #NUM! is returned.
     
  		• If "significance" is left blank", then 3 is used (i.e. 0.xxx%).
     
  		• If "x" does not match one of the values in array, the functions interpolates to return the correct percentage rank.
     
  		• This function can be used to evaluate the relative standing of a value within a data set. For example, you can use PERCENTRANK to evaluate the standing of an aptitude test score among all scores for the test.

     EXAMPLES
     
     A
    1=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},4) = 0.333
    2=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},1) = 0
    3=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},7) = 0.666
    4=PERCENTRANK({2,4,6,8,10,12,14,16},7) = 0.357
    5=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},15) = #N/A
    6=PERCENTRANK({1,2,3,4,5,6,7,8,9,10},"some text") = #VALUE!
    		 
     Functions - P | Index - P | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top