How to use the BETAINV function
Author: Oscar Cronquist Article last updated on September 24, 2018
The BETAINV function calculates the inverse of the beta distribution. This function is outdated and replaced by the BETA.INV function which was introduced in Excel 2010.
Formula in cell C10:
=BETAINV(C3,C4,C5,C6,C7)
Excel Function Syntax
BETAINV(probability,alpha,beta,[A],[B])
Arguments
| probability | Required. |
| alpha | Required. A parameter which determines the shape of the distribution. |
| beta | Required. A parameter which determines the shape of the distribution. |
| [A] | Optional. Lower bound, default value 0 (zero). |
| [B] | Optional. Upper bound, default value 1. |
Comments
The BETAINV function returns
- #VALUE! error value if any argument is non-numeric.
- #NUM! error value if:
- alpha <= 0 (zero)
- beta <= 0 (zero)
- probability <= 0 (zero)
- probability > 1
- A = B
Functions in 'Compatibility' category
The BETAINV function function is one of many functions in the 'Compatibility' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form