How to use the WEIBULL.DIST function in Excel Office 365?
Tags: usetheweibulldistfun, excel, excelfunctions
Published: 2021-08-21 10:39:57

---
title: How to use the WEIBULL.DIST function in Excel Office 365?
published: true
date: 2021-08-17 18:06:09 UTC
tags: UseTheWEIBULLDISTFun,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-weibull-dist-function-in-excel-office-365/
---

The **Weibull distribution** is a **two-parameter family of continuous probability distributions**. This type of distribution is generally used for the **distribution in reliability analysis** or the **analysis of time to failure**. It takes the value and the **two parameters** named **alpha** and **beta** , along with the **type of distribution** required(cdf or pdf). In this article, we are going to see how to  **Use The WEIBULL.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)**

## WEIBULL.DIST Function syntax

```
=WEIBULL.DIST(x, alpha, beta, cumulative)
```

**Syntax Explanation:**

- **x :**  **value** at which you want to **evaluate the distribution**.
- **alpha ** : **parameter** for the **Weibull distribution**. If **alpha = 1,** WEIBULL.DIST acts as the **exponential distribution function**.
- **beta ** : **parameter** for the **Weibull distribution**.
- **cumulative**  : **logical value** that determines the form of the function. If **cumulative is TRUE** , **WEIBULL.DIST** returns the **cumulative distribution function** ; if **FALSE** , it returns the **probability density function.**

## Example

- Firstly, you need to **create the sample data** with **x value** along with **alpha and beta parameters** for the Weibull distribution.

![](https://geekexcel.com/wp-content/uploads/2021/08/create-the-data-with-value-x.png)<figcaption>Create the sample data</figcaption>

- Then, by using the **parameters** , you have to evaluate the **cumulative distribution** for the Weibull function with the formula given below.

```
=WEIBULL.DIST(B2,B3,B4,FALSE)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/use-the-formula-1024x241.png)<figcaption>Use the formula</figcaption>

- Now, you need to **calculate the value for at least 105** we can use the **probability mass distribution formula** by **changing the cumulative argument**.
- Here, you have to **use the formula** to find the **probability for Weibull distribution** given the **same parameters**.

```
=WEIBULL.DIST(B2,B3,B4,TRUE)
```

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

## Bottom-Line

Here we have described the simple formulas to **Use The WEIBULL.DIST Function In Excel Office 365**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic.

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

**Read Ahead:**

- **[Excel Formulas to Calculate the Cumulative Loan Interest ~ Easily!!](https://geekexcel.com/excel-formulas-to-calculate-the-cumulative-loan-interest-easily/)**
- **[How to Create a Normal Distribution Chart (Bell Curve) in Excel?](https://geekexcel.com/how-to-create-a-normal-distribution-chart-bell-curve-in-excel/)**
- **[Excel Formulas to Calculate the Cumulative Loan Principal Payments!!](https://geekexcel.com/excel-formulas-to-calculate-the-cumulative-loan-principal-payments/)**
- **[Formulas to Generate Random Number Weighted Probability!!](https://geekexcel.com/excel-formulas-to-generate-random-number-weighted-probability/)**
- **[How to use the Z.TEST function in Excel Office 365?](https://geekexcel.com/how-to-use-the-z-test-function-in-excel-office-365/)**