Math & Statistics icon

Math & Statistics

Calculate safe allowlisted math and statistics operations for finance datasets.

Actions8

Relationship → Correlation

AI-generated

Summary

Calculate the Pearson correlation coefficient between two specified numeric columns in input data rows, returning the correlation value along with metadata on valid and ignored pairs.

Inputs

  • Correlation X Column (required) — First numeric column for Pearson correlation calculation.
  • Correlation Y Column (required) — Second numeric column for Pearson correlation calculation.

Output shape

A single JSON object containing the correlation result with the following fields: xColumn (string), yColumn (string), method ('pearson'), correlation (number or null), validPairCount (number), and ignoredPairCount (number).

The correlation value is null if there are fewer than 2 valid paired numeric observations or if either column has zero standard deviation. Warnings are included for insufficient data or zero standard deviation cases. The operation expects input data as an array of JSON objects (rows) containing the specified columns.

Examples

Example 1: Calculating correlation between 'temperature' and 'iceCreamSales' columns

Set 'Correlation X Column' to 'temperature' and 'Correlation Y Column' to 'iceCreamSales'. Provide data rows including these columns with numeric values.

Links

Discussion