NORM.INV

Formulas / NORM.INV
Calculate the inverse of the normal cumulative distribution.
=NORM.INV(probability,mean,standard_dev)
  • Probability - required, probability associated with the normal distribution
  • Mean - required, average of the distribution
  • Standard_dev - required, standard deviation of the data set

Examples

  • =NORM.INV(0.5, 0, 1)

    Using the NORM.INV function requires three arguments: the probability, the mean and the standard deviation. For example, to find the inverse of the normal cumulative distribution for a probability of 0.5, a mean of 0 and a standard deviation of 1, the syntax of the function can be found above.

  • =NORM.INV(0.8, 10, 3)

    The NORM.INV function can also be used to find the value of a given probability for a normal distribution with a known mean and standard deviation. For example, if the mean is 10 and the standard deviation is 3, the syntax of the function to find the value of a probability of 0.8 would be found above.

  • =NORM.INV(12, 10, 3)

    The NORM.INV function can also be used to calculate the probability of a given value for a normal distribution with a known mean and standard deviation. For example, if the mean is 10 and the standard deviation is 3, the syntax of the function to find the probability of a value of 12 would be found above.

  • =NORM.INV(0.95, 10, 3)

    The NORM.INV function can also be used to calculate the value at which a given probability occurs for a normal distribution with a known mean and standard deviation. For example, if the mean is 10 and the standard deviation is 3, the syntax of the function to find the value of a probability of 0.95 would be found above.


Summary

The NORM.INV function is used to calculate the inverse of the normal distribution given the probability, mean, and standard_dev arguments. It is a necessary tool for data analysis.

  • The NORM.INV function returns the probability threshold value for a given probability input within the range (0,1).
  • The NORM.INV function calculates the inverse of the normal distribution, allowing users to determine the probability of a given value occurring.

Frequently Asked Questions

What is the NORM.INV function?
The NORM.INV function is used to calculate the inverse of the normal distribution.
What arguments are required for the NORM.INV function?
  • Probability
  • Mean
  • Standard deviation
What is the purpose of the NORM.INV function?
The NORM.INV function is used to calculate the probability of a given value using the normal distribution. It is commonly used in statistics and probability theory.
What is the difference between the NORM.INV and NORM.DIST functions?
The NORM.INV function is used to calculate the inverse of the normal distribution while the NORM.DIST function is used to calculate the normal distribution.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV