NORM.S.INV
Formulas / NORM.S.INVCalculate 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?
What is the mean and standard deviation of the distribution?
How does the NORM.S.INV function work?
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.
