stats
Usage:
stats [<item> ...]
Calculates statistics on the data in the table. This filter turns the table sideways, so that each row of the output corresponds to a column of the input. The columns of the output table contain statistical items such as mean, standard deviation etc corresponding to each column of the input table.
By default the output table contains columns for the following items:
Name
: Column nameMean
: AverageStDev
: Population Standard deviationMinimum
: Numeric minimumMaximum
: Numeric maximumNGood
: Number of non-blank cellsHowever, the output may be customised by supplying one or more
<item>
headings. These may be selected
from the above as well as the following:
NBad
: Number of blank cellsVariance
: Population VarianceSampStDev
: Sample Standard DeviationSampVariance
: Sample VarianceMedAbsDev
: Median Absolute DeviationScMedAbsDev
: Median Absolute Deviation * 1.4826Skew
: Gamma 1 skewness measureKurtosis
: Gamma 2 peakedness measureSum
: Sum of valuesMinPos
: Row index of numeric minimumMaxPos
: Row index of numeric maximumCardinality
: Number of distinct values in column; values >100 ignoredMedian
: Middle value in sequenceQuartile1
: First quartileQuartile2
: Second quartileQuartile3
: Third quartileQ.25
: First quartileQ.625
: Fifth octileAny parameters of the input table are propagated to the output one.
Note that quantile calculations (including median and quartiles) can be expensive on memory. If you want to calculate quantiles for large tables, it may be wise to reduce the number of columns to only those you need the quantiles for earlier in the pipeline. No interpolation is performed when calculating quantiles.