Difference between revisions of "Manuals/calci/GAMMAINV"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">'''GAMMAINV''' ('''prob''',''' alpha, beta''')</font></font> <font siz...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <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] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 04:31, 4 December 2013
GAMMAINV(prob,alpha,beta)
- 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