Statistical Operation¶
Computes a statistical measure from a comma-separated list of numbers. Supports mean, median, mode, standard deviation, variance, sum, product, and count. If inputs are invalid or empty, the node returns 0.0.
Usage¶
Use this node to quickly summarize numeric data provided as a single comma-separated string. Commonly placed after text or configuration inputs to compute aggregates for downstream logic, thresholds, or reporting.
Inputs¶
| Field | Required | Type | Description | Example |
|---|---|---|---|---|
| values | True | STRING | Comma-separated list of numbers to analyze. Whitespace is allowed and ignored around numbers. | 1, 2, 2, 3, 4.5 |
| operation | True | ["mean", "median", "mode", "std", "variance", "sum", "product", "count"] | Statistical operation to apply to the parsed list of numbers. | median |
Outputs¶
| Field | Type | Description | Example |
|---|---|---|---|
| result | FLOAT | The computed statistic. For count, the value represents the number of parsed entries; for other operations, the corresponding statistic. | 2.0 |
Important Notes¶
- Input parsing: The node expects a comma-separated string of numeric values; non-numeric tokens cause the node to return 0.0.
- Empty input handling: If the list contains no valid numbers after parsing, the result is 0.0.
- Standard deviation and variance: These are population metrics (dividing by n, not n-1).
- Mode behavior: If multiple modes exist, the first most-frequent value encountered is returned; ties are not resolved deterministically for equal frequencies.
- Types: All values are parsed as floats. The output type is FLOAT even for operations like count.
- Product growth: Large products can overflow to very large magnitudes; ensure inputs are within reasonable ranges.
Troubleshooting¶
- Result is 0.0 unexpectedly: Verify the values string contains only numbers separated by commas (e.g., "1,2,3"). Remove extra text or symbols.
- Unknown operation warning: Ensure the operation is one of: mean, median, mode, std, variance, sum, product, count.
- Mode seems incorrect: With multiple equally frequent values or floating-point values that are nearly equal, the selected mode may differ from expectations. Consider rounding inputs before passing them.
- Standard deviation differs from expected: This node uses the population standard deviation. If you need sample standard deviation, adjust your workflow accordingly.
- Count not an integer: The output type is FLOAT; if you need an integer, cast downstream or use a node that converts types.