When dealing with numeric data columns, use statistical measures to understand the characteristics and properties of each of those columns, to assess their quality, and to look for outlying values and other possible anomalies. Statistical analysis provides several statistical measures for numeric data columns.
Given a table name and the names of numeric columns, statistical analysis determines descriptive statistics for each of the columns. Univariate statistics provided include the following:
- Count
- Minimum
- Maximum
- Mean
- Standard deviation
- Skewness
- Kurtosis
- Standard error
- Coefficient of variance
- Variance
- Sum
- Uncorrected sums of squares
- Corrected sums of squares
For DATE columns, statistics other than count, minimum, maximum, and mean are calculated by first converting to the number of days since 1900.
If non-numeric columns are selected, you receive a Teradata SQL Error 2621: "Bad character in format or data of Table Column."
The Statistical analysis is parameterized by specifying the table and columns to analyze, options unique to the Statistical analysis, and the output and expert options.