NORM.S.INV Function Explained
The NORM.S.INV Function in Microsoft Excel returns the inverse of the standard normal cumulative distribution for a given probability. It is used to calculate the value of a normally distributed random variable given a probability. It takes a single argument, a probability between 0 and 1, and returns the corresponding value of the standard normal distribution.
NORM.S.INV Function Syntax
NORM.S.INV(probability, mean, standard_dev)
- probability: The probability corresponding to the normal distribution. Must be a value between 0 and 1.
- mean: The arithmetic mean of the distribution.
- standard_dev: The standard deviation of the distribution.