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. Supported values are 0 to 3, where 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.