Documentation/How Tos/Calc: COVAR function

CALC FUNCTIONS

FUNCTIONS

Measures of Central Tendency

Measures of dispersion / spread

Probability and statistics

Correlation and line fitting

See also (in the Array Function category); GROWTH, LINEST, LOGEST, TREND

Ranking

COVAR

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