COVAR


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.







 
Created with Zapof