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.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
May be interested
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excelf.inv.rt function: the function returns the inverse of the right probability distribution f. support functions from the excel 2010 version. syntax: f.inv.rt (probability, deg_freedom1, deg_freedom2)
- F.INV function - The function returns the inverse of the probability distribution F in Excelf.inv function: the function returns the inverse of the probability distribution f. support function from the excel 2010 version. syntax: f.inv (probability, deg_freedom1, deg_freedom2)
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excelbeta.inv function: the function returns the inverse of the cumulative distribution function for a specified beta distribution. support functions from excel 2010 version. syntax: beta.inv (probability, alpha, beta, [a], [b])
- T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excelt.inv.2t: the function returns the two-sided inverse of the student's t-distribution. support functions from excel 2010 onwards. syntax: t.inv (probability, deg_freedom)
- STDEV.S function - The function returns the standard deviation based on a sample in Excelstdev.s function: the function returns the standard deviation based on a sample, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.s (number1, [number2], ...)
- How to use the NORMDIST function in Excel - Function that returns the distribution in Excelthe normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
- CONFIDENCE.NORM function - The function returns the confidence interval of the population by using a normalized distribution in Excelconfidence.norm function: the function returns the confidence interval of the population by using normalized distributions. support functions from excel 2010 onwards. syntax: confidence.norm (alpha, standard_dev, size)
- STANDARDIZE function - The function returns the normalized value from a specific distribution in Excelstandardize function: the function returns the normalized value from a distribution characterized by mean and standard_dev arguments. syntax: standardize (x, mean, standard_dev)
- AVEDEV function - The function returns the average absolute deviation of data points from their midpoint in Excelavedev function: the function returns the average absolute deviation between a given data point and the average value of the population. the function is a measure of the variability of a dataset
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.