Excel functions / Statistics

PEARSON function

The Pearson correlation coefficient, the same as CORREL.

Syntax

=PEARSON(array1, array2)

Arguments

When to use it

PEARSON gives the correlation coefficient between two sets of numbers: 1 when they rise together in a straight line, -1 when one falls as the other rises, 0 when there is no straight-line relation. It gives the same result as CORREL.

Examples

  1. Ad spend against sales

    ABCD
    1Ad spendSales
    210012000.993
    32001900
    43003100
    54003800
    65005200

    In D2: =PEARSON(A2:A6, B2:B6) → 0.993

    Try this example

  2. R squared: how much of the variation the line explains

    ABCD
    1Ad spendSales
    2100120099%
    32001900
    43003100
    54003800
    65005200

    In D2: =PEARSON(A2:A6, B2:B6)^2 → 99%

    Try this example

Common mistakes

PEARSON 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

Try PEARSON in the playground

Related functions