CovarianceN (PEL)
This function calculates the sample covariance of x-y pairs of values evaluated over the cells specified in a scope expression, by using the unbiased population formula (dividing by the number of x-y pairs).
CovarianceN(
Scope_Expression,
Numeric_Expression_y
[ , Numeric_Expression_x ]
)
Parameters
- Scope_Expression
A valid PerformancePoint Expression Language (PEL) expression that represents 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 that is the covariance computed on an unbiased population.
Remarks
To get the values for the y-axis, the CovarianceN function evaluates cell values from the specified scope against Numeric_Expression_y. The function then evaluates the specified cells against Numeric_Expression_x, if specified, to get the set 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 CovarianceN function uses the unbiased population formula. This differs from the Covariance (PEL) function that uses the biased population formula (dividing by the number of x-y pairs).
The PEL compiler cannot generate SQL code for this function.