Administrators, writer
3,314
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + + + + + + + + + − <font size="3"><font face="Times New Roman">'''GAMMAINV''' ('''prob''',''' alpha, beta''')</font></font>+ + + + + + + + − <font size="3"><font face="Times New Roman">Where Prob is the probability associated with the gamma distribution, alpha and beta are the parameters to the distribution.</font></font>+ − + − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − GAMMAINV − − </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="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="4SpaceContent" class="zcontent" align="left"><div> − − {| id="TABLE1" class="SpreadSheet blue" − |- class="even" − | class=" " | − | class=" " | Column1 − | class=" " | Column2 − | class=" " | Column3 − |- class="odd" − | class=" " | Row1 − | class="sshl_f " | 0.6658 − | class="sshl_f" | 10 − | class="sshl_f" | − |- class="even" − | class=" " | Row2 − | class=" " | 10 − | class="sshl_fSelectTD SelectTD " | − <div id="4Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − | class="sshl_f" | − |- class="odd" − | class="sshl_f" | Row3 − | class="sshl_f " | 4 − | class=" " | − | class="sshl_f" | − |- class="even" − | class="sshl_f" | Row4 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − |- class="odd" − | class="sshl_f" | Row5 − | class="sshl_f" | − | class="sshl_f" | − | − |} − − <div align="left"></div>''''''</div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − − <font size="3"><font face="Times New Roman"><nowiki>=GAMMAINV (B2, B3, B4) is 10</nowiki></font></font> − − </div> − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − − <font size="3"><font face="Times New Roman">It is the inverse of the gamma cumulative distribution. </font></font> − − </div> − ----
no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''GAMMAINV(prob,alpha,beta)'''</div><br/>
*Where 'prob' is the probability value associated with gamma distribution
*'Alpha'& 'beta' are the values of the shape and rate parameters
==Description==
*This function gives the inverse value of cumulative gamma probability distribution.
*This distribution is the continuous probability distribution on the positive real line and it is of the reciprocal of a variable distributed according to the gamma distribution with two parameters α&ß.
*It is used in Bayesian statistics.
*In GAMMAINV(prob,alpha,beta) , prob is the probability value associated with gamma distribution,alpha is called shape parameter and beta is the rate parameter of the distribution.
*.If GAMMADIST(x,alpha,beta,TRUE)=prob, then GAMMAINV(prob,alpha,beta,)=x.
*GAMMAINV using the iterating method to find the value of x.suppose the iteration has not converged after 100 searches, then the function gives the error result.
*This function will give the error result when
#Any one of the arguments are nonnumeric
#alpha or beta<=0
#prob<0 or prob>1
==Examples==
#GAMMAINV(0.65189,2,5)=11.1335534510
#GAMMAINV(0.006867292,5,7)=8.155481331GAMMAINV(0.1543869,9,3)=18.0467153645
#GAMMAINV(1,9,3)=82.51739521528073(CALCI)=119.4248486(EXCEL)
#GAMMAINV(1.1,9,3)=NAN, because prob>1
==See Also==
*[[Manuals/calci/GAMMADIST | GAMMADIST]]
*[[Manuals/calci/GAMMALN | GAMMALN]]
==References==
[http://en.wikipedia.org/wiki/Gamma_distribution| Gamma Distribution]