COVARIANCE_P

Calculates the covariance between two variables.

Syntax

COVARIANCE_P(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_P(A1, B1) returns 0