Manuals/calci/NORMDIST

NORMDIST(x,m,sd,cu)

• $x$ is the value,$m$ is the mean,$sd$ is the standard deviation and $cu$ is the logical value like TRUE or FALSE.

Description

• This function gives the normal distribution for the particular mean and standard deviation.
• Normal distribution is the function that represents the distribution of many random variables as a symmetrical bell-shaped graph.
• This distribution is the continuous probability distribution.It is also called Gaussian distribution.
• In $NORMDIST(x,m,sd,cu),x$ is the value of the function,$m$ is the arithmetic mean of the distribution, $sd$ is the standard deviation of the distribution and $cu$ is the logical value that indicating the form of the function.
• Suppose cu is TRUE, this function gives the cumulative distribution, and it is FALSE, this function gives the probability mass function.
• The equation for the normal distribution is: $f(x,\mu ,\sigma )={\frac {1}{\sigma {\sqrt {2\pi }}}}.e^{-}\left({\frac {(x-\mu )^{2}}{2\sigma ^{2}}}\right)$ where $\mu$ is the mean of the distribution,$\sigma$ is the standard deviation of the distribution.
• In this formula, Suppose $\mu$ = 0 and $\sigma$= 1, then the distribution is called the standard normal distribution or the unit normal distribution.
• This function will return the result as error when any one of the argument is nonnumeric and sd<=0.

when cu is TRUE , this formula is the integral from -infinity to x and cu is FALSE , we can use the same formula.

Examples

1. NORMDIST(37,29,2.1,FALSE)=0.000134075
2. NORMDIST(37,29,2.1,TRUE)=0.99993041384
3. NORMDIST(10.75,17.4,3.2,TRUE)=0.01884908749
4. NORMDIST(10.75,17.4,3.2,FALSE)=0.014387563

See Also

• NORMINV
• NORMSDIST
• NORMSINV