|
<< Click to Display Table of Contents >> COVARIANCE.P (population covariance) |
Syntax:
COVARIANCE.P(Range1, Range2)
Description:
Returns the population covariance of two data sets.
The covariance is the average of the products of the deviations for each pair of values. It can be used to determine the extent to which two data sets vary ("co-vary").
Range1 and Range2 are cell references to the two data sets. These must contain whole numbers. Empty cells, text and logical values are ignored.
The data sets must have the same number of values, otherwise the function returns a #N/A error value.
Example:
If A1:A3 contains the values 2, 5, 3 and B1:B3 contains 2, 7, 4:
COVARIANCE.P(A1:A3, B1:B3) returns 2.55556
Note:
The COVARIANCE.P function supplements together with COVARIANCE.S the previous COVAR function, whereby COVARIANCE.P, just like COVAR, returns the population covariance and COVARIANCE.S the sample covariance.
Compatibility notes:
Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.
See also: