| Line 1: |
Line 1: |
| − | <div id="6SpaceContent" class="zcontent" align="left"> | + | <div style="font-size:30px">'''NORMDIST(x)'''</div><br/> |
| | + | *<math>x</math> is the value of the function |
| | | | |
| − | '''NORMSDIST'''('''x''')
| |
| | | | |
| − | '''Where x''' is the value for which the distribution.
| + | ==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. |
| | | | |
| − | </div>
| + | ==Examples== |
| − | ----
| + | #NORMSDIST(4.74)=0.9999975333 |
| − | <div id="1SpaceContent" class="zcontent" align="left">It calculates the standard normal cumulative distribution function. </div>
| + | #NORMSDIST(5.0021)=0.9999999738 |
| − | ----
| + | #NORMSDIST(1.00006)=0.8413586589 |
| − | <div id="7SpaceContent" class="zcontent" align="left"><font size="2" color="#7f7f7f" face="Arial">
| + | #NORMSDIST(12)=1.0000002451499 |
| | | | |
| − | · For nonnumeric NORMSDIST displays zero..
| + | ==See Also== |
| | + | *[[Manuals/calci/NORMDIST | NORMDIST ]] |
| | + | *[[Manuals/calci/NORMINV | NORMINV ]] |
| | + | *[[Manuals/calci/NORMSINV | NORMSINV ]] |
| | | | |
| − | · The equation for the standard normal density function is:
| + | ==References== |
| − | | |
| − | </font><br /></div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
| − | | |
| − | NORMSDIST
| |
| − | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | <font size="3"><font face="Times New Roman">Let’s see an example in (Column1 Row 1)</font></font>
| |
| − | | |
| − | <font size="3">i.e.=NORMSDIST(C1R1)</font>
| |
| − | | |
| − | <font size="3">i.e.=NORMSDIST(1.433335) is 0.9221</font>
| |
| − | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
| |
| − | ----
| |
| − | <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
| |
| − | ----
| |
| − | <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
| |
| − | ----
| |
| − | <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
| |
| − | ----
| |
| − | <div id="2SpaceContent" class="zcontent" align="left"><div>
| |
| − | | |
| − | {| id="TABLE3" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | | Column1
| |
| − | | class=" " | Column2
| |
| − | | class=" " | Column3
| |
| − | | class=" " |
| |
| − | | class=" " | Column4
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class="sshl_f" | 1.433335
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | | class="sshl_f SelectTD SelectTD" | 0.9221
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class=" " |
| |
| − | | class="sshl_f" |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |
| |
| − | | class=" " |
| |
| − | | class="sshl_f" |
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | class="sshl_f" | Row5
| |
| − | | class="sshl_f" |
| |
| − | | class=" " |
| |
| − | |
| |
| − | |
| |
| − | | class=" " |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | class=" " | Row6
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |
| |
| − | | class="sshl_f" |
| |
| − | |
| |
| − | |
| |
| − | |}
| |
| − | | |
| − | <div align="left"></div>''''''</div></div>
| |
| − | ----
| |