Covariance (PEL)

This function calculates the population covariance of x-y pairs of values evaluated over the cells specified by a scope expression, by using the biased population formula (dividing by the number of x-y pairs).

Covariance(
        Scope_Expression,
        Numeric_Expression_y 
        [ , Numeric_Expression_x ] 
)

Parameters

  • Scope_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a scope.
  • Numeric_Expression_y
    A valid numeric expression that is typically a PEL expression of cell coordinates that return a number that represents values for the y-axis.
  • Numeric_Expression_x
    A valid numeric expression that is typically a PEL expression of cell coordinates that return a number that represents values for the x-axis.

Return Value

If successful, this function returns a real number value that is the calculated covariance.

Remarks

To get the values for the y-axis, the Covariance function evaluates the cells in the specified scope against Numeric_Expression_y. The function then evaluates the specified scope against Numeric_Expression_x, if specified, to get the scope of values for the x-axis. If Numeric_Expression_x is not specified, the function uses the current context of the cells in the specified scope as values for the x-axis.

The Covariance function uses the biased population formula. To calculate the covariance with an unbiased population formula (dividing the number of x-y pairs, then subtracting 1), use the CovarianceN (PEL) function.

The PEL compiler cannot generate SQL code for this function.

See Also

Reference

CovarianceN (PEL)