COVARIANCE.S (sample covariance)

<< Click to Display Table of Contents >>

COVARIANCE.S (sample covariance)

Syntax:

COVARIANCE.S(Range1, Range2)

Description:

This returns the sample covariance of two data sets.

The covariance is the average of the products of the deviations for each pair of values. It can be used to determine the extent to which two data sets vary ("co-vary").

Range1 and Range2 are cell references to the two data sets. These must contain integers. Empty cells, text and logical values are ignored.

The data sets must have the same number of values, otherwise the function returns a #N/A error value.

Example:

If A1:A3 contains the values 2, 5, 3 and B1:B3 contains 2, 7, 4, the following applies:

COVARIANCE.S(A1:A3, B1:B3) returns 3.83333

Note:

The COVARIANCE.S and COVARIANCE.P functions supplement the previous COVAR function, whereby COVARIANCE.S returns the sample covariance and COVARIANCE.P returns the population covariance just like COVAR.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. The function is unknown in older versions.

See also:

COVARIANCE.P/COVAR, FISHER, FISHERINV, CORREL