Changes

Jump to navigation Jump to search
no edit summary
Line 1: Line 1:  
<div style="font-size:30px">'''NORMDIST(x,m,sd,cu)'''</div><br/>
 
<div style="font-size:30px">'''NORMDIST(x,m,sd,cu)'''</div><br/>
*<math>x</math> is the value,<math>m</math> is the mean,<math>sd</math> is the standard deviation and <mathcu</math> is the logical value like TRUE or FALSE.
+
*<math>x</math> is the value,<math>m</math> is the mean,<math>sd</math> is the standard deviation and <math>cu</math> is the logical value like TRUE or FALSE.
    
==Description==  
 
==Description==  
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 give the probability mass function.  
 
*Suppose cu is TRUE, this function gives the cumulative distribution, and it is FALSE, this function give the probability mass function.  
*The equation for the normal distribution is: f(x,μ,σ)=1/σsqrt(2pi()).e^-{(x-μ)^2/2σ^2}, where \mu is the mean of the distribution,\sigma is the standard deviation of the distribution.  
+
*The equation for the normal distribution is:<math> f(x,\mu,\sigma)=1/σsqrt(2pi()).e^-{(x-μ)^2/2σ^2}</math>, 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.
 
*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 nonnumeric and sd<=0.
 
*This function will return the result as error when  any one of the argument is nonnumeric and sd<=0.
writer
6,694

edits

Navigation menu