:The BETAINV function finds the value of the inverse distribution function-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Returns the inverse value of the cumulative distribution function of the specified beta distribution.

That is, if probability = BETADIST(x,...), then BETAINV(probability,...) = x.

The beta distribution function can be used in project design to simulate possible completion times given a desired completion time and varying parameters.

Grammar

BETAINV(probability,alpha,beta,A,B)

Probability The probability value of the Beta distribution.

Alpha distribution parameters.

Beta distribution parameters.

A An optional lower bound for the interval to which the value x belongs.

B An optional upper bound for the interval to which the value x belongs.

Description

￭ If any parameter is non-numeric, BETAINV returns the error value #VALVE!.

￭ If alpha ≤ 0 or beta ≤ 0, BETAINV returns the error value #NUM!.

￭ If probability ≤ 0 or probability > 1, BETAINV returns the error value #NUM!.

￭ If the A or B values are omitted, BETAINV uses the standard cumulative beta distribution, that is, A = 0, B = 1.

￭ If a probability value is given, BETAINV solves for the value x using BETADIST(x, alpha, beta, A, B) = probability.

Therefore, the accuracy of BETAINV depends on the accuracy of BETADIST. BETAINV uses iterative search techniques.

￭ If the search does not converge after 100 iterations, the function returns the error value #N/A.

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/BETAINV-han-shu-qiu-fen-bu-han-shu-fan-han-shu-zhi.html