MicroStrategy ONE

InverseNormSDistribution (Inverse of Standard Normal Cumulative Distribution)

Returns the inverse, or critical value, of the cumulative standard normal distribution. This function computes the critical value so that the cumulative distribution is greater than or equal to a pre-specified value.

For more information on the cumulative standard normal distribution function, see StandardNormalDistribution (standard normal cumulative distribution).

Syntax

InverseNormSDistribution(x)

Where:

x is the probability corresponding to the normal distribution.

Usage Notes

The following conditions are invalid:

  • x is nonnumeric.
  • x < 0 or x > 1.