CORREL
Quantify what drives volume.
Why planners need it
Does marketing spend, weather, or a sister-metric actually move your contacts? CORREL puts a number on the relationship before you build a driver model.
Syntax
=CORREL(range1, range2)
Worked example
Weekly marketing spend vs calls:
=CORREL(Spend, Calls) → 0.82 — a strong positive link worth modelling. Near 0 means no linear relationship.
Watch out: Correlation is not causation, and it only catches linear links. A curved relationship can show a low CORREL yet be highly predictable.