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.