WorksheetFunction.Beta_Inv method (Excel)
Returns the inverse of the cumulative distribution function for a specified beta distribution. That is, if probability = Beta_Dist(x,...), then Beta_Inv(probability,...) = x.
Syntax
expression.Beta_Inv (Arg1, Arg2, Arg3, Arg4, Arg5)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Arg1 | Required | Double | A probability associated with the beta distribution. |
| Arg2 | Required | Double | The Alpha parameter of the distribution. |
| Arg3 | Required | Double | The Beta parameter the distribution. |
| Arg4 | Optional | Variant | An optional lower bound to the interval of x. |
| Arg5 | Optional | Variant | An optional upper bound to the interval of x. |
Return value
Double
Remarks
The beta distribution can be used in project planning to model probable completion times given an expected completion time and variability.
If any argument is nonnumeric, Beta_Inv generates an error value.
If alpha ≤ 0 or beta ≤ 0, Beta_Inv generates an error value.
If probability ≤ 0 or probability > 1, Beta_Inv generates an error value.
If you omit values for A and B (lower and upper bound), Beta_Inv uses the standard cumulative beta distribution, so that A = 0 and B = 1.
Given a value for probability, Beta_Inv seeks that value x such that Beta_Dist(x, alpha, beta, TRUE, A, B) = probability. Thus, the precision of Beta_Inv depends on the precision of Beta_Dist. Beta_Inv uses an iterative search technique.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.