PROBNORM
Return the probability that an observation from the standard normal distribution is less
than or equal to the specified
number
. This function runs the following
calculation on an expression that evaluates to a floating-point number or a compatible data
type:0.5 * (ERF(number / POW(2, 0.5)) + 1)
The
PROBNORM
syntax is as
follows:PROBNORM(number)
For example:
premdb=# select probnorm(0.123456789) from sys.const;
probnorm
-------------------
0.549127305078142
(1 row)
premdb=# select avg_att, probnorm(avg_att) from team order by 1 desc limit 3;
avg_att | probnorm
---------+----------
75.286 | 1
59.944 | 1
54.041 | 1
(3 rows)
See also ERF.