## What is BETA.DIST function in Excel?

The **BETA.DIST** function is one of the **Statistical **functions of Excel.

It Returns the **beta probability distribution** function.

We can find this function in **Statistical **of insert function Tab.

## How to use BETA.DIST function in excel

- Click on
**an empty cell**(like F5).

2. Click on the **fx icon **(or press shift+F3).

3. In the **insert function tab** you will see all functions.

4. Select **STATISTICAL **category.

5. Select **BETA.DIST** function.

6. Then select **ok**.

7. In the function arguments Tab you will see **BETA.DIST** function.

8. X section is the value **between A and 8 **at which to evaluate the function.

9. Alpha section is a parameter to the distribution and must be **greater than 0**.

10. Beta section is a parameter to the distribution and must be **greater than 0.**

11. Cumulative is a logical value: for the **cumulative distribution function**, use TRUE; for the probability density function, use FALSE.

12. A is an optional lower bound to the interval of x. If omitted, A = 0.

13. B is an optional upper bound to the interval of x. If omitted, B = 1

14. You will see the **results **in the formula result section.

## Examples of BETA.DIST function in Excel

## BETA.DIST related functions

- Use BETA.INV function to return the inverse of the cumulative beta probability density.