The NORM.INV function returns the value of the inverse of the cumulative normal distribution for the specified mean and standard deviation.
Syntax
NORM.INV(
probability,
mean,
standard_dev
)
Parameters
- probability: Probability value corresponding to a normal distribution.
- mean: Arithmetic mean of the distribution.
- standard_dev: Standard deviation of the distribution.
Returned value
The NORM.INV function returns a real number.
Examples
We can calculate the value of the inverse of the cumulative normal distribution of mean 25 and standard deviation 0.7 for probability 0.5 with the following measure:
distribución = NORM.INV(0.5, 25, 0.7)
Related functions
Category
Statistical