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

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

  1. Two lists

    ABCD
    1xy
    2121.2
    324
    435
    544
    655

    In D2: =COVARIANCE.P(A2:A6, B2:B6) → 1.2

    Try this example

Common mistakes

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.

Translate a whole formula

Also written as COVAR.

Try COVARIANCE.P in the playground

Related functions