Returns the covariance of two sets of data.
Syntax:
COVAR(x, y)
where x and y are ranges or arrays containing the two sets of data.
COVAR calculates:
where and are the averages of the ranges x and y.
Example:
COVAR(A1:A30, B1:B30)
returns the covariance of the two sets of data in A1:A30 and B1:B30.