COVAR(array1, array2)

The COVAR function calculates the covariance between two sets of data. This is a measure of the average of the products of deviation for matching pairs from two arrays.

The function arguments should contain numbers or refer to ranges containing numbers, and should have a matching number of data points.

See also:

Other statistical functions