NORMSINV
TheNORMSINV
function calculates the inverse of the standard normal cumulative distribution for a specified value of x. It is commonly used in statistical analysis to transform data from a normal distribution to a standard normal distribution with a mean of 0 and a standard deviation of 1.
 How to use
NORMSINV
formula?  Examples of using
NORMSINV
formula NORMSINV
formula not working? Similar formulas to
NORMSINV
Usage
Use the NORMSINV
formula with the syntax shown below, it has 1 required parameter:
 x (required):
The value for which to calculate the inverse standard normal cumulative distribution. Must be a decimal value between 0 and 1.
Examples
Here are a few example use cases that explain how to use theNORMSINV
formula in Google Sheets.
Calculate a zscore
To calculate a zscore for a given value in a normal distribution, use the NORMSINV
function to transform the data to a standard normal distribution with a mean of 0 and a standard deviation of 1.
Calculate a confidence interval
To calculate a confidence interval for a sample mean or proportion, first calculate the standard error and then use the NORMSINV
function to find the zscore for the desired confidence level.
Perform hypothesis testing
To perform hypothesis testing for a sample mean or proportion, calculate the test statistic and use the NORMSINV
function to find the critical value for the desired level of significance.
Common Mistakes
NORMSINV
not working? Here are some common mistakes people make when using the NORMSINV
Google Sheets Formula:
Incorrect argument type
One common mistake is using an argument that is not a number. Make sure to only use numeric values for the x argument.
Invalid input value
Another mistake is using an input value that is not between 0 and 1. The NORMSINV function only works for probabilities between 0 and 1.
Missing argument
A common mistake is forgetting to provide the required x argument. Make sure to include the x argument in the function.
Incorrect function name
Another mistake is misspelling the function name. Make sure to use the correct spelling of NORMSINV.
Formula not supported
This formula may not be supported in some older versions of Google Sheets. Make sure you are using the latest version of Sheets and check the documentation for your specific version.
Related Formulas
The following functions are similar to NORMSINV
or are often used with it in a formula:

NORMINV
The
NORMINV
function returns the inverse of the normal cumulative distribution for a specified value, mean, and standard deviation. It is commonly used in statistics to find the value at which a given percentage of observations lie below that value. 
NORMDIST
The
NORMDIST
function in Google Sheets calculates the normal distribution for a specified value, mean, and standard deviation. It returns the probability of a value occurring within a specified range of a normal distribution. It is commonly used in statistics, finance, and science to analyze data and make predictions. 
STANDARDIZE
The
STANDARDIZE
function is a statistical function used to standardize a given value based on a specified mean and standard deviation. This is useful for comparing values that are measured on different scales. The function returns a zscore, which represents the number of standard deviations a value is from the mean. The formula used is: (value  mean) / standard_deviation.
Learn More
You can learn more about the NORMSINV
Google Sheets function on Google Support.