NORMSINV( ) function
Returns the z-score associated with a specified probability in a standard normal distribution. The z-score is the number of standard deviations a value is from the mean of a standard normal distribution.
Syntax
NORMSINV(probability)
Parameters
| Name | Type | Description |
|---|---|---|
| probability | numeric |
The probability for which you want to calculate the z-score. |
Output
Numeric.
Examples
Basic examples
Returns 1.333401745213610:
NORMSINV(0.9088)
ACL Scripting Guide 14.1