Data Outliers

Contents[Hide]

The OUTIQ function calculates the outliers in a set of input values using interquartile range computations.

Identify data outliers
Identify data outliers

1. Syntax

OUTIQ(d0,s0,s1,s2,s3,s4,s5,Alignments)

2. Input

  • d0 - The set of data values for which the Interquartile Outliers is calculated.

3. Parameters

  • 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.

4. Output

The Data Outliers function generates the following output:

  • Interquartile Outliers - The Interquartile Outliers result set.

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri