| Line 2: |
Line 2: |
| | *<math>x </math> is the value of the function. | | *<math>x </math> is the value of the function. |
| | *<math>alpha </math> and <math> beta </math> are the parameter of the distribution. | | *<math>alpha </math> and <math> beta </math> are the parameter of the distribution. |
| − | *<math>lv</math>is the logical value. | + | *<math>lv</math> is the logical value. |
| | | | |
| | ==Description== | | ==Description== |
| Line 23: |
Line 23: |
| | *The equation for probability density function is: | | *The equation for probability density function is: |
| | <math>f(x,\alpha,\beta) = \frac{\alpha}{\beta^\alpha}.x^{\alpha-1}.e^-{(\frac{x}{\beta})}^\alpha.</math> | | <math>f(x,\alpha,\beta) = \frac{\alpha}{\beta^\alpha}.x^{\alpha-1}.e^-{(\frac{x}{\beta})}^\alpha.</math> |
| − | *When alpha =1, then this function gives the exponentail with <math>\lambda=\frac{1}{\beta}</math>. | + | *When alpha =1, then this function gives the exponential with <math>\lambda=\frac{1}{\beta}</math>. |
| | *This function gives the result as error when | | *This function gives the result as error when |
| | 1. Any one of the argument is non-numeric. | | 1. Any one of the argument is non-numeric. |
| | 2. x is negative. | | 2. x is negative. |
| − | 3.alpha<math>\le 0</math> or beta <math>\le 0. | + | 3. alpha<math>\le 0</math> or beta <math>\le 0. |
| | | | |
| − | WEIBULL(x,alpha,beta,lv), where , and , and . | + | ==Examples== |
| | + | #=WEIBULL(202,60,81,TRUE) = 1 |
| | + | #=WEIBULL(202,60,81,FALSE) = 0 |
| | + | #=WEIBULL(160,80,170,TRUE) = 0.00779805060 |
| | + | #=WEIBULL(160,80,170,FALSE) = 0.0038837823333 |
| | + | #= WEIBULL(10.5,2.1,5.3,TRUE) = 0.9850433821261 |
| | + | #=WEIBULL(10.5,2.1,5.3,FALSE) = 0.0125713406729 |
| | | | |
| − | <div id="6SpaceContent" class="zcontent" align="left">
| + | ==See Also== |
| | + | *[[Manuals/calci/EXPONDIST | EXPONDIST ]] |
| | + | *[[Manuals/calci/LOGNORM | LOGNORM ]] |
| | | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''WEIBULL'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''x '''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''a'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">, </font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''b'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">, </font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''cum'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>
| + | ==References== |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">Where 'x' Is the value at which to estimate the function, 'a'(Alpha) and 'b'(Beta) are the parameters to the distribution, and 'cum' determines the form of the function.</font></font></font>
| |
| − | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">This function returns the Weibull distribution. </font></font></font></div>
| |
| − | ----
| |
| − | <div id="7SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | * <font color="#484848"><font face="Arial, sans-serif"><font size="2">WEIBULL returns the error value, when x, a, b is nonnumeric or x < 0</font></font></font>
| |
| − | * <font color="#484848"><font face="Arial, sans-serif"><font size="2">WEIBULL returns the error value, when a ≤ 0 or b ≤ 0. </font></font></font>
| |
| − | * <font color="#484848"><font face="Arial, sans-serif"><font size="2">The equation for the Weibull cumulative distribution function is: </font></font></font>
| |
| − | | |
| − | <font color="#484848" face="Arial"></font>
| |
| − | | |
| − | <font color="#484848"></font>
| |
| − | | |
| − | * <font color="#484848"><font face="Arial, sans-serif"><font size="2">The equation for the Weibull probability density function is: </font></font></font>
| |
| − | | |
| − | <font color="#484848"></font>
| |
| − | | |
| − | * <font color="#484848"><font face="Arial, sans-serif"><font size="2">When alpha = 1, WEIBULL returns the exponential distribution with: </font></font></font>
| |
| − | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
| − | | |
| − | WEIBULL
| |
| − | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left"><font color="#484848"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
| |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">B</font></font></font>
| |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">100</font></font></font>
| |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">25</font></font></font>
| |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">110</font></font></font>
| |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">UNIQ686c29c343f4309c-nowiki-00000004-QINU</font></font></font>
| |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">UNIQ686c29c343f4309c-nowiki-00000005-QINU</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="2SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | {| id="TABLE3" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | | Column1
| |
| − | | class=" " | Column2
| |
| − | | class=" " | Column3
| |
| − | | class=" " | Column4
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class=" " | 100
| |
| − | | class="sshl_f" | 0.088165
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class=" " | 25
| |
| − | | class="sshl_f" | 0.02104
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | | class=" " | 110
| |
| − | | class="SelectTD" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f " |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | | class="sshl_f " |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | Row6
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |}
| |
| − | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| |
| − | ----
| |
| − | <div id="9SpaceContent" class="zcontent" align="left"><div>[[Image:25.JPG|100%px|http://store.zcubes.com/33975CA25A304262905E768B19753F5D/Uploaded/25.JPG]]</div></div>
| |
| − | ----
| |
| − | <div id="13SpaceContent" class="zcontent" align="left"><div>[[Image:26.JPG|100%px|http://store.zcubes.com/33975CA25A304262905E768B19753F5D/Uploaded/26.JPG]]</div></div>
| |
| − | ----
| |
| − | <div id="14SpaceContent" class="zcontent" align="left"><div>[[Image:27.JPG|100%px|http://store.zcubes.com/33975CA25A304262905E768B19753F5D/Uploaded/27.JPG]]</div></div>
| |
| − | ----
| |