Difference between revisions of "Manuals/calci/NORMDIST"

Latest revision as of 16:20, 10 August 2018

NORMDIST (Number,Mean,StandardDeviation,Cumulative,accuracy)

$Number$ is the value.
$Mean$ is the mean.
$StandardDeviation$ is the standard deviation
$Cumulative$ is the logical value like TRUE or FALSE.
is correct decimal places for the result.
- NORMDIST(),returns the normal cumulative 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 $NORMDIST(Number,Mean,StandardDeviation,Cumulative,accuracy)$ ), $Number$ is the value of the function, $Mean$ is the Arithmetic Mean of the distribution, $StandardDeviation$ is the Standard Deviation of the distribution and $Cumulative$ is the Logical Value that indicating the form of the function.
Suppose $Cumulative$ 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:

 $f(x,\mu ,\sigma )={\frac {1}{\sigma {\sqrt {2\pi }}}}.e^{-\left({\tfrac {(x-\mu )^{2}}{2\sigma ^{2}}}\right)}$

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 non-numeric and  $StandardDeviation<=0$ .

when $Cumulative$ is TRUE , this formula is the integral from $-\infty$ to $Number$ and $Cumulative$ is FALSE , we can use the same formula.

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

References

Normal distribution

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''NORMDIST(x,m,sd,cu)'''</div><br/>
+<div style="font-size:30px">'''NORMDIST (Number,Mean,StandardDeviation,Cumulative,accuracy)'''</div><br/>
-*<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.
+*<math>Number</math> is the value.
+*<math>Mean</math> is the mean.
+*<math>StandardDeviation</math> is the standard deviation
+*<math>Cumulative</math> is the logical value like TRUE or FALSE.
+*<math>Accuracy</math> is correct decimal places for the result.
+**NORMDIST(),returns the normal cumulative distribution.
 ==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 (Number,Mean,StandardDeviation,Cumulative,accuracy)</math>), <math>Number</math> is the value of the function, <math>Mean</math> is the Arithmetic Mean of the distribution, <math>StandardDeviation</math> is the Standard Deviation of the distribution and <math>Cumulative</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>Cumulative</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({\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:
-*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.
-*when <math>cu</math> is TRUE , this formula is the integral from -<math>\infite</math> to <math>x</math> and <math>cu</math> is FALSE , we can use the same formula.
+*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>StandardDeviation<=0</math>.
+*when <math>Cumulative</math> is TRUE , this formula is the integral from <math>-\infty</math> to <math>Number</math> and <math>Cumulative</math> is FALSE , we can use the same formula.
 ==Examples==
-#NORMDIST(37,29,2.1,FALSE)=0.000134075
+#=NORMDIST(37,29,2.1,FALSE) = 0.000134075
-#NORMDIST(37,29,2.1,TRUE)=0.99993041384
+#=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,TRUE) = 0.01884908749
-#NORMDIST(10.75,17.4,3.2,FALSE)=0.014387563
+#=NORMDIST(10.75,17.4,3.2,FALSE) = 0.014387563
+==Related Videos==
+{{#ev:youtube|jMFs_1gmqWw|280|center|NORMDIST}}
 ==See Also==
@@ Line 25: / Line 36: @@
 ==References==
+[http://en.wikipedia.org/wiki/Normal_distribution Normal distribution ]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/NORMDIST"

Latest revision as of 16:20, 10 August 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search