Difference between revisions of "Manuals/calci/BETAINV"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left">'''BETAINV'''('''prob''','''alpha''','''beta''',X,Y) '''Where Prob is a probability associated with the beta distribut...")
 
 
(22 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">'''BETAINV'''('''prob''','''alpha''','''beta''',X,Y)
+
<div style="font-size:25px">'''BETAINV (Probability,Alpha,Beta,LowerBound,UpperBound,Accuracy,DivisionsAndDepthArray)'''</div><br/>
 +
*<math>Probability</math> is the probability value associated with the beta distribution.
 +
*<math>Alpha</math> & <math>Beta</math> are the values of  the shape parameter.
 +
*<math>LowerBound</math> & <math>UpperBound</math> the lower and upper limit to the interval of <math>x</math>.
 +
*<math>Accuracy</math> gives accurate value of the solution.
 +
*<math>DivisionsAndDepthArray</math> is the value of the division.
 +
**BETAINV(), returns the inverse of the Cumulative Distribution Function for a specified beta distribution.
  
−
'''Where Prob is a probability associated with the beta distribution.'''
 
  
−
'''Alpha and Beta are the parameter of the distribution.'''
+
==Description==
 +
*This function gives the inverse value of Cumulative Beta Probability Distribution.
 +
*It is called Inverted Beta Function or Beta Prime.
 +
*In <math>BETAINV (Probability,Alpha,Beta,LowerBound,UpperBound,Accuracy,DivisionsAndDepthArray)</math>, <math>Probability</math> is the probability value associated with Beta Distribution, <math>Alpha</math> and <math>Beta</math> are the values of two positive shape parameters and <math>LowerBound</math> and <math>UpperBound</math> are the lower and upper limit.
 +
*Normally the limit values are optional, i.e. when we are giving the values of <math>LowerBound</math>&<math>UpperBound</math> then the result value is from <math>a</math> and <math>b</math>.
 +
*When we are omitting the values <math>LowerBound</math> and <math>UpperBound</math>, by default it will consider <math>LowerBound=0</math> and <math>UpperBound=1</math>, so the result value is from <math>0</math> and <math>1</math>.
 +
*If <math>BETADIST (Number,Alpha,Beta,LowerBound,UpperBound)=Probability</math>, then <math>BETAINV (Probability,Alpha,Beta,LowerBound,UpperBound,Accuracy,DivisionsAndDepthArray)=x</math>.
 +
*<math>BETAINV</math> use the iterating method to find the value of <math>x</math>.suppose the iteration has not converged after 100 searches, then the function gives the error result.
 +
*This function will give the error result when 
 +
1.Any one of the arguments are non-numeric
 +
2.Alpha or Beta <math>\le</math> 0
 +
3.Number<LowerBound ,Number>UpperBound or LowerBound = UpperBound
 +
4.we are not mentioning the limit values  for LowerBound & UpperBound ,
 +
  by default it will consider the Standard Cumulative Beta Distribution, LowerBound = 0 and UpperBound = 1
  
−
'''X is an optional lower bound and Y is an optional upper bound to the interval of x.'''
+
==ZOS==
  
−
</div>
+
*The syntax is to calculate of this function in ZOS is <math>BETAINV (Probability,Alpha,Beta,LowerBound,UpperBound,Accuracy,DivisionsAndDepthArray)</math>.
−
----
+
**<math>probability</math> is the probability value associated with the beta distribution.
−
<div id="1SpaceContent" class="zcontent" align="left"> It calculates the inverse of the cumulative distribution function for a specified beta distribution.
+
**<math>Alpha</math> and <math>Beta</math> are the values of the shape parameter.
 +
**For e.g.,BETAINV(0.30987,10,18,12,16)
  
−
</div>
+
==Examples==
−
----
+
#BETAINV(0.2060381025,5,9,2,6) = 3
−
<div id="7SpaceContent" class="zcontent" align="left"> ·          <font face="Arial">Arguments sgould be numeric.</font>
+
#BETAINV(0.359492343,8,10) = 1.75
 +
#BETAINV(0.685470581,5,8,2,6) = 3.75
 +
#BETAINV(0.75267,1,7,7,9) = 7.25
 +
#BETAINV(0.5689,-2,4,3,5) = #N/A (ALPHA GREATER THAN (OR) NOT EQUAL TO 0)
  
−
·       BETAINV shows the error value, when alpha is less than or equal to 0 or beta is less than or equal to 0 and prob is less than or equal to 0 or prob is grater than 1
+
==Related Videos==
  
−
</div>
+
{{#ev:youtube|v=KjlIoium8n4|280|center|Beta Inverse Distribution}}
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
BETAINV
+
==See Also==
 +
*[[Manuals/calci/BETADIST | BETADIST]]
 +
*[[Manuals/calci/ALL | All Functions]]
  
−
</div></div>
+
==References==
−
----
+
[http://en.wikipedia.org/wiki/Beta_distribution  Beta Distribution]
−
<div id="8SpaceContent" class="zcontent" align="left">
 
  
−
Lets see an example,
 
  
−
BETAINV(prob,alpha,beta,X,Y)
 
  
−
B
+
*[[Z_API_Functions | List of Main Z Functions]]
  
−
0.28669548
+
*[[ Z3 |  Z3 home ]]
−
 
 
−
6
 
−
 
 
−
13
 
−
 
 
−
6
 
−
 
 
−
8
 
−
 
 
−
<nowiki>=BETAINV(B2,B3,B4,B5,B6)</nowiki>
 
−
 
 
−
</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=" " | 0.28669548
 
−
| class="  sshl_f    SelectTD" |
 
−
<div id="2EditDiv" class="tab active">=BETAINV(B2,B3,B4,B5,B6)</div><div id="2Space_Handle" class="zhandles"></div><div id="2Space_Copy" class="zhandles"></div>
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class=" " | 6
 
−
|
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="odd"
 
−
| Row3
 
−
| class=" " | 13
 
−
| class="sshl_f   " |
 
−
| class="sshl_f" |
 
−
| class="  " |
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="even"
 
−
| Row4
 
−
| class=" " | 6
 
−
| class="sshl_f" |
 
−
|
 
−
| class=" " |
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="odd"
 
−
| class="sshl_f" | Row5
 
−
| class="sshl_f " | 8
 
−
| class="  " |
 
−
|
 
−
|
 
−
| class="  " |
 
−
|
 
−
|- class="even"
 
−
| class=" " | Row6
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|
 
−
| class="sshl_f" |
 
−
|
 
−
|
 
−
|}
 
−
 
 
−
<div align="left"></div>''''''</div></div>
 
−
----
 

Latest revision as of 03:50, 24 August 2020

BETAINV (Probability,Alpha,Beta,LowerBound,UpperBound,Accuracy,DivisionsAndDepthArray)


  • is the probability value associated with the beta distribution.
  • & are the values of the shape parameter.
  • & the lower and upper limit to the interval of .
  • gives accurate value of the solution.
  • is the value of the division.
    • BETAINV(), returns the inverse of the Cumulative Distribution Function for a specified beta distribution.


Description

  • This function gives the inverse value of Cumulative Beta Probability Distribution.
  • It is called Inverted Beta Function or Beta Prime.
  • In , is the probability value associated with Beta Distribution, and are the values of two positive shape parameters and and are the lower and upper limit.
  • Normally the limit values are optional, i.e. when we are giving the values of & then the result value is from and .
  • When we are omitting the values and , by default it will consider and , so the result value is from and .
  • If , then .
  • use the iterating method to find the value of .suppose the iteration has not converged after 100 searches, then the function gives the error result.
  • This function will give the error result when
1.Any one of the arguments are non-numeric
2.Alpha or Beta  0 
3.Number<LowerBound ,Number>UpperBound or LowerBound = UpperBound
4.we are not mentioning the limit values  for LowerBound & UpperBound , 
  by default it will consider the Standard Cumulative Beta Distribution, LowerBound = 0 and UpperBound = 1

ZOS

  • The syntax is to calculate of this function in ZOS is .
    • is the probability value associated with the beta distribution.
    • and are the values of the shape parameter.
    • For e.g.,BETAINV(0.30987,10,18,12,16)

Examples

  1. BETAINV(0.2060381025,5,9,2,6) = 3
  2. BETAINV(0.359492343,8,10) = 1.75
  3. BETAINV(0.685470581,5,8,2,6) = 3.75
  4. BETAINV(0.75267,1,7,7,9) = 7.25
  5. BETAINV(0.5689,-2,4,3,5) = #N/A (ALPHA GREATER THAN (OR) NOT EQUAL TO 0)

Related Videos

Beta Inverse Distribution

See Also

References

Beta Distribution


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/BETAINV&oldid=215046"