CFLib.org – GetPercentile

GetPercentile(pctile, range)

Last updated January 7, 2003

author

Kreig Zimmerman
Send Email

Version: 2 | Requires: ColdFusion 5 | Library: MathLib

Rated 0 time(s). Average Rating: 0

Description:
GetPercentile is a UDF provided for the purpose of getting a statistically valid percentile from a comma-delimited list of values. When this list is passed in, the UDF will sort the values within an array, and then, using the percentile value passed in (0-100) grab the statistically valid value that corresponds to said percentile.

Return Values:
Returns a number.

Example:

<cfscript>
jack=GetPercentile(25, '12,10,20,14');
WriteOutput(jack);
</cfscript>

Parameters:

Name	Description	Required
pctile	Percentile	Yes
range	List of numeric values.	Yes

Full UDF Source:

	
	<cfscript>
/**
 * Function which gets the value corresponding to a certain percentile from a list of numeric values.
 * Error in second to last line.
 * 
 * @param pctile      Percentile (Required)
 * @param range      List of numeric values. (Required)
 * @return Returns a number. 
 * @author Kreig Zimmerman (kreig303@yahoo.com) 
 * @version 2, January 7, 2003 
 */
function GetPercentile(pctile, range) {
  var rangeArr = ListToArray(range);
  var rangepoint = "";
  pctile = pctile * .01;
  ArraySort(rangeArr, "numeric");
  rangePoint = Max(Round(ArrayLen(rangeArr)*pctile), 1);
  return rangeArr[rangePoint]; 
}
</cfscript>