UnivariateStatistics Syntax Elements - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.
Default: All numerical InputTable columns
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.
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.