In this article, you will learn about the NORM.INV function, its usage, syntax and how to use it in your excel spreadsheet.
NORM.INV Function in Excel
The NORM.INV function in Excel returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
- Probability – The probability corresponding to the normal distribution.
- Mean – The arithmetic mean of the distribution.
- Standard_dev – The standard deviation of the distribution.
Possible Errors and Usage Notes
- When the probability of an event occurring is below the threshold value, the function returns the threshold value associated with the probability.
- Either of the arguments is nonnumeric, the function returns the #VALUE! error value.
- When the probability <= 0 or the probability >= 1, the functions returns the #NUM! error value.
- If standard_dev ≤ 0, the functions returns the #NUM! error value.
- Mean = 0 and standard_dev = 1, the functions uses the standard normal distribution (see NORMS.INV).
How to use the NORM.INV function in Excel?
Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar.
Take a look at the given example
To find the inverse of the normal distribution of the given numbers, Enter the numbers in columns A, and B and C and enter the following formula in Column D,
Formula: = NORM.INV (A1,B1,C1)
Here, A1 refers to the cell name or the cell address.
When entered the function gives you the inverse normal distribution of the numbers. Follow the same to other cells and you will get the inverse of the normal distribution for the rest of the numbers.