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.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel
NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel

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 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 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 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 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 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 6

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

Good luck!

Jessica Tanner

Update 19 May 2020

You should read it

May be interested

PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel
percentrank.exc function: the function returns the rank of a value in a dataset as a percentage excluding values 0 and 1. the function supports excel 2010 and later versions. syntax: percentrank.exc (array, x, [significance])
PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel
percentrank.inc function: the function returns the rank of a value in a dataset as a percentage including values 0 and 1. the function supports excel 2010 and later versions. syntax: percentrank.inc (array, x, [significance])
PROB function - The function returns the probability that values in a range are between two limits in Excel
prob function: the function returns the probability that values in a range are between two limits. syntax: prob (x_range, prob_range, [lower_limit], [upper_limit])
RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excel
rank.eq function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the highest rank. support functions from execl 2010 version onwards.
Operations with blocks in Excel
the following article shows you how to manipulate blocks in excel. frequently used operations in spreadsheets when working with blocks: 1. select blocks of contiguous cells. place the mouse cursor in the first cell position of the block - hold the left mouse button dragging
How to enter formula data in Excel
show you how to enter formula data in excel. working with excel you can not help but work with formulas and functions in excel. formula data input is a type of data entry through data that is available based on a calculation or 1