Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

PERCENTILE(array, Percentilebetween_0_and_1) returns the k-th percentile of values in a range

Input the formula: =PERCENTILE(B2:B5,0.3). Press Enter to get the result.