Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All


SQL Server 2000


Returns the correlation of two series evaluated over a set.


Correlation(«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.

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

© 2015 Microsoft