Excel functions / Statistics
COVARIANCE.P function
Population covariance: the average product of the deviations of each pair from their means.
Syntax
=COVARIANCE.P(array1, array2)
Arguments
array1: The first set of values.array2: The second set, the same size as the first.
When to use it
COVARIANCE.P measures how two sets of numbers move together, treating them as the whole population: it divides by the count, where COVARIANCE.S divides by one less.
Examples
Two lists
A B C D 1 x y 2 1 2 1.2 3 2 4 4 3 5 5 4 4 6 5 5 In D2:
=COVARIANCE.P(A2:A6, B2:B6)→ 1.2
Common mistakes
- Reading the size. Covariance depends on the units. CORREL gives a number from -1 to 1 that is easier to read.
COVARIANCE.P in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: COVARIANCE.P
- Danish: KOVARIANS.P
- Dutch: COVARIANTIE.P
- Finnish: KOVARIANSSI.P
- French: COVARIANCE.PEARSON
- German: KOVARIANZ.P
- Hungarian: KOVARIANCIA.S
- Italian: COVARIANZA.P
- Norwegian: KOVARIANS.P
- Polish: KOWARIANCJA.POPUL
- Portuguese (Brazil): COVARIAÇÃO.P
- Portuguese (Portugal): COVARIÂNCIA.P
- Russian: КОВАРИАЦИЯ.Г
- Spanish: COVARIANCE.P
- Swedish: KOVARIANS.P
- Turkish: KOVARYANS.P
Also written as COVAR.
Try COVARIANCE.P in the playground
Related functions
- COVARIANCE.S: Sample covariance: like COVARIANCE.P, but divides by n − 1 for a sample.
- CORREL: The correlation coefficient of two data sets: from −1 (opposite) through 0 (unrelated) to 1 (move together).
- VAR.P: Variance of an entire population.