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.