NORMSINV Excel formula is a Statistical function that calculates the inverse of the standard normal cumulative distribution of a specific probability. The standard normal distribution is a type of normal distribution with a mean of zero (0) and a standard deviation of one (1). In this guide, we’re going to show you how to use the NORMSINV function and also go over some tips and error handling methods.
- All Excel versions
- Microsoft has effectively replaced this function with the NORM.S.INV function in Excel 2010 and newer versions. It is kept for backwards compatibility. We recommend instead using the NORM.S.INV function if you have Excel 2010 or a newer version.
|probability||The probability value corresponding to the standard normal distribution.|
NORMSINV Function Examples
Probability density function
The NORMSINV function calculates the value which proves the standard cumulative normal distribution function using the specified mean and standard deviation values. Essentially, Excel returns the value for the statement NORM.S.DIST(z, TRUE) = probability.
NORMSINV Function Tips
- We recommend not using the NORMSINV function unless your Excel version is older than 2010. The NORM.S.INV function performs better in most scenarios and is newer.
- You can use the STDEV.P or STDEV.S functions to calculate the standard deviation for the entire population or a sample, respectively.
- You can use the AVERAGE function to calculate the mean of a data set.
- Similar functions that can help you calculate normal distributions:
- You will get a #NUM! error value;
- If the standard_dev argument is ≤ 0
- If probability ≤ 0 or if probability ≥ 1