Returns the correlation coefficient of x-y pairs of values evaluated over a set.
The Correlation function calculates the correlation coefficient of two pairs of values by first evaluating the specified set against the first numeric expression to obtain the values for the y-axis. The function then evaluates the specified set against the second numeric expression, if present, to obtain the set of values for the x-axis. If the second numeric expression is not specified, the function uses the current context of the cells in the specified set as the values for the x-axis.
The Correlation function ignores empty cells or cells that contain text or logical values. However, the function includes cells with values of zero.