The following article introduces you to the NORM.INV function - one of the functions in the group of statistical functions that is very popular in Excel.
Description: The function returns the inverse of the standard cumulative distribution with the specified standard deviation and mean. Support functions from Excel 2010 onwards.
Syntax: NORM.INV (probability, mean, standard_dev)
Inside:
- probability: Probability corresponding to the normal distribution, is a required parameter .
- mean: Arithmetic mean of distribution, is a required parameter.
- standard_dev: The standard deviation of the distribution, is a required parameter.
Attention:
- If any argument of the function is not a number -> the function returns the #VALUE! Error value
- If standard_dev ≤ 0 -> the function returns the #NUM! Error value
- If mean = 0 , standard_dev = 1 -> function returns normalized distribution.
For example:
Find the inverse value of the cumulative normal distribution with the values in the data table below:
- In the cell to calculate, enter the formula : = NORM.INV (D6, D7, D8)
- Press Enter -> the inverse value of the cumulative standard distribution is:
- Where mean = 0 , standard_dev = 1 -> function returns normalized distribution.
- Where standard_dev ≤ 0 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using the NORM.INV function in Excel.
Good luck!