Looking for ways to model **uniform probability distribution **in Excel? Then, this is the right place for you. Here, you will find 3 suitable ways to model **uniform probability distribution **in Excel.

**Table of Contents**hide

## Download Practice Workbook

You can download the workbook to practice yourself.

## What Is Uniform Probability Distribution?

**Uniform Probability Distribution **is a type of **distribution **where the **probability **of all the **events **in the **distribution **is **almost equal**. If we try to **plot **a **graph **using the value of **probability **for this kind of distribution, we will get a **rectangular **form that represents the **equality **between the **probability **values.

## 3 Ways to Model Uniform Probability Distribution in Excel

Here, we will show you **3 **different ways to model **uniform probability distribution** in Excel. Suppose, we have a dataset containing the **Dice Values **from **1 **to **6**. Now, we will model a **uniform probability distribution** using random values.

### 1. Apply Excel RAND & TRUNC Functions to Model Uniform Probability Distribution

In the first method, we will apply the **RAND** and **TRUNC** functions to generate **random data **to model a **uniform probability distribution **in Excel.

Here are the steps.

**Steps:**

- Firstly, select
**Cell B5**and insert the following formula.

`=TRUNC(RAND()*6+1)`

- After that, drag down the
**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

**random data**using the

**RAND**function. We

**multiplied**the data with

**6**and

**added 1**to get those data between

**1**to

**6**. Then, we used the

**TRUNC**function to

**remove**the

**decimal**part from the

**data**.

- Thus, some
**random data**will be created from**1**to**6**.

- Then, select
**Cell E5**and insert the following formula.

`=COUNTIF(B5:B14,D5:D10)`

- Next, press
**Enter**to get all the**Count**values.

**the COUNTIF function**, we inserted cell range

**B5:B14**as the

**range**and cell range

**D5:D10**as the

**criteria**.

- Next, select
**Cell E11**and insert the following formula.

`=SUM(E5#)`

- After that, press
**Enter**.

- Further, select
**Cell F5**and insert the following formula.

`=E5/$E$11`

- Then, press
**Enter**and drag down the**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

**divided**Cell

**E5**by the value of the

**Total**number of

**Dice Data**in

**Cell E11**(

**fixed**this value as it is

**constant**for all the following

**Cells**).

- Finally, you will get all the
**Probability**values for each**Dice Value**.

- Next, select
**Cell F11**and insert the following formula.

`=SUM(F5:F10)`

- Then, press
**Enter**.

**SUM**function, we added the values of the cell range

**F5:F10**.

**Read More:** **How to Calculate Probability Distribution in Excel (with Quick Steps)**

### 2. Illustrate Uniform Probability Distribution Using RANDBETWEEN Function

You can also use **the RANDBETWEEN function** to illustrate a **uniform probability distribution**. Now, we will create some **random data **between **1 **to **6 **using this function to model **uniform probability distribution**.

Follow the steps given below to do it on your own.

**Steps:**

- To start with, select
**Cell B5**and insert the following formula.

`=RANDBETWEEN(1,6)`

- Then, drag down the
**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

**RANDBETWEEN**function, we inserted

**1**as the

**bottom**and

**6**as the

**top**value to get some

**random data**between

**1**to

**6**.

- Thus, you can create some
**random data**using the**RANDBETWEEN**function.

- Finally, model a
**uniform probability distribution**going through the same steps shown**above**.

**Read More:** **How to Calculate Conditional Probability in Excel (2 Easy Ways)**

**Similar Readings**

**How to Use Continuous Probability Distribution in Excel****Create Joint Probability Table in Excel (with Easy Steps)****How to Find Discrete Probability Distribution in Excel****Create Option Probability Calculator in Excel****How to Apply Weighted Probability in Excel (3 Useful Methods)**

### 3. Insert Simple Formula to Get Probability in Uniform Distribution in Excel

In the last method, we will show you how you can get the **probability **of some **specific data **in a **uniform distribution **by inserting a **simple formula**. Suppose you have some **parcel **having a **uniformly distributed weight **from **5kg **to **25kg**. Now, you want to know the **probability **of **parcels **having **10kg **to **15kg **weight in that distribution. You can solve this problem by going through the steps given below.

**Steps:**

- Firstly, select
**Cell C10**and insert the following formula.

`=(C7-C8)/(C5-C6)`

- Then, press
**Enter**to get the**probability**.

**divided**the value of the difference between

**Cell C7**and

**Cell C8**by the value of the difference between

**Cell C5**and

**Cell C6**.

**Read More:** **How to Get Simulation Probability in Excel (with Easy Steps)**

## Practice Section

In the article, you will find an Excel workbook like the image given below to practice on your own.

## Conclusion

So, in this article, we have shown you 3 ways to model **uniform probability distribution **in Excel. I hope you found this article interesting and helpful. If something seems difficult to understand, please leave a comment. Please let us know if there are any more alternatives that we may have missed. And, visit **ExcelDemy** for many more articles like this. Thank you!

**Related Articles**

**How to Find Marginal Probability in Excel (2 Simple Ways)****How to Calculate Empirical Probability with Excel Formula****Calculating Probability in Excel with Mean and Standard Deviation****How to Make a Probability Tree Diagram in Excel (3 Easy Methods)****How to Calculate Probability of Exceedance in Excel****Poisson Probability Distribution in Excel (4 Practical Examples)**