ZCubes Wiki

Difference between revisions of "Manuals/calci/NORMDIST"
 
(10 intermediate revisions by 4 users not shown)
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==  
 
==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>-\infty</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==
 
==Examples==
Line 18: Line 25:
 
#=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==
 
==See Also==
Line 25: Line 36:
  
 
==References==
 
==References==
 +
[http://en.wikipedia.org/wiki/Normal_distribution Normal distribution ]
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 16:20, 10 August 2018

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


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number} is the value.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Mean} is the mean.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle StandardDeviation} is the standard deviation
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Cumulative} is the logical value like TRUE or FALSE.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Accuracy} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NORMDIST (Number,Mean,StandardDeviation,Cumulative,accuracy)} ), Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number} is the value of the function, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Mean} is the Arithmetic Mean of the distribution, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle StandardDeviation} is the Standard Deviation of the distribution and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Cumulative} is the Logical Value that indicating the form of the function.
  • Suppose Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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:
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle  f(x,\mu,\sigma)=\frac{1}{\sigma \sqrt{2\pi}}.e^{-\left({\tfrac{(x-\mu)^2}{2\sigma^2}}\right)}}

where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \mu} is the Mean of the distribution, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \sigma} is the Standard Deviation of the distribution.

  • In this formula, suppose Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \mu} = 0 and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle StandardDeviation<=0}
.
  • when Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Cumulative} is TRUE , this formula is the integral from Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle -\infty} to Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Cumulative} is FALSE , we can use the same formula.

Examples

  1. =NORMDIST(37,29,2.1,FALSE) = 0.000134075
  2. =NORMDIST(37,29,2.1,TRUE) = 0.99993041384
  3. =NORMDIST(10.75,17.4,3.2,TRUE) = 0.01884908749
  4. =NORMDIST(10.75,17.4,3.2,FALSE) = 0.014387563

Related Videos

NORMDIST

See Also

References

Normal distribution


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/NORMDIST&oldid=211036"