# CFLib.org – Common Function Library Project

## StdDevSamp(values)

##### Last updated September 7, 2001

Version: 1 | Requires: CF5 | Library: MathLib

Description:
Returns the standard deviation calculated using the divisor n-1 method. This method is used when you have values representing a population sample.

Return Values:
Returns a simple value.

Example:

``````<CFSET Values="1,2,3,4,5,6,7,8,9,10">

<CFOUTPUT>
Given <CFIF IsArray(Values)>{#ArrayToList(Values)#}<CFELSE>{#Values#}</CFIF><BR>
The standard deviation for the sample is #StdDevSamp(values)#
</CFOUTPUT>``````

Parameters:

Name Description Required
values Comma delimited list or one dimensional array of numeric values Yes

Full UDF Source:

``````/**
* Returns the standard deviation calculated using the divisor n-1 method.
*
* @param values 	 Comma delimited list or one dimensional array of numeric values
* @return Returns a simple value.
* @author Rob Brooks-Bilson (rbils@amkor.com)
* @version 1.1, September 7, 2001
*/
function StdDevSamp(values)
{
Var MyArray = 0;
Var NumValues = 0;
Var xBar = 0;
Var SumxBar = 0;
Var i=0;
if (IsArray(values)){
MyArray = values;
}
else {
MyArray = ListToArray(values);
}
NumValues = ArrayLen(MyArray);
xBar = ArrayAvg(MyArray);
for (i=1; i LTE NumValues; i=i+1) {
SumxBar = SumxBar + ((MyArray[i] - xBar)*(MyArray[i] - xBar));
}
Return Sqr(SumxBar/(NumValues-1));
}``````

date2ExcelDate
May 5, 2016

CapFirst
April 25, 2016