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({\tfrac {(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 non-numeric and $sd<=0$.

• when $cu$ is TRUE , this formula is the integral from $-\infty$ 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

References

Normal distribution