|
|
| Line 1: |
Line 1: |
| − | <div id="6SpaceContent" class="zcontent" align="left"> | + | <div style="font-size:30px">'''EXPONDIST(x,Lambda,cum)'''</div><br/> |
| | + | *<math>x</math> is the value of the function |
| | + | *<math>lambda</math> is the value of the rate parameter |
| | + | *<math>cu</math> is the logical value like TRUE or FALSE |
| | | | |
| − | <font size="3"><font face="Times New Roman">'''EXPONDIST'''('''x''',''' Lambda, cum''')</font></font>
| + | ==Discription== |
| | | | |
| − | <font size="3"><font face="Times New Roman">Where X is the value of the function, Lambda is the parameter value and Cumulative is a logical value.</font></font>
| + | EXPONDIST is to model the time between events. |
| | | | |
| − | </div>
| + | X or Lambda must be a numeric value in this function. Otherwise it shows error. |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left">
| |
| | | | |
| − | <font size="3"><font face="Times New Roman">EXPONDIST is to model the time between events.</font></font>
| + | If x is less than 0, or Lambda less than or equal to zero, EXPONDIST shows error value. |
| | | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="7SpaceContent" class="zcontent" align="left">
| |
| − |
| |
| − | <font size="3">·</font> <font size="3"><font face="Times New Roman">X or Lambda must be a numeric value in this function. Otherwise it shows error.</font></font>
| |
| − |
| |
| − | <font size="3">·</font> <font size="3"><font face="Times New Roman">If x is less than 0, or Lambda less than or equal to zero, EXPONDIST shows error value. </font></font>
| |
| − |
| |
| − | </div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">EXPONDIST</div></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">
| |
| − |
| |
| − | {| id="TABLE3" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | <div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| |
| − | | class=" " | Column1
| |
| − | | class=" SelectTD ChangeBGColor SelectTD" |
| |
| − | <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]</div>Column2
| |
| − | | class=" " | Column3
| |
| − | | class=" " | Column4
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class=" " | 0.5
| |
| − | |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | class="sshl_f" | Row@
| |
| − | | class=" " | 15
| |
| − | | class="sshl_f " |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="odd"
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" | 0.999447
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | class="sshl_f" | Row3
| |
| − | | class="sshl_f" | 0.008296
| |
| − | | class="sshl_f " |
| |
| − | | class="sshl_f " |
| |
| − | | class="sshl_f" |
| |
| − | |}
| |
| − |
| |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">AVEDEV (N1, N2...)</font></font> <font size="3"><font face="Times New Roman">Where N1, N 2 ... are positive integers.</font></font> '''</font></font></div>
| |
| − | ----
| |
| − | <div id="5SpaceContent" class="zcontent" align="left"><font size="3">
| |
| | | | |
| | + | AVEDEV (N1, N2...) |
| | + | Where N1, N 2 ... are positive integers. |
| | Let’s see an example | | Let’s see an example |
| | | | |
| Line 87: |
Line 28: |
| | | | |
| | <nowiki>=EXPONDIST (0.5, 15, FALSE) is 0.0083</nowiki> | | <nowiki>=EXPONDIST (0.5, 15, FALSE) is 0.0083</nowiki> |
| − |
| |
| − | </font></div>
| |
| − | ----
| |
EXPONDIST(x,Lambda,cum)
is the value of the function
is the value of the rate parameter
is the logical value like TRUE or FALSE
Discription
EXPONDIST is to model the time between events.
X or Lambda must be a numeric value in this function. Otherwise it shows error.
If x is less than 0, or Lambda less than or equal to zero, EXPONDIST shows error value.
AVEDEV (N1, N2...)
Where N1, N 2 ... are positive integers.
Let’s see an example
EXPONDIST(x, Lambda, cum)
B
0.5
15
=EXPONDIST (B2, B3, TRUE) is 0.9994
=EXPONDIST (0.5, 15, FALSE) is 0.0083