NORMSINV

Calculates the inverse of the standard normal cumulative distribution to find the z-score for a given probability with a mean of 0 and a standard deviation of 1.

The NORMSINV function returns the inverse of the standard normal cumulative distribution. It assumes a distribution with a mean of 0 and a standard deviation of 1.

Syntax

NORMSINV(probability)

Arguments

The NORMSINV function syntax has the following required arguments:

• probability - A probability corresponding to the normal distribution. Required.

Example

NORMSINV(0.90)
// Returns 1.28

You can use the NORMSINV function to determine the number of standard deviations a value is from the mean. This is particularly useful for creating standardized benchmarks or z-scores across different datasets to compare them on a level playing field.

NORMSINV function

Excel Equivalent

NORMSINV

FAQs

Q1. What is the difference between NORMINV and NORMSINV?

• NORMINV allows you to specify any mean and standard deviation for your dataset.

• NORMSINV is a specialized version that always uses a mean of 0 and a standard deviation of 1.