PEARSON

Try it

When to use it

When should I use PEARSON?

Use PEARSON to measure the linear correlation between two numeric datasets — for example, to see how strongly advertising spend correlates with sales, or whether hours studied correlate with exam scores. The result ranges from -1 (perfect negative) to 1 (perfect positive).

Used in

science · operations

Syntax

PEARSON(array1,array2)

Examples

=PEARSON({2,3,9,1,8,7,5},{6,5,11,7,5,4,4}) // => 0.24072846024282465