PERCENTRANK(array,x,optional_significance) returns the percentage rank of a value in a data set : PERCENTRANK « Statistical functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =PERCENTRANK(B2:B11,2). Press Enter to get the result.
Input the formula: =PERCENTRANK(B2:B11,2)
21.57.PERCENTRANK
21.57.1.PERCENTRANK(array,x,optional_significance) returns the percentage rank of a value in a data setPERCENTRANK(array,x,optional_significance) returns the percentage rank of a value in a data set