NORM.INV Function Explained
The NORM.INV Function in Microsoft Excel returns the inverse of the normal cumulative distribution for a given mean and standard deviation. It takes three arguments: probability, mean, and standard_dev. It returns the value that corresponds to the given probability in a normal distribution with the given mean and standard deviation.
NORM.INV Function Syntax
NORM.INV(probability, mean, standard_dev)
- probability: The probability associated with 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.