1.0 - 8.00 - UnivariateStatistics Arguments - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)
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.