Correlation
Measures how closely two columns of numbers move together, on a scale from -1 to 1. A value near 1 means they rise and fall together, near -1 means one rises as the other falls, and near 0 means no steady relationship. Both columns must have the same number of rows.
Inputs
| Input | Accepts | Required |
|---|---|---|
Series1 | Series (a list of numbers) | Yes |
Series2 | Series (a list of numbers) | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Value (a single number) |
Example
A Monthly table carries Marketing_Spend and Revenue columns covering 24
months. A correlation of 0.85 says months with heavier spend were reliably the
higher-revenue months; 0.10 says spend and revenue barely track each other.
Correlation does not prove one causes the other; pair it with a ScatterPlot to
see the shape of the relationship before drawing conclusions.