## What is BETA.INV function in Excel?

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

It Returns the **inverse of the cumulative** beta probability density function.

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

## How to use BETA.INV 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.INV** function.

6. Then select **ok**.

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

8. **Probability **is a probability associated with the beta distribution.

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

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

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

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

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

## Examples of BETA.INV function in Excel

## BETA.INV related functions

- Use BETA.DIST function to return the beta probability distribution function.