NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel

NORM.DIST: The function returns the normal distribution with a standard deviation and a defined mean. Functions widely used in hypothesis testing statistics. Support functions from Excel 2010 onwards. Syntax: NORM.DIST (x, mean, standard_dev, cumulative)

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

NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 1NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 1

Description: The function returns the normal distribution with a specified standard deviation and mean. Functions widely used in hypothesis testing statistics. Support functions from Excel 2010 onwards.

Syntax: NORM.DIST (x, mean, standard_dev, cumulative)

Inside:

- x: The value you want to calculate 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.

- cumulative: A logical value that determines the form of the function, which is a required parameter, including:

+ cumulative = True -> returns the cumulative distribution function.

+ cumulative = False -> returns the probability density function.

Attention:

- If mean, standard_dev is not an integer -> they are truncated to integers.

- If mean, standard_dev 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 and cumulative = TRUE -> the function returns the normal distribution.

- The equation for the standard density function (cumulative = True) is:

[f (x; mu, sigma) = frac {1} {{sqrt {2pi} sigma}} {e ^ {- left ({frac {{{{left ({N - mu} right)} ^ 2}} } {{2 {sigma ^ 2}}}} right)}}]

- If cumulative = True -> the formula is integral from negative infinity to x.

For example:

Find the cumulative and probability normal distribution with the values ​​in the data table below:

NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 2NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 2

- Calculate cumulative standard distribution (corresponding to True value ) . In a cell to calculate, enter the formula : = NORM.DIST (D6, D7, D8, D9)

NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 3NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 3

- Press Enter -> cumulative standard distribution is:

NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 4NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 4

- Calculate the value of the probability block function (corresponding to the value of False) . In a cell to calculate, enter the formula : = NORM.DIST (D6, D7, D8, D10)

NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 5NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 5

- Press Enter -> the probability function value is:

NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 6NORM.DIST function - The function returns the normal distribution with the standard deviation and the mean value specified in Excel Picture 6

- There is a rather large difference in value between the cumulative standard distribution function and the probability distribution.

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

Good luck!

5 ★ | 2 Vote