Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic


SQL Server 2000


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


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


This function 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.

The CovarianceN function uses the unbiased population formula, while the Covariance function uses the biased population formula.

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.