NORMINV function - The function returns the inverse of the cumulative distribution in Excel
The following article details how to use the NORMINV function - The function returns the inverse of the cumulative distribution in excel.
Description: The function returns the inverse of the cumulative distribution with the standard deviation and a defined mean. The NORMINV function uses the iterative search technique, if the search after 100 times has not converged => the function returns the value # N / A.
Syntax: NORMINV (probability, mean, standard_dev) .
Inside:
- probability: Probability corresponding to the normal distribution, is a required parameter.
- mean: The average value of the distribution, is a required parameter.
- standard_dev: The standard deviation of the distribution, is a required parameter.
Attention:
- The parameters in the NORMINV function must be numeric, otherwise the #VALUE!
- Probability value is in the range: 0 < probability <1, otherwise the function returns the #NUM! Error value.
- Required value standard_dev> 0, otherwise the error message #NUM!
- Where mean = 0 and standard_dev = 1 => the distribution becomes the normalized distribution and the NORMINV value of the distribution = NORMSINV value of the distribution.
For example:
Calculate the inverse value of the standard cumulative distribution with the following parameters:
In the cell to calculate the value enter the following formula: = NORMINV (C14, C15, C16) .
Press Enter to get the result:
In case the NORMINV function has mean = 0 and standard_dev = 1 => the NORMINV function value is:
This value is exactly equal to the value of the NORMSINV function with the same corresponding probability:
So when the NORMINV function has mean = 0 and standard_dev = 1 , the value is exactly the same as the NORMSINV function .
The above details in detail how to use the NORMINV function in statistical probability. Hope to help you.
Good luck!
You should read it
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
- LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x 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
- T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel
- CHISQ.INV.RT function - The function returns the inverse of the right end probability of the distribution when squared in Excel
- CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel
May be interested
- 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 Excelnorm.s.inv function: the function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1. support from excel 2010 onwards. syntax: norm.s.inv (probability)
- GAMMA.DIST function - The function returns the gamma distribution in Excelgamma.dist: the function returns the gamma distribution, using this function to study skewed distribution variables. support functions from excel 2010 onwards. syntax: gamma.dist (x, alpha, beta, cumulative)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- BINOM.INV function - The function returns the smallest value with cumulative binomial distribution greater or equal to the standard value in Excelbinom.inv function: the function returns the smallest value with cumulative binomial distribution greater or equal to the standard value. support functions from the excel 2010 version. syntax: binom.inv (trials, probability_s, alpha)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
- HYPGEOM.DIST - The function returns the hyperbolic distribution in Excelhypgeom.dist: the function returns the hyperinfection distribution, using this function for problems with finite sets of vowismooix observations whether or not they are successful. syntax: hypgeom.dist (sample_s, number_sample, population_s, number_pop, cumulative)
- TINV function - The function returns the inverse of the Student's t-distribution in Exceltinv function: the tinv function supports the calculation of the inverse value of the student's t-distribution associated with the student's 2-t distribution in excel.
- F.DIST - The function returns the probability distribution F in Excelf.dist function: the function returns the probability distribution f. the function supports the version from excel 2010. syntax: f.dist (x, deg_freedom1, deg_freedom2, cumulative)
- NORMSDIST function - The function returns the normal cumulative distribution in Excelthe following article details how to use the normsdist function - the function returns the cumulative normal distribution in excel.
- CHISQ.DIST - Function returns the distribution when squared in Excelchisq.dist: the function returns the distribution when squared, and this value is often used to understand variations as a percentage of the samples. support function from excel 2010 version. syntax: chisq.dist (x, deg_freedom, cumulative)