:GAMMAINV function-Table skills免费ppt模版下载-道格办公

GAMMAINV function

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