Formualizer Docs

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

ArgumentTypeRequiredDefault
xnumberRequired—
alphanumberRequired—
betanumberRequired—
anumberOptional—
bnumberOptional—

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

  • A and B default to 0 and 1.

Error cases

  • Returns #NUM! when alpha <= 0, beta <= 0, x < A, x > B, or A = 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?.

Implementation

Engine source

On this page