COVAR function

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

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:

{\frac {1}{n}}\sum _{i}{(x_{i}-{\bar {x}})(y_{i}-{\bar {y}})}

where

{\bar {x}}

and

{\bar {y}}

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