Returns the sample covariance, the average of the products of deviations for each data point pair in two datasets.

**Sample Usage**

COVARIANCE.S(A2:A50,B2:B50)

**Syntax**

COVARIANCE.S(array1. array2)

- array1 - The first value or range to consider.
- array2 - The second value or range to consider.

**Examples**

COVARIANCE.S(A2:A50,B2:B50) returns the sample covariance, the average of the products of deviations for a sample of the data point pairs.