writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − '''NORMSDIST'''('''x''') − '''Where x''' is the value for which the distribution.+ + + + + − </div>+ − ----+ − <div id="1SpaceContent" class="zcontent" align="left">It calculates the standard normal cumulative distribution function. </div>+ − ----+ − <div id="7SpaceContent" class="zcontent" align="left"><font size="2" color="#7f7f7f" face="Arial">+ − · For nonnumeric NORMSDIST displays zero..+ + + + − · The equation for the standard normal density function is:+ − − </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> − ----
no edit summary
<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
==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==