Statistical Operation¶
Computes a statistical metric from a comma-separated list of numbers. It parses the input string into floats and supports mean, median, mode, standard deviation, variance, sum, product, and count. If parsing fails or the list is empty, it returns 0.0 and logs a warning.
Usage¶
Use this node to quickly aggregate or summarize numeric data provided as a simple comma-separated string. Typical workflows include preprocessing text-based numeric inputs, computing summary statistics for parameters, or deriving a single scalar metric to drive downstream logic.
Inputs¶
| Field | Required | Type | Description | Example |
|---|---|---|---|---|
| values | True | STRING | Comma-separated list of numeric values to process. Spaces around commas are allowed; numbers are parsed as floats. | 1, 2, 3.5, 4, 10 |
| operation | True | STRING | Statistical operation to apply to the parsed numbers. Options: mean, median, mode, std, variance, sum, product, count. | mean |
Outputs¶
| Field | Type | Description | Example |
|---|---|---|---|
| result | FLOAT | The computed statistical result as a float. | 3.0 |
Important Notes¶
- Note: Input must be a comma-separated list using '.' as the decimal separator. Non-numeric entries cause the node to return 0.0.
- Note: Standard deviation and variance are computed as population metrics (divide by N), not sample metrics (divide by N-1).
- Note: Mode returns the most frequent value; when multiple modes exist, the first encountered most frequent value is returned.
- Note: Median handles both even and odd counts; for even counts, it averages the two middle values.
- Note: Product initializes at 1 and multiplies through; very large or very long lists may underflow/overflow floating-point range.
- Note: If the parsed list is empty, the node returns 0.0.
Troubleshooting¶
- Issue: Result is 0.0 unexpectedly. Resolution: Check that all entries in 'values' are valid numbers and that the list is not empty.
- Issue: Mode seems arbitrary with multiple equally frequent values. Resolution: The node returns the first most frequent value; if you need deterministic tie-breaking, pre-sort or adjust inputs.
- Issue: Unexpected precision or rounding differences. Resolution: The node uses floating-point arithmetic; consider rounding downstream if exact formatting is required.
- Issue: Very large product or sum returns inf or 0.0. Resolution: Scale inputs or use operations less sensitive to magnitude (e.g., mean) depending on your goal.