Buzz
This article introduces NORM.INV - 1 of the statistical functions widely used in Excel.
Description: Returns the inverse value of the standard normal cumulative distribution with specified mean and standard deviation. Supported in Excel 2010 and later versions.
Syntax: NORM.INV(probability,mean,standard_dev)
In which:
- probability: Probability corresponding to the standard distribution, is a required parameter.
- mean: Arithmetic mean of the distribution, is a required parameter.
-
Note:
- If any argument of the function is not a number -> the function returns an error value #VALUE!
- If standard_dev ≤ 0 -> the function returns an error value #NUM!
- If mean = 0, standard_dev = 1 -> the function returns a standardized normal distribution.
Example:
Find the inverse value of the cumulative standard distribution with the values in the data table below:
- In the cell where you want to calculate, enter the formula: =NORM.INV(D6,D7,D8)
- Press Enter -> the inverse value of the cumulative standard distribution is:
- In the case of mean = 0, standard_dev = 1 -> the function returns a standardized normal distribution.
- In the case of standard_dev ≤ 0 -> the function returns an error value #NUM!
Here is the guide and some specific examples when using the NORM.INV function in Excel.
Wishing you success!
