Skip to main content

Celonis Product Documentation

QNORM
Description

Evaluates the quantile function of values in a FLOAT column assuming the normal distribution N(0,1).

For values not in the interval (0,1) the result is null.

Syntax
  QNORM ( table.column )
 
NULL handling

If the input value is NULL, QNORM returns NULL as well.

Example

[1]

Simple QNORM calculation over a FLOAT column.

Query

Column1

         QNORM ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : float

1.0E-7

1.0E-5

0.001

0.05

0.15

0.25

0.35

0.45

0.55

0.65

0.75

0.85

0.95

0.999

0.99999

0.9999999

Result

Column1 : float

-5.1993376

-4.2648908

-3.0902323

-1.6448536

-1.0364334

-0.6744898

-0.3853205

-0.1256613

0.1256613

0.3853205

0.6744898

1.0364334

1.6448536

3.0902323

4.2648908

5.1993376

See also: