Returns the population covariance of x-y pairs of values evaluated over a set, by using the biased population formula (dividing by the number of x-y pairs).
The Covariance function evaluates the specified set against the first numeric expression, to get the values for the y-axis. The function then evaluates the specified set against the second numeric expression, if specified, to get the set of values for the x-axis. If the second numeric expressionis not specified, the function uses the current context of the cells in the specified set as values for the x-axis.
The Covariance function uses the biased population formula. This is in contrast to the CovarianceN function that uses the unbiased population formula (dividing the number of x-y pairs, then subtracting 1).
The Covariance function ignores empty cells or cells that contain text or logical values are ignored. However, the function includes cells with values of zero.