- MomentsTableName
- [Required if you omit StatisticsGroups syntax element or specify 'moments'.] Specify the name for the output table that contains the moments.
- BasicTableName
- [Required if you omit StatisticsGroups or specify 'basic'.] Specify the name for the output table that contains the basic statistics.
- QuantilesTableName
- [Required if you omit StatisticsGroups or specify 'quartiles'.] Specify the name for the output table that contains the quantiles.
- TargetColumns
- [Optional] Specify the names of the InputTable columns for which to compute statistics.
- ExcludeColumns
- [Optional] Specify the names of the InputTable columns to exclude from statistics calculation.
- PartitionColumns
- [Optional] Specify the names of the InputTable columns on which to partition the input. The function copies these columns to the output table.
- StatisticsGroups
- [Optional] Specify the group or groups of statistics to calculate:
statistics_group Statistics to Calculate 'moments' - Number of observations
- Sum
- Mean
- Variance
- Standard deviation
- Standard error
- Skewness
- Kurtosis
- Coefficient of variation
- Uncorrected sum of squares
- Corrected sum of squares
'basic' - Number of observations
- Number of NULL values
- Number of positive, negative, and zero values
- Number of unique values
- Mode
- Median
- Mean
- Standard deviation
- Variance
- Range
- Interquartile range
- Harmonic mean
- Geometric mean
- Highest and lowest five values
'quantiles' - Minimum and maximum values
- 1st, 5th, 10th, 25th, 50th, 75th, 90th, 95th, and 99th percentiles
Default behavior: The function calculates all three groups of statistics.