The OUTIQ function calculates the outliers in a set of input values using interquartile range computations.
- d0 - The set of data values for which the Interquartile Outliers is calculated.
- s0 - The value used to determine the position of the minor outliers. The default value is 1.5 and the supported range is from 1 to 5.
- s1 - The value used to determine the position of the major outliers. The default value is 3 and the supported range is from 1 to 10.
- s2 - Indicates that all non outlier data points should be hidden in the result. The default value is False.
- s3 - Indicates that all minor outliers should be hidden in the result. The default value is True.
- s4 - Indicates that all major outlier data points should be hidden in the result. The default value is True.
- s5 - Indicates what value should be used to replace any hidden outliers. Available choices include:
- 0 - null values
- 1 - zero
- 2 - neighbour's average
- 3 - global average
- Alignments (optional) - A hierarchy placeholder to be used as the alignment axis.
The Data Outliers function generates the following output:
- Interquartile Outliers - The Interquartile Outliers result set.