Manuals/calci/NORMDIST

NORMDIST (Number,Mean,StandardDeviation,Cumulative,accuracy)

• $Number$ is the value.
• $Mean$ is the mean.
• $StandardDeviation$ is the standard deviation
• $Cumulative$ is the logical value like TRUE or FALSE.
• $Accuracy$ is correct decimal places for the result.
  • NORMDIST(),returns the normal cumulative distribution.

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(Number,Mean,StandardDeviation,Cumulative,accuracy)$), $Number$ is the value of the function, $Mean$ is the Arithmetic Mean of the distribution, $StandardDeviation$ is the Standard Deviation of the distribution and $Cumulative$ is the Logical Value that indicating the form of the function.
• Suppose $Cumulative$ 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 $StandardDeviation<=0$.

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

Related Videos

NORMDIST

See Also

• NORMINV
• NORMSDIST
• NORMSINV

References

Normal distribution

• List of Main Z Functions

• Z3 home