COVARIANCE.P function

COVARIANCE.P(numbers1, numbers2) COVARIANCE.P(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 population covariance, that is, the covariance of the product of paired deviations, for an entire population.

Returns the population covariance, that is, the covariance of the product of paired deviations, for an entire population.

Example

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

Returns the population covariance of two sets of random data.