Measure how strongly two sets of numbers move together (−1 to +1).
Copy this formula
=CORREL(A2:A100, B2:B100)CORREL returns the correlation coefficient between two ranges: +1 is a perfect positive relationship, −1 perfectly negative, and 0 none. It's a quick check for whether two metrics are related.
=CORREL(AdSpend, Sales)→0.82Strong positive correlation.
No — a high CORREL shows the two move together, not that one causes the other.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.