CORREL
Returns the correlation coefficient between two data sets.
StatisticalStatistics & Analysis
What it does
Calculates the Pearson product-moment correlation coefficient between two arrays.
Syntax
CORREL(array1, array2)
Arguments
array1(range) — First range of values.array2(range) — Second range of values.
Examples
Calculate Correlation
Correlate Spend vs. Sales.
FORMULA
=CORREL(A2:A4, B2:B4)
RESULT
0.99
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Spend | Sales |
| 2 | 100 | 200 |
| 3 | 200 | 400 |
| 4 | 300 | 610 |