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.