Analytics
Statistics
Adds a statistic for each picked numeric column, in a new column beside the data: a z-score, a percentile rank, a running total or a moving average.
When to use it
Use it to spot outliers (z-score), to say where a value stands among the rest (percentile rank), or to follow a trend down the rows (cumulative sum, moving average).
In a pipeline
File InputStatisticsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Statistic | select | — | zscore |
| Columns | select | Yes | Select numeric columns… |
| Window (rows) | number | — | 3 |
| New column suffix | text | — | Default: z, pct, cumsum or ma3 |
Example
Z-scores of margin
- Statistic=Z-score
- Columns=Margin
| Product | Margin |
|---|---|
| Tea | 10 |
| Coffee | 20 |
| Cocoa | 30 |
| Product | Margin | Margin_z |
|---|---|---|
| Tea | 10 | -1 |
| Coffee | 20 | 0 |
| Cocoa | 30 | 1 |
Worth knowing
- New columns are named column_suffix: _z, _pct, _cumsum or _ma3 (for a window of 3) unless you type your own suffix.
- Z-scores use the sample standard deviation (Excel's STDEV.S). Percentile rank is Excel's PERCENTRANK.INC as 0–100.
- Moving average is a trailing window over the rows in their current order; the first window−1 rows have no full window and stay blank. Sort Rows first if order matters.
- Blank and non-numeric cells are skipped and get a blank result; the preview says how many were not numbers.