NORMINV

Formulas / NORMINV
Calculate the inverse of the normal cumulative distribution.
=NORMINV(probability,mean,standard_dev)
  • Probability - required argument that corresponds to the normal distribution
  • Mean - required argument that is the average of the distribution
  • Standard_dev - required argument that is the standard deviation of the data set

Examples

  • =NORMINV(0.5,0,1)

    The NORMINV function can be used to calculate the inverse of the normal cumulative distribution. For example, this returns the inverse of the normal cumulative distribution of 0.5 with a mean of 0 and standard deviation of 1, which is 0.

  • =NORMINV(0.4,3,2)

    The NORMINV function can be used to calculate the inverse of the normal cumulative distribution when the mean and standard deviation are known. For example, if the mean is 3 and standard deviation is 2, which returns the inverse of the normal cumulative distribution of 0.4, which is 1.68.

  • =NORMINV(A2,A3,A4)

    The NORMINV function can be used to calculate the inverse of the normal cumulative distribution with multiple arguments. For example, this returns the inverse of the normal cumulative distribution for the values in A2, A3, and A4.

  • =NORMINV(0.36,B1,B2)

    The NORMINV function can be used to calculate the inverse of the normal cumulative distribution when the parameters are unknown. For example, this returns the inverse of the normal cumulative distribution of 0.36 when the mean and standard deviation are unknown and stored in B1 and B2.


Summary

The NORMINV function calculates the inverse of the normal distribution, but has been replaced by more accurate functions. These new functions are more accurately named and use an iterative search technique to return the inverse of the normal cumulative distribution.

  • The NORMINV function has been replaced with new functions that provide better results and accuracy.
  • The new functions use an iterative search technique to return the inverse of the normal distribution.

Frequently Asked Questions

What is the NORMINV function?
The NORMINV function is used to calculate the inverse of the normal cumulative distribution.
What has replaced the NORMINV function?
The NORMINV function has been replaced with more accurate functions that better reflect their usage.
How does the NORMINV function work?
The NORMINV function uses an iterative search technique to return the inverse of the normal cumulative distribution.
What are the advantages of using the NORMINV function?
  • It is a fast and efficient way to calculate the inverse of the normal cumulative distribution.
  • The new functions are more accurate than the NORMINV function.

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