Manuals/calci/BETAINV
Jump to navigation
Jump to search
BETAINV(prob,alpha,beta,X,Y)
Where Prob is a probability associated with the beta distribution.
Alpha and Beta are the parameter of the distribution.
X is an optional lower bound and Y is an optional upper bound to the interval of x.
It calculates the inverse of the cumulative distribution function for a specified beta distribution.
· Arguments sgould be numeric.
· BETAINV shows the error value, when alpha is less than or equal to 0 or beta is less than or equal to 0 and prob is less than or equal to 0 or prob is grater than 1
BETAINV
Lets see an example,
BETAINV(prob,alpha,beta,X,Y)
B
0.28669548
6
13
6
8
=BETAINV(B2,B3,B4,B5,B6)
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |||
| Row1 | 0.28669548 |
=BETAINV(B2,B3,B4,B5,B6)
|
||||
| Row2 | 6 | |||||
| Row3 | 13 | |||||
| Row4 | 6 | |||||
| Row5 | 8 | |||||
| Row6 |