StdDev (PEL)
This function calculates the standard deviation of the set of expressions in a scope, based on an unbiased population formula, dividing by n-1.
Stddev(
Scope_Expression
[ , Numeric_Expression ]
)
Parameters
- Scope_Expression
A valid PerformancePoint Expression Language (PEL) expression that returns a scope.
- Numeric_Expression
A valid numeric expression that is typically a PEL expression of cell coordinates that return a number.
Return Value
This function returns the standard deviation of values defined by a scope expression.
Remarks
StdDev uses the unbiased population formula (n-1) to calculate the standard deviation of a population sample, and StdDevP (PEL) calculates the standard deviation of a population.
When this function is used with a single argument, the PEL compiler can always generate SQL code. When the function is used with two arguments, the compiler cannot generate SQL code.
See Also
Reference
StdDevP (PEL)
SQL generation for PEL functions