StdDev (PEL)

  • Article

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

Other Resources

PEL reference