NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel

NORM.INV function: The function returns the inverse of the standard cumulative distribution with the standard deviation and the specified mean. Support functions from Excel 2010 onwards. Syntax: NORM.INV (probability, mean, standard_dev)

The following article introduces you to the NORM.INV function - one of the functions in the group of statistical functions that is very popular in Excel.

NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 1NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 1

Description: The function returns the inverse of the standard cumulative distribution with the specified standard deviation and mean. Support functions from Excel 2010 onwards.

Syntax: NORM.INV (probability, mean, standard_dev)

Inside:

- probability: Probability corresponding to the normal distribution, is a required parameter .

- mean: Arithmetic mean of distribution, is a required parameter.

- standard_dev: The standard deviation of the distribution, is a required parameter.

Attention:

- If any argument of the function is not a number -> the function returns the #VALUE! Error value

- If standard_dev ≤ 0 -> the function returns the #NUM! Error value

- If mean = 0 , standard_dev = 1 -> function returns normalized distribution.

For example:

Find the inverse value of the cumulative normal distribution with the values ​​in the data table below:

NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 2NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 2

- In the cell to calculate, enter the formula : = NORM.INV (D6, D7, D8)

NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 3NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 3

- Press Enter -> the inverse value of the cumulative standard distribution is:

NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 4NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 4

- Where mean = 0 , standard_dev = 1 -> function returns normalized distribution.

NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 5NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 5

- Where standard_dev ≤ 0 -> the function returns the #NUM! Error value

NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 6NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel Picture 6

Above are instructions and some specific examples when using the NORM.INV function in Excel.

Good luck!

4 ★ | 2 Vote