Variance (PEL)

  • Article

This function calculates the sample variance of a numeric expression evaluated over a scope using the unbiased population formula (dividing by n - 1).

Variance(
    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 a numeric value that is the variance of Numeric_Expression values over the scope Scope_Expression.

Remarks

The Variance function calculates the variance of a population sample by using an unbiased population formula, and the VarianceP (PEL) formula calculates the variance of the whole 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

SQL generation for PEL functions

Other Resources

PEL reference