Changes

Manuals/calci/NORMDIST (view source)

Revision as of 08:27, 1 January 2014

667 bytes added , 08:27, 1 January 2014

no edit summary

Line 1: Line 1: −

<div id="~~6SpaceContent" class="zcontent" align="left"><~~font ~~color="#000000"><font~~ size~~="2~~">'''NORMDIST~~'''~~(~~'''n'''~~,~~'''~~ m, sd'''</~~font~~></~~font><~~font size="2"~~>,</~~font></font~~>~~~~<~~font size="2">''' c'''</font~~></~~font~~>~~~~<~~font size="2"~~>)</~~font~~><~~/font>~~</~~font>

+

<div style="font-size:30px">'''NORMDIST(x,m,sd,cu)'''</div>

+

*<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.

−

<~~font color="#000000"~~><~~font face="Arial~~, ~~sans-serif"~~><~~font size="2"~~>~~'''Where n'''~~<~~/font~~></~~font~~><~~font face="Arial, sans-serif"~~><~~font size="2"~~> is the value for ~~which~~ the distribution is ~~calculate~~ ,m is the ~~arithmetic~~ mean of the distribution and <~~/font></~~font>'''sd''' is the standard deviation of the 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 <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.

+

*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.

+

*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.

+

when cu is TRUE , this formula is the integral from -infinity to x and cu is FALSE , we can use the same formula.

+

font>'''sd''' is the standard deviation of the distribution.

'''c''' is a logical value that determines the form of the function.

Line 38: Line 50:

i.e. =NORMDIST (52, 50, 2.5, true) is 0.7885

−

<nowiki~~>=NORMDIST (52, 50, 2.5, false)</nowiki>~~ is 0.1159.

+

UNIQcc0d9c136de91e77-nowiki-00000002-QINU is 0.1159.

</div>

Devika

writer

6,694

edits