Math & Statistics icon

Math & Statistics

Calculate safe allowlisted math and statistics operations for finance datasets.

Actions8

Descriptive Statistic → Percentile

AI-generated

Summary

Calculate the specified percentile value for a numeric column across input data rows.

Inputs

  • Percentile (required) — A number between 0 and 100 representing the percentile to calculate.
  • Value Column (required) — Name of the numeric column from the input data rows on which to calculate the percentile.

Output shape

A single object containing the percentile result, including the column name, requested percentile, computed value, count of valid numeric inputs, count of ignored non-numeric inputs, and limitation notes.

The operation requires at least some numeric data in the specified column; if none is available, an error is returned. Non-numeric or missing values in the column are ignored with warnings. The percentile calculation converts decimal values to JavaScript Numbers, which may affect precision for very large or precise numbers.

Links

Discussion