Table of Contents
This guide provides a practical overview of NORM. DIST Function, including its main features, benefits, limitations, and important considerations.
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:
- Calculate cumulative standard distribution (corresponding to True value ) . In a cell to calculate, enter the formula : = NORM. DIST (D6, D7, D8, D9)
- Press Enter -> cumulative standard distribution is:
- 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)
- Press Enter -> the probability function value is:
- 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!
FAQ
What does the NORM. DIST Function function do in Excel?
The NORM. DIST Function function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the NORM. DIST Function function correctly?
Start with an equals sign, enter NORM. DIST Function, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the NORM. DIST Function function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Reader Comments 0
Sign in with email or Google to join the discussion.