writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 7:
Line 7: − +
→Description
*It is used in Bayesian statistics.
*It is used in Bayesian statistics.
*In <math>GAMMAINV(prob,\alpha,\beta)</math> , <math>prob</math> is the probability value associated with Gamma Distribution,<math>\alpha</math> is called shape parameter and <math>beta</math> is the rate parameter of the distribution.
*In <math>GAMMAINV(prob,\alpha,\beta)</math> , <math>prob</math> is the probability value associated with Gamma Distribution,<math>\alpha</math> is called shape parameter and <math>beta</math> is the rate parameter of the distribution.
*If <math>GAMMADIST(x,alpha,beta,TRUE)=prob</math>, then <math>GAMMAINV(prob,alpha,beta,)= x</math>.
*If <math>GAMMADIST(x,\alpha,\beta,TRUE)=prob</math>, then <math>GAMMAINV(prob,\alpha,\beta)= x</math>.
*GAMMAINV use the iterating method to find the value of <math>x</math>.
*GAMMAINV 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.
*Suppose the iteration has not converged after 100 searches, then the function gives the error result.