Table of Contents
This guide provides a practical overview of NORM. INV Function, including its main features, benefits, limitations, and important considerations.
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!
FAQ
What does the NORM. INV Function function do in Excel?
The NORM. INV Function function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the NORM. INV Function function correctly?
Start with an equals sign, enter NORM. INV Function, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the NORM. INV Function function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Reader Comments 0
Sign in with email or Google to join the discussion.