- Picture and text skills
- Case
Returns the inverse function of the gamma cumulative distribution function. If P = GAMMADIST(x,...), then GAMMAINV(p,...) = x.
Use this function to study possible skewness distributed variables.
Syntax
GAMMAINV(probability,alpha,beta)
Probability Probability associated with the gamma distribution.
Alpha distribution parameter.
Beta distribution parameter. If beta = 1, GAMMAINV returns the standard gamma distribution.
Description
If any parameter is non-numeric, GAMMAINV returns the #VALUE! error value.
if probability
If alpha ≤ 0 or beta ≤ 0, GAMMAINV returns the #NUM! error value.
If a probability value is given, GAMMAINV solves for the value x using GAMMADIST(x, alpha, beta, TRUE) = probability.
Therefore, the precision of GAMMAINV depends on the precision of GAMMADIST. GAMMAINV uses iterative search techniques.
If the search does not converge after 100 iterations, the function returns the #N/A error value.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/GAMMAINV-han-shu.html
评论列表(196条)
测试