CovarianceN

Return to: Calculated Member Builder Function List

Returns the covariance of two series evaluated over a set using the unbiased population formula.

Syntax

Covariance(«Set», «Numeric Expression»[, «Numeric Expression»])

Remarks

Evaluates «Set» against the first «Numeric Expression» to get the values for the y-axis. «Set» is evaluated against the second «Numeric Expression», if present, to get the set of values for the x-axis. If the second «Numeric Expression» is not present, the members of «Set» are used as values for the x-axis.

CovarianceN uses the unbiased population formula. Covariance uses the biased population formula.


Note Empty cells or cells containing text or logical values are ignored; however, cells with zero values are included.


(c) 1988-1998 Microsoft Corporation. All Rights Reserved.