Returns the population covariance of the values in two data sets.
This is the average of the products of the deviations of each pair of data points from their respective means.
Syntax:
COVARIANCE.P(x-data:array, y-data:array)
Formula:
COVARIANCE.P = ( ∑i=n (xi − x) ⋅ (yi − y) ) ÷ n
where n is the number of values, xi is the i-th value in the x-data and yi is the i-th value in the y-data,
Example:
COVARIANCE.P(A1:A15, B1:B15)
returns the population covariance of the contents of cells in the range A1:A15
and B1:B15
.
Revisions:
This function was added in 2.00.