Statistics Results - Teradata Warehouse Miner

Teradata Profiler Plug-in User Guide

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
tjx1484331808948.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2304
lifecycle
previous
Product Category
Software

Grid View

The grid view of a Statistical analysis contains the following data, depending on the options you selected.
Name Type Definition
COLUMN Group By Column Type Columns are created only if the group parameter is specified. Multiple columns, if specified, are created or displayed as the column name. These columns contain the unique values that the group by column takes on.
xdb VARCHAR (128) Database that the variable for the values operation resides in, as specified by the database parameter.
xtbl VARCHAR (128) Table that the variable for the statistics operation resides in, as specified by the table parameter.
xcol VARCHAR (128) Variable that the statistics operation is run against, as specified by the column parameter.
xcnt FLOAT The total number of occurrences of this variable.
xmin FLOAT The minimum value of the variable. Created only if the Minimum Value option is selected.
xmax FLOAT The maximum value of the variable. Created only if the Maximum Value option is selected.
xmean FLOAT The arithmetic mean of the variable. Created only if the Mean Value option is selected.
xstd FLOAT The standard deviation of the variable. Created only of the Standard Deviation option is selected.
xskew FLOAT The skewness of the variable. Created only if the Skewness option is selected.
xkurt FLOAT The kurtosis of the variable. Created only if the Kurtosis option is selected.
xste FLOAT The standard error of the variable. Created only if the Standard Error option is selected.
xcv FLOAT The coefficient of variance of the variable. Created only if the Coefficient of Variance option is selected.
xvar FLOAT The variance of the variable. Created only if the Variance option is selected.
xsum FLOAT The sum of the variable. Created only if the Sum option is selected.
xuss FLOAT The uncorrected sums of squares of the variable. Created only if the Uncorrected Sums of squares option is selected.
xcss FLOAT The corrected sums of squares of the variable. Created only if the Corrected Sums of squares option is selected.

Thumbnail View

The Thumbnail view displays results as thumbnails grouped by database and table of all the possible graph generations per column.

Graph View

The Statistics Analysis graph view displays a Box and Whisker graph of the maximum, mean + standard deviation, mean, mean - standard deviation, and minimum values results for the selected columns.