Excel Function : NORMSINV

Download now!

Excel Function : NORMSINV

Category

Compatibility

Description

Returns the inverse of the standard normal cumulative distribution

Microsoft Excel Reference Page

https://support.office.com/en-us/article/NORMSINV-function-8d1bce66-8e4d-4f3b-967c-30eed61f019d

Syntax and Description of the NORMSINV Excel Function

The syntax for the NORMSINV excel function is: = NORMSINV ( probability ) Where the probability argument is the probability corresponding to the normal distribution. NORMSINV function examples NORMSINV function example 1 For this example, we want to find the value for a normal distribution that corresponds to the probability of 0.5. To do this, we use the following formula: = NORMSINV ( 0.5 ) This formula returns the value 0, which is the median value for a normal distribution. NORMSINV function example 2 For this example, we want to find the value for a normal distribution that corresponds

About NORMSINV Excel Function

The NORMSINV function returns the inverse of the normal cumulative distribution for a given mean and standard deviation.