Changes

Jump to navigation Jump to search
Line 8: Line 8:  
*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) ,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 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: <math> f(x,\mu,\sigma)=\frac{1}{\sigma \sqrt{2\pi}}.e^-\left({\frac{(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: <math> f(x,\mu,\sigma)=\frac{1}{\sigma \sqrt{2\pi}}.e^{-\left({\frac{(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.  
 
*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.
 
*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>.
 
   This function will return the result as error when  any one of the argument is non-numeric and <math>sd<=0</math>.
writer
5,435

edits

Navigation menu