COVARIANCE.S function

COVARIANCE.S(Numbers1, Numbers2) COVARIANCE.S(Numbers1; Numbers2)

Numbers1

{ Number }

The first set of values. This array must have the same size as the other array parameter.

Numbers2

{ Number }

The second set of values. This array must have the same size as the other array parameter.

Returns

Number

The sample covariance, that is, the covariance of the product of paired deviations, for a sample of the population.

Returns the sample covariance, that is, the covariance of the product of paired deviations, for a sample of the population.

Example

COVARIANCE.S(RANDARRAY(10), RANDARRAY(10))COVARIANCE.S(RANDARRAY(10); RANDARRAY(10))

Returns the sample covariance of two sets of random data.