Frequency analysis results can be viewed in a grid, as thumbnails, and in graphs.
Grid View
The grid view of a Frequency analysis contains the following data, depending on the options you selected.
| Name | Type | Definition |
|---|---|---|
| xtbl | VARCHAR (128) | Tables that the variable for the statistics operation resides in, as specified by the table parameter. |
| xcol | VARCHAR (128) | Variable that the statistics operation runs against, as specified by the column parameter. |
| xval | VARCHAR (256) | Distinct values of the frequency variable. |
| xcnt | FLOAT | Count of the number of rows that the frequency variable is equal to the distinct value specified in xval. |
| xpct | FLOAT | Percentage of the total records where the frequency variable is equal to the distinct value specified in xval. |
| xmin_COL | FLOAT | If Statistics Column is selected, this column is created to represent the minimum value of the column specified for the given frequency value (xval). |
| xmax_COL | FLOAT | If Statistics Column is selected, this column is created to represent the maximum value (xval). |
| xmean_COL | FLOAT | If Statistics Column is selected, this column is created to represent the mean value of the column specified for the given frequency value (xval). |
| xstd_COL | FLOAT | If Statistics Column is selected, this column is created to represent the mean value of the column specified for the given frequency value (xval). |
Thumbnail View
The Frequency Thumbnail view displays results as thumbnails grouped by database and table of all the possible graph generations per column.
Graph View
The Frequency Analysis graph displays the box and whisker plot graph of the Statistics (Maximum, Mean + Standard Deviation, Mean, Mean – Standard Deviation, and Minimum values) results for the selected column values.