PERCENTILE(array, Percentilebetween_0_and_1) returns the k-th percentile of values in a range : PERCENTILE « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. PERCENTILE
Input the formula: =PERCENTILE(B2:B5,0.3). Press Enter to get the result.
Input the formula: =PERCENTILE(B2:B5,0.3)
21.56.PERCENTILE
21.56.1.PERCENTILE(array, Percentilebetween_0_and_1) returns the k-th percentile of values in a rangePERCENTILE(array, Percentilebetween_0_and_1) returns the k-th percentile of values in a range