Product Documentation

Appearance

All platforms

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.