Difference between revisions of "Documentation/How Tos/Calc: COVAR function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→Syntax:: corrected formula; change formatting <tt>''' to <code>) |
(→Example:: changed <tt>''' to <code>) |
||
| Line 16: | Line 16: | ||
=== Example: === | === Example: === | ||
| − | < | + | <code>COVAR(A1:A30;B1:B30)</code> |
: returns the covariance of the two sets of data in A1:A30 and B1:B30. | : returns the covariance of the two sets of data in A1:A30 and B1:B30. | ||
Revision as of 17:32, 29 May 2012
COVAR
Returns the covariance of two sets of data.
Syntax:
COVAR(x;y)
- where
xandyare ranges or arrays containing the two sets of data.
COVARcalculates:
- where
and 
are the averages of the ranges xandy.
- where
- 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.
