| Line 3: |
Line 3: |
| | | | |
| | ==Description== | | ==Description== |
| − | *This function gives the normal distribution for the particular mean and standard deviation. | + | *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. | + | *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. | + | *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 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. | + | *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 cumulative distribution, and it is FALSE, this function gives the probability mass function. | + | *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 normal distribution is: <math> f(x,\mu,\sigma)=\frac{1}{\sigma \sqrt{2\pi}}.e^{-\left({\tfrac{(x-\mu)^2}{2\sigma^2}}\right)}</math> where <math>\mu</math> is the mean of the distribution,<math>\sigma</math> is the standard deviation of the distribution. | + | *The equation for the Normal Distribution is: |
| − | *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. | + | <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 any one of the argument is non-numeric and <math>sd<=0</math>. | + | 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. |
| | | | |