Documentation/How Tos/Calc: COVAR function
From Apache OpenOffice Wiki
COVAR
Returns the covariance of two sets of data.
Syntax:
COVAR(x;y)
- where
x
andy
are ranges or arrays containing the two sets of data.
COVAR
calculates:-
- where and are the averages of the ranges
x
andy
.
- where and are the averages of the ranges
- Advanced topic:
- The function
COVAR(x;y)
is automatically evaluated as array formula.
Example:
COVAR(A1:A30; B1:B30)
- returns the covariance of the two sets of data in A1:A30 and B1:B30.