StdDevP (PEL)

  • Article

This function calculates the standard deviation of set of expressions in a scope, based on a biased population formula, dividing by n.

StddevP(
    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 the values defined in a scope.

Remarks

StdDevP uses a biased population formula (dividing by n) to calculate the standard deviation of a population, and StdDev (PEL) calculates the standard deviation of a population sample.

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

StdDev (PEL)
SQL generation for PEL functions

Other Resources

PEL reference