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 items:
- Cutoff Points
- Replacement value
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. The upper and lower values are set to the maximum and minimum values by default. In this case, all values less than the lower value or greater than the upper value are outliers.
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 © 2005, Oracle. All rights reserved.