Home > Data Nodes > Data Source Node > Explore Data Node > Edit Explore Data Node > Explore Data Node Data Viewer > Statistics
This tab show the statistics calculated by Explore Data.
Attributes are listed the Statistics grid. For each attribute, the name, data type, histogram and summary statistics are displayed.
To view a large version of the histogram for an attribute, select the attribute. The histogram is displayed below the grid. If the attribute has null values, the histogram has a separate bin labeled Null bin
. The histogram may also contain an Others
bin consisting of values that are not NULL but are not in any other bin.
For more information about the histogram, go to the large histogram and right-click the attribute name. These choices are available:
Copy to Clipboard copies the histogram to the Microsoft Windows Clipboard; you can paste this histogram to any rich editor, such as a world processor, or image editor.
Save Image As exports the image to a PNG image that can be stored in the file system.
View Data displays the data used to create the histogram in a pop up window.You can search for attribute name, attribute value, or attribute percent. Click Close when you are done.
Histograms created by Oracle Data Miner use a sample of the data and be slightly different each time they are displayed.
For all data types, a histogram is created; the number of distinct values, the percent of NULL values and the number of distinct values are displayed.
Additional statistics calculated depend on the data type of the attribute:
For character attributes (VARCHAR2), the Mode is calculated.
For numerical (NUMBER or FLOAT) attributes, Average, Minimum Value, Maximum Value, Standard Deviation, Skewness (a measure of the asymmetry of the distribution), and Kurtosis (a measure of flatness or peakedness of the curve describing a frequency distribution in the region about its mode) are calculated.