COVARIANCE_S

Calculates the sample covariance between two variables.

Syntax

COVARIANCE_S(data_range1, data_range2)

data_range1

The range of cells representing the dependent data. For example: A1:A20.

data_range2

The range of cells representing the independent data. For example: B1:B20.

COVARIANCE_S(A1, B1) returns #DIV/0!