NORM.S.INV

Formulas / NORM.S.INV
Calculate the inverse of the standard normal cumulative distribution.
=NORM.S.INV(probability)
  • probability - required, corresponds to the normal distribution

Examples

  • =NORM.S.INV(1.75)

    The NORM.S.INV function can be used to calculate a probability from a given z-score. For example, if the z-score is 1.75, the probability can be calculated using the preceding formula. The result of this formula is 0.9608, which is the probability of a value being less than or equal to 1.75.

  • =NORM.S.INV(0.5)

    The NORM.S.INV function can also be used to calculate a z-score from a given probability. For example, if the probability is 0.5, the z-score can be calculated using the preceding formula. The result of this formula is 0, which is the z-score that corresponds to a probability of 0.5.

  • =NORM.S.INV(-1.25)

    The NORM.S.INV function can also be used to calculate a cumulative probability from a given z-score. For example, if the z-score is -1.25, the cumulative probability can be calculated using the preceding formula. The result of this formula is 0.1056, which is the cumulative probability of a value being less than or equal to -1.25.


Summary

NORM.S.INV is a function that calculates the inverse of the standard normal cumulative distribution. It has a mean of 0 and a standard deviation of 1 and uses an iterative search technique to find the inverse.

  • The NORM.S.INV function takes a probability argument that corresponds to the standard normal distribution, and returns a z-score which measures how far a value is from the mean of the distribution in terms of the standard deviation.

Frequently Asked Questions

What is the NORM.S.INV function?
The NORM.S.INV function is a statistical function that calculates the inverse of the standard normal cumulative distribution. This is useful for determining the probability associated with a given score on a normal distribution.
What is the mean and standard deviation of the distribution?
The mean of the distribution is 0 and the standard deviation is 1.
How does the NORM.S.INV function work?
The NORM.S.INV function uses an iterative search technique to find the inverse of the standard normal cumulative distribution. This means that the function continually searches for the inverse of the standard normal cumulative distribution until the desired result is achieved.
What are some examples of how the NORM.S.INV function can be used?
  • Calculate the probability associated with a given score on a normal distribution.
  • Determine the percentile associated with a given score.
  • Estimate the probability of a given event occurring.

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