Applies to: CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
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 )
Example
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 |