Computes the correlation coefficient between two columns. Source values can be of Integer or Decimal type. |

The **correlation coefficient** measures the relationship between two sets of values. You can use it as a measurement for how changes in one value affect changes in the other.

- Values range between -1 (negative correlation) and +1 (positive correlation).
- Negative correlation means that the second number tends to decrease when the first number increases.
- Positive correlation means that the second number tends to increase when the first number increases.
- A correlation coefficient that is close to 0 indicates a weak or non-existent correlation.

correl(initialInvestment,ROI) |

**Output:** Returns the correlation coefficient between the values in the `initialInvestment`

column and the `ROI`

column.

correl(function_col_ref1,function_col_ref2) [group:group_col_ref] [limit:limit_count] |

Argument | Required? | Data Type | Description |
---|---|---|---|

function_col_ref1 | Y | string | Name of column that is the first input to the function |

function_col_ref2 | Y | string | Name of column that is the second input to the function |

For more information on the `group`

and `limit`

parameters, see Pivot Transform.

Name of the column the values of which you want to calculate the correlation. Column must contain Integer or Decimal values.

- Literal values are not supported as inputs.
- Multiple columns and wildcards are not supported.

Required? | Data Type | Example Value |
---|---|---|

Yes | String (column reference) | `myInputs` |