ExcelFlux

BETADIST function

the beta cumulative distribution function.

Compatibility · Guided Excel example

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Find a lower-tail beta probability in a legacy workbook.

A worked example from the workbook

RowA
6Input
70.1
80.5
90.9
Record 1
=BETADIST(A7,2,3)

Illustrative output0.0523

See the inputs and instructions for all 3 examples

Syntax

BETADIST(x,alpha,beta,[A],[B])

Compatibility function for older workbooks.

Worked examples

Find a lower-tail beta probability in a legacy workbook.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 0.1
8 0.5
9 0.9
Trial Expression Sample output
Record 1 =BETADIST(A7,2,3) 0.0523
Record 2 =BETADIST(A8,2,3) 0.6875
Record 3 =BETADIST(A9,2,3) 0.9963
Microsoft Excel reference