Sign up for free
Functions

COVARIANCE_S

Calculates the sample covariance between two variables.

Parameter List

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.

Examples

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