Difference between revisions of "Documentation/How Tos/Calc: COVAR function"

Latest revision as of 14:41, 2 February 2024

FUNCTIONS

Spreadsheet Lookup functions

Measures of dispersion / spread

Probability and statistics

Correlation and line fitting

See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND

Ranking

Returns the covariance of two sets of data.

COVAR(x;y)

where x and y are ranges or arrays containing the two sets of data.

COVAR calculates:

\text{[math]}

where

\text{[math]}

and

\text{[math]}

are the averages of the ranges x and y.

Advanced topic:

The function COVAR(x;y) is automatically evaluated as array formula.

COVAR(A1:A30;B1:B30)

returns the covariance of the two sets of data in A1:A30 and B1:B30.

See Also

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{DISPLAYTITLE:COVAR function}}
+{{Documentation/CalcFunc StatisticalTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_CORREL_function
+|NextPage=Documentation/How_Tos/Calc:_FORECAST_function
+}}__NOTOC__
 == COVAR ==
@@ Line 19: / Line 24: @@
 : returns the covariance of the two sets of data in A1:A30 and B1:B30.
-{{Documentation/SeeAlso|
+{{SeeAlso|EN|
 * [[Documentation/How_Tos/Calc: CORREL function|CORREL]]
 * [[Documentation/How_Tos/Calc: PEARSON function|PEARSON]]