Statistical Functions - trillium_discovery - 17.1

Trillium Expression Builder

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Expression Builder
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

The functions for the Statistical category perform statistic analysis on numeric data in an attribute.

Function Name

Description

ISOUTLIER

An outlying value is one that is outside the standard range of data. Use the results of the STDDEV function to determine the deviation level to use.

The function returns true (1) for all numeric data whose deviation is equal to or greater than the deviation level specified with the function. The function returns false (0) for all numeric values with deviation less than the deviation level specified with the function.

Note the following guidelines:

  • Function is not supported for Quality processes.
  • Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).
  • You must run Std. Deviation analysis on the attribute before you use this function.

MEAN

Mean returns the numeric average of the values in an attribute, determined by the sum of values in the attribute divided by the number of values.

Note the following guidelines:

  • Function is not supported for Quality processes.
  • Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).

MEDIAN

Median is the numeric value separating the higher half of a data set from the lower half. This function returns the median of the specified attribute.

Note the following guidelines:

  • Function is not supported for Quality processes.
  • Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).
  • You must run percentile analysis on the attribute before you use this function.

PERCENTRANK

Returns the rank of a specified numeric value in a data set. The percentrank represents the location of the percentile in a value. For example, halfway in a value the percentrank would be 50%. Percentrank is calculated to two decimal points.

Note the following guidelines:

  • Function is not supported for Quality processes.
  • Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).
  • You must run percentile analysis on the attribute before you use this function.

QUARTILE

A quartile is used to rank numeric data into quarters. The function returns the requested quartile of a value in an attribute as a percentage of the attribute.

Note the following guidelines:

  • Function is not supported for Quality processes.
  • Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).
  • You must run percentile analysis on the attribute before you use this function.

STDDEV

Returns the standard deviation of an attribute, calculated to three decimal points. Standard deviation is used to measure how widely values are removed from the average value in an attribute. Use the results of this function to run the ISOUTLIER function.

Note the following guidelines:

  • Function is not supported for Quality processes.
  • Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).
  • You must run Std. deviation analysis on the attribute before you use this function.

TOTAL

Returns the total of a specified attribute.

Note the following guidelines:

  • Function is not supported for Quality processes.
  • Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).

VARIANCE

Returns the variance of a specified attribute, calculated to three decimal points. Use this function to determine how far values in an attribute are spread out.

Note the following guidelines:

  • Function is not supported for Quality processes.
  • Function is not supported for dynamic entities (data sources). Applicable only to real, fully-loaded entities (data sources).
  • You must run Std. deviation analysis on the attribute before you use this function.