Math & Statistics icon

Math & Statistics

Calculate safe allowlisted math and statistics operations for finance datasets.

Actions8

Outlier Analysis → Outliers IQR

AI-generated

Summary

Detect outliers in a specified numeric column of input data using the Interquartile Range (IQR) method.

Inputs

  • Value Column (required) — The name of the numeric column to analyze for outliers using the IQR method.

Output shape

A single JSON object containing outlier detection results for the specified column.

The output includes counts of valid and ignored observations, quartile values (Q1, Q3), calculated IQR, lower and upper fences for outliers, and a list of detected outliers with their row indices and numeric values. At least four numeric observations are required to perform the analysis; otherwise, output fields for quartiles and fences will be null. Non-numeric values are ignored. The method converts decimal values to native JavaScript Number for the calculations, which may have precision limitations.

Links

Discussion