NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel
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!
You should read it
- NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel
- NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel
- NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
- LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
- NORMINV function - The function returns the inverse of the cumulative distribution in Excel
- T.INV function - The function returns the inverse value of the Student t distribution in Excel
- F.INV function - The function returns the inverse of the probability distribution F in Excel
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
- BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excel
- CONFIDENCE.NORM function - The function returns the confidence interval of the population by using a normalized distribution in Excel
Maybe you are interested
How to turn a photo into a painting using the Generative Fill function in Photoshop
How to use the TREND function in Excel
Google Sheets Functions to Simplify Your Budget Spreadsheets
Instructions for using the TRIMRANGE function to clean up Excel tables
How to master numerical data in Google Sheets with the AVERAGE function
Don't buy headphones if they lack this important function!