Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

QNORM

Applies to: CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7

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

-4.264844571546845

-3.090522225780171

-1.6452114401438158

-1.036431485189561

-0.6741891400433162

-0.3848770849965131

-0.12538099310291884

0.12538099310291884

0.3848770849965131

0.6741891400433162

1.0364314851895606

1.645211440143815

3.090522225780171

4.264844571547861

4.264844571547861

See also: