Wauvel

Excel like a finance pro.

← The library

Statistical function

PEARSON

Returns the Pearson correlation coefficient; identical to CORREL.

Rarely usedDifficulty 1300 · ProficientUsage rank #307 of 520
Practice · 2 questions →

When to use it

The Pearson product-moment correlation coefficient. Identical to CORREL; both names exist for historical reasons.

The shape of it

Syntax
=PEARSON(array1, array2)

Worked examples

  • Perfect

    =PEARSON({1,2,3,4},{2,4,6,8}) → 1

    Perfect positive.

  • Near linear

    =PEARSON({1,2,3,4},{2,4,6,9}) → 0.994376

    Nearly linear.

  • Same as CORREL

    =PEARSON(A2:A13,B2:B13) → 0.83

    Same as CORREL on the same data.

Worth knowing

  • Use CORREL; it is the name people recognise.
  • RSQ is its square.
  • Pairs with a blank in either array are dropped.

Where it goes wrong

  • #DIV/0! for constant data.
  • #N/A for mismatched sizes.

Related

AVERAGECOUNTCOUNTACOUNTIFCOUNTIFSMAX

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.