Skip to main content

COVARIANCE.S function

The COVARIANCE.S function is one of the statistical functions. It is used to return the sample covariance, the average of the products of deviations for each data point pair in two data sets.

Syntax​

COVARIANCE.S(array1, array2)

The COVARIANCE.S function has the following arguments:

ArgumentDescription
array1(2)The selected ranges of cells with the same number of elements.

Notes​

If array1(2) contains text, logical values, or empty cells, the function will ignore those values, but treat the cells with the zero values.

How to apply the COVARIANCE.S function.

Examples​

The figure below displays the result returned by the COVARIANCE.S function.

COVARIANCE.S Function