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

Correlation

SQL Server 2000

Correlation

Returns the correlation of two series evaluated over a set.

Syntax

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

Remarks

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.

Show:
© 2015 Microsoft