Difference between revisions of "Manuals/calci/NORMDIST"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
==Description== | ==Description== | ||
| − | *This function gives the | + | *This function gives the Normal Distribution for the particular Mean and Standard Deviation. |
| − | *Normal | + | *Normal Distribution is the function that represents the distribution of many random variables as a symmetrical bell-shaped graph. |
| − | *This distribution is the | + | *This distribution is the Continuous Probability Distribution.It is also called Gaussian Distribution. |
| − | *In <math> NORMDIST(x,m,sd,cu) ,x</math> is the value of the function,<math> m</math> is the | + | *In <math> NORMDIST(x,m,sd,cu</math>), <math>x</math> is the value of the function, <math>m</math> is the Arithmetic Mean of the distribution, <math>sd</math> is the Standard Deviation of the distribution and <math>cu</math> is the Logical Value that indicating the form of the function. |
| − | *Suppose cu is TRUE, this function gives the | + | *Suppose <math>cu</math> is TRUE, this function gives the Cumulative Distribution, and it is FALSE, this function gives the Probability Mass Function. |
| − | *The equation for the | + | *The equation for the Normal Distribution is: |
| − | *In this formula, | + | <math> f(x,\mu,\sigma)=\frac{1}{\sigma \sqrt{2\pi}}.e^{-\left({\tfrac{(x-\mu)^2}{2\sigma^2}}\right)}</math> |
| − | This function will return the result as error when | + | where <math>\mu</math> is the Mean of the distribution, <math>\sigma</math> is the Standard Deviation of the distribution. |
| + | *In this formula, suppose <math>\mu</math> = 0 and <math>\sigma</math>= 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 <math>sd<=0</math>. | ||
*when <math>cu</math> is TRUE , this formula is the integral from <math>-\infty</math> to <math>x</math> and <math>cu</math> is FALSE , we can use the same formula. | *when <math>cu</math> is TRUE , this formula is the integral from <math>-\infty</math> to <math>x</math> and <math>cu</math> is FALSE , we can use the same formula. | ||
Revision as of 00:28, 22 January 2014
NORMDIST(x,m,sd,cu)
- is the value, is the mean, is the standard deviation and is the logical value like TRUE or FALSE.
is the value,
is the mean,
is the standard deviation and 
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 ), is the value of the function, is the Arithmetic Mean of the distribution, is the Standard Deviation of the distribution and is the Logical Value that indicating the form of the function.
- Suppose 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:
), 
where is the Mean of the distribution, is the Standard Deviation of the distribution.
is the Mean of the distribution, 
is the Standard Deviation of the distribution.
- In this formula, suppose = 0 and = 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 .
.
- when is TRUE , this formula is the integral from to and is FALSE , we can use the same formula.
to Examples
- =NORMDIST(37,29,2.1,FALSE) = 0.000134075
- =NORMDIST(37,29,2.1,TRUE) = 0.99993041384
- =NORMDIST(10.75,17.4,3.2,TRUE) = 0.01884908749
- =NORMDIST(10.75,17.4,3.2,FALSE) = 0.014387563