Check Sheet Logo
Check Sheet

NORMSINV

The NORMSINV 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.

Usage

Use the NORMSINV formula with the syntax shown below, it has 1 required parameter:

=NORMSINV(x)
Parameters:
  1. 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 the NORMSINV formula in Google Sheets.

Calculate a z-score

To calculate a z-score 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 z-score 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 z-score, 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.