# UnivariateStatistics Arguments - Teradata Vantage

## Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Release Number
1.0
8.00
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
lmf1502735330121
Product Category
MomentsTableName
[Required if StatisticsGroups argument is omitted or specifies 'moments'.] Specify the name for the output table that contains the moments.
BasicTableName
[Required if StatisticsGroups argument is omitted or specifies 'basic'.] Specify the name for the output table that contains the basic statistics.
QuantilesTableName
[Required if StatisticsGroups argument is omitted or specifies 'quartiles'.] Specify the name for the output table that contains the quantiles.
TargetColumns
[Optional] Specify the names of the input columns for which to compute statistics.
Default: All numerical input columns
ExcludeColumns
[Optional] Specify the names of the input columns to exclude from statistics calculation.
PartitionColumns
[Optional] Specify the names of the input columns on which to partition the input. The function copies these columns to the output table.
Default behavior: The function treats all rows as a single partition.
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.