Covariance

The Covariance function examines the measurements in the Base range and places their covariance in a table at the Placement. The table displays each combination of column pairs.

Covariance determines whether the two measurements tend to move together i.e., large values of one tend to be associated with large values of the other (positive covariance), small values of one tend to be associated with large values of the other (negative covariance) or the value are unrelated (covariance near 0). Covariance is not scaled.

The equation for the covariance coefficient is:

Example

Determine the covariance of temperature data.

Base
Cell	$C$3:$E$3
Direction	Down
End	All cells are empty

Placement
Cell	$C$16

Setting	Value
Place Formulas	No