BETADIST
Returns the cumulative beta distribution (legacy name).
BETADIST(x, alpha, beta, [A], [B]) is BETA.DIST(x, alpha, beta, TRUE, A, B): the
compatibility form is always cumulative and takes the bounds as its 4th and 5th arguments.
The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.
Syntax
=BETADIST(x, alpha, beta, [a], [b])
Arguments
| Argument | Type | Required | Default |
|---|---|---|---|
x | number | Required | — |
alpha | number | Required | — |
beta | number | Required | — |
a | number | Optional | — |
b | number | Optional | — |
How it works
Legacy equivalent of BETA.DIST with cumulative set to TRUE. Lower and upper limits follow beta directly because BETADIST has no cumulative switch. The density is supported on the interval between those limits, with both shapes positive.
Remarks
AandBdefault to0and1.
Error cases
- Returns
#NUM!whenalpha <= 0,beta <= 0,x < A,x > B, orA = B.
Examples
Evaluate the cumulative beta probability below 0.32 using the legacy function.
Formula =BETADIST(0.32,2,3)
Expected result 0.383713279999999
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Evaluate the same relative position on the interval from zero to ten.
Formula =BETADIST(3.2,2,3,0,10)
Expected result 0.383713279999999
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Evaluate at the default upper endpoint.
Formula =BETADIST(1,2,3)
Expected result 1
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
A value above the default interval is outside the distribution.
Formula =BETADIST(1.1,2,3)
Expected result #NUM!
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Find the cumulative beta probability at 2 on the interval from 1 to 3.
Formula =BETADIST(2,8,10,1,3)
Expected result 0.685470581054687
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.