|
|
| Line 26: |
Line 26: |
| | | | |
| | ==References== | | ==References== |
| − |
| |
| − |
| |
| − |
| |
| − |
| |
| − | '''NORMSINV'''('''p''')
| |
| − |
| |
| − | '''Where p''' is a probability equivalent to the normal distribution.
| |
| − |
| |
| − | </div>
| |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left">It calculates the inverse of the standard normal cumulative distribution.</div>
| |
| − | ----
| |
| − | <div id="7SpaceContent" class="zcontent" align="left">
| |
| − |
| |
| − | · For nonnumeric p ,NORMSINV shows error.
| |
| − |
| |
| − | · When p< 0 or p> 1, NORMSINV displays error.
| |
| − |
| |
| − | </div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
| − |
| |
| − | NORMSINV
| |
| − |
| |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="3"><font color="#000000"><font face="Times New Roman, serif"><font size="3">
| |
| − |
| |
| − | <font size="3"><font face="Times New Roman">Let’s see an example in (Column1 Row 1)</font></font>
| |
| − |
| |
| − | <font size="3">i.e.=</font>''' '''NORMSINV<font size="3"> (C1R1)</font>
| |
| − |
| |
| − | <font size="3">i.e.=</font> NORMSINV<font size="3"> (0.80879) is 0.8734</font>
| |
| − |
| |
| − | </font></font></font></font></font></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="5SpaceContent" class="zcontent" align="left"><div>
| |
| − |
| |
| − | {| id="TABLE1" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | | Column1
| |
| − | | class=" " | Column2
| |
| − | | class=" " | Column3
| |
| − | | class=" " |
| |
| − | | class=" SelectTD SelectTD" |
| |
| − | <div id="5Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="5Space_Copy" title="Click and Drag over to AutoFill other cells."></div>Column4
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class="sshl_f" | 0.80879
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class="sshl_f" | 0.8734460503371548
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | | class="sshl_f" |
| |
| − | | 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>
| |
| − | ----
| |
prob is the probability value.
, then 
.
using the iterating method to find the value of x.
, where prob is the probability value of the standard normal cumulative distribution.