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
The following article introduces you to the NORM.S.INV function - one of the functions in the group of statistical functions that is very popular in Excel.
Description: The function returns the inverse value of the normalized distribution with a mean value of 0 and a standard deviation of 1. The function supports Excel 2010 and later versions.
Syntax: NORM.S.INV (probability)
Inside:
- probability: Probability corresponding to the normalized distribution, is a required parameter .
Attention:
- If probability is not number -> the function returns the #VALUE! Error value
- If probability ≤ 0 or probability ≥ 1 -> the function returns the #NUM! Error value
For example:
Find the inverse value of the normal distribution of values in the data table below:
- In the cell to calculate, enter the formula : = NORM.S.INV (D6)
- Press Enter -> the inverse value of the normal distribution function is:
- In case the probability value is greater than 1 or less than 0 -> the function returns the #NUM! Error value
- Where the probability value is not a number -> the function returns the #VALUE! Error value
Above are instructions and some specific examples when using the NORM.S.INV function in Excel.
Good luck!
You should read it
- NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel
- NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel
- NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel
- CONFIDENCE.NORM function - The function returns the confidence interval of the population by using a normalized distribution in Excel
- LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel
- NORMDIST function - The function returns the normal distribution with the standard deviation and the average value specified in Excel
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
- GUSSE function - The function returns the probability that an element of the population is normalized 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
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python