Syntax:
COVARIANCE.P(x-data:array, y-data:array)
Returns the population 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 (xi − x) · (yi − y) ) ÷ n
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.P(A1:A15, B1:B15)
returns the population covariance of the contents of cells in the range A1
to A15
and B1
to B15
.
Added in 2.00.