Page tree
Skip to end of metadata
Go to start of metadata
Applies to:  CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 

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 )

Examples


[1] Simple QNORM calculation over a FLOAT column.

Query
Column1
QNORM("Table1"."Column1")
Input
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
Output
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
5.1990818894194755


See also:

  • No labels