NORMSINV Function Explained
The NORMSINV Function in Microsoft Excel returns the inverse of the standard normal cumulative distribution for a given probability. It takes a probability as an argument and returns the value that has a cumulative probability equal to the given probability. It is useful for finding the z-score for a given probability.
NORMSINV Function Syntax
NORMSINV(probability)
- probability: The probability associated with the normal distribution. Must be a value between 0 and 1.