NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel

NORM.S.INV function: The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1. Support from Excel 2010 onwards. Syntax: NORM.S.INV (probability)

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

NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 1NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 1

Description: The function returns the inverse value of the normalized distribution with a mean value of 0 and a standard deviation of 1. The function supports Excel 2010 and later versions.

Syntax: NORM.S.INV (probability)

Inside:

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

Attention:

- If probability is not number -> the function returns the #VALUE! Error value

- If probability ≤ 0 or probability ≥ 1 -> the function returns the #NUM! Error value

For example:

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

NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 2NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 2

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

NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 3NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 3

- Press Enter -> the inverse value of the normal distribution function is:

NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 4NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 4

- In case the probability value is greater than 1 or less than 0 -> the function returns the #NUM! Error value

NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 5NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 5

- Where the probability value is not a number -> the function returns the #VALUE! Error value

NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 6NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel Picture 6

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

Good luck!

5 ★ | 1 Vote