How To Use NORMINV()

Description

Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.

Common questions about the NORMINV formula include:
What is the NORMINV formula?
What does NORMINV stand for?
What type of argument does the formula accept?

The NORMINV formula can be used to find a value from a normalized distribution with given mean and standard deviation. Specifically, it can be used for situations where you are trying to estimate a probability from observed data.

The NORMINV formula can be commonly mistyped as NORMVINV, NORMVNI, or NOMRINV.

Some common ways the NORMINV formula is used inappropriately include using the wrong function for the situation, entering the wrong arguments into the formula, or entering a non-numeric data type into the formula.

Common pitfalls when using the NORMINV formula include not understanding the arguments required, incorrect calculations when using the wrong arguments, and/or not double-checking the correctness of the formula.

Common mistakes when using the NORMINV Formula include entering the wrong arguments or using the argument order incorrectly.

Common misconceptions people might have with the NORMINV Formula may include using the wrong statistical method or thinking the NORMINV formula is the same as other related formulas such as NORM.DIST.

How To Actually Use NORMINV() in Sheets

NORMINV(x, mean, standard_deviation)

0Better Sheets Tutorials

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.

Learn more about the NORMINV() formula:

Google Sheets GAUSS NORMDIST NORMINV NORMSINV in Cumulative Normal Distribution using ARRAYFORMULA

This video shows the use of ARRAYFORMULA in generating data sets for Google Sheets GAUSS NORMDIST NORMINV NORMSINV in Cumulative Normal Distribution,