Define Outlier Treatment
Use this selection to define an outlier treatment for one or more attributes or to edit a previously defined treatment.
You must specify two things:
When you are done defining the treatment, click OK.
Cutoff Points
Select one of the following:
- St. Deviation, the default, to specify outliers in terms of a multiple of sigma (the standard deviation). The default Multiples of sigma is 3. In this case, all values not in the range AVE±3σ(where AVE is the average, and σ (sigma) is the standard deviation) are considered to be outliers. You can replace 3 with any positive integer value.
- Percent to specify outliers using percent of high and low values. You must specify Lower Tail Percent (values less than the mean) and Upper Tail Percent (values greater than the mean). The default for both percent values is 5%. For the default percents, all values in either the bottom 5% or the top 5% are outliers.
- Value to specify outliers using a specific Lower Value and Upper Value.
All values less than Lower Value or greater than Upper Value are outliers.
The defaults for this selection depend on the number of attributes that you selected:
- If you selected one attribute, the upper and lower values are set to the maximum and minimum values of the attribute. You can change the values; note that the upper and lower values cannot be the same number.
- If you selected two or more attributes, both upper and lower values are set to 0. You must specify upper and lower values; note that the upper and lower values cannot be the same number.
Replacement Value
Specify what to do with outliers. You can either replace the values with nulls (that is, throw the values away) or you can replace then with edge values. The default is Replace with nulls.
Copyright © 2006, 2008, Oracle. All rights
reserved.