Difference between revisions of "Manuals/calci/NORMSDIST"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''NORMSDIST'''('''x''') '''Where x''' is the value for which the distribution. </div> ---- <div id="1Spa...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''NORMDIST(x)'''</div><br/> |
| + | *<math>x</math> is the value of the function | ||
| − | |||
| − | + | ==Description== | |
| + | *This function gives the Standard normal cumulative distribution function. | ||
| + | *In normal distribution formula, when the mean is zero and the standard deviation is 1 then it is called Standard normal distribution. | ||
| + | *The equation for the standard normal density function is:<math> f(x)=\frac{1){\sqrt(2)\ pi}. e^-{\frac{x^2}{2}}</math> | ||
| + | *This function will return the result as error when the x value is nonnumeric. | ||
| − | + | ==Examples== | |
| − | + | #NORMSDIST(4.74)=0.9999975333 | |
| − | + | #NORMSDIST(5.0021)=0.9999999738 | |
| − | + | #NORMSDIST(1.00006)=0.8413586589 | |
| − | + | #NORMSDIST(12)=1.0000002451499 | |
| − | + | ==See Also== | |
| + | *[[Manuals/calci/NORMDIST | NORMDIST ]] | ||
| + | *[[Manuals/calci/NORMINV | NORMINV ]] | ||
| + | *[[Manuals/calci/NORMSINV | NORMSINV ]] | ||
| − | + | ==References== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 03:19, 2 January 2014
NORMDIST(x)
- is the value of the function
is the value of the function
Description
- This function gives the Standard normal cumulative distribution function.
- In normal distribution formula, when the mean is zero and the standard deviation is 1 then it is called Standard normal distribution.
- The equation for the standard normal density function 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)=\frac{1){\sqrt(2)\ pi}. e^-{\frac{x^2}{2}}}
- This function will return the result as error when the x value is nonnumeric.
Examples
- NORMSDIST(4.74)=0.9999975333
- NORMSDIST(5.0021)=0.9999999738
- NORMSDIST(1.00006)=0.8413586589
- NORMSDIST(12)=1.0000002451499