How to use the BETA.DIST function in Excel office 365?
Tags: tousethebetadistfunc, excel, excelfunctions
Published: 2021-08-24 02:19:51

---
title: How to use the BETA.DIST function in Excel office 365?
published: true
date: 2021-08-18 19:40:45 UTC
tags: ToUseTheBETADISTFunc,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-beta-dist-function-in-excel-office-365/
---

The Excel **Beta.Dist function** calculates the **cumulative beta distribution function** or the **probability density function** of the Beta distribution, for a supplied set of parameters. In this tutorial, we are going to see how to **use BETA.DIST Function In Excel Office 365**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## BETA.DIST Function syntax

```
=BETA.DIST(x, alpha, beta, cumulative, [A], [B])
```

**Syntax Explanation:**

- **x** : **value** between A and B at which to evaluate the function.
- **alpha** : **first parameter** of the distribution.
- **beta** : **second parameter** of the distribution.
- **cumulative** : **TRUE** (returns cdf) or **FALSE** (returns pdf).
- **[A]** : [Optional] **lower bound** to the interval of x. **Default is 0**.
- **[B]** : [Optional] **upper bound** to the interval of x. **Default is 1**.

## Example

- Firstly, you have to create **parameters for a distribution**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-9.png)<figcaption>Sample data</figcaption>

- Then, you have to calculate the **beta cumulative distribution function**.
- Now, you need to use the following **formula** given below.

```
=BETA.DIST(B2,B3,B4,TRUE,B5,B6)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/cumulative-distribution-6-1024x357.png)<figcaption>cumulative distribution</figcaption>

- After that, for the **same parameters** , you have to find the **beta probability distribution** using the **cumulative argument as FALSE** as shown below.

```
=BETA.DIST(B2,B3,B4,FALSE,B5,B6)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/probability-mass-distribution-6-1024x352.png)<figcaption>probability density function</figcaption>

**NOTE:**

- The CONFIDENCE.NORM Function only works with **numbers**.
- If any **argument is non-numeric** , the function **returns #VALUE! error**.
- You can **feed the arguments** to the **function** directly or using the **cell reference**.
- If optional **argument [A] and [B] are omitted**. **Default values** are taken as **0 and 1**. So x must lie between 0 and 1.
- The function **returns #NUM error value** :
  1. If alpha <= 0 or beta <= 0
  2. If x < A, x > B, or A = B

## Bottom-Line

In this tutorial, we guided you to know how to **use BETA.DIST Function In Excel Office 365** with proper examples and screenshots. Kindly, give your **feedback** in the below comment section.

Thanks for visiting **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Related Articles:**

- **[How to Move Range in Microsoft Excel 365?](https://geekexcel.com/how-to-move-range-in-microsoft-excel-365/)**
- **[Formulas to Count Cells Either X or Y In Excel Office 365!!](https://geekexcel.com/formulas-to-count-cells-either-x-or-y-in-excel-office-365/)**
- **[Excel Formulas to Count the Values that appear in a List!!](https://geekexcel.com/excel-formulas-to-count-the-values-that-appear-in-a-list/)**
- **[Formulas to Sum the Values in the cells that contain both X and Y!!](https://geekexcel.com/excel-formulas-to-sum-the-values-in-the-cells-that-contain-both-x-and-y/)**
- **[How to use the GAMMA.DIST function in Excel Spreadsheet?](https://geekexcel.com/how-to-use-the-gamma-dist-function-in-excel-spreadsheet/)**