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. 

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]


ArgumentRequired?Data TypeDescription
function_col_ref1YstringName of column that is the first input to the function
function_col_ref2YstringName of column that is the second input to the function

For more information on the group and limit parameters, see Pivot Transform.

function_col_ref1, function_col_ref2

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

Required?Data TypeExample Value
YesString (column reference)myInputs