COVARIANCE.S

Syntax:

COVARIANCE.S(x-data:array, y-data:array)

Returns the sample covariance of the values in the two given data sets. This is the average of the products of the deviations of each pair of data points from their respective means.

The equation used is:

( Σi=n (xix) · (yiy) ) ÷ (n − 1)

where xi is each value in the x-data, yi is each value in the y-data, and n is the number of values.

Example:

COVARIANCE.S(A1:A15, B1:B15)

returns the sample covariance of the contents of cells in the range A1 to A15 and B1 to B15.

Added in 1.36.