In mathematics, the probability is the measure of the likelihood that an event will occur. However, the probability is quantified as a number between **0** and **1**, where **0** indicates impossibility and **1** indicates certainty. The higher the probability of an event, the more likely it is that the event will occur. Joint Probability is one of a kind. In this article, I will show you three ideal examples of how to **calculate joint probability **in **Excel**.

**Table of Contents**hide

## Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.

## What is Joint Probability?

In general, a joint probability is a mathematical analysis that shows the probabilities of two or more events occurring together. It shows all of the possible combinations of events and their corresponding probabilities. It is a powerful tool for statisticians and probability theorists. However, it can be used to** calculate the probability** of any combination of events occurring. Fortunately, you can easily calculate the joint probability using the following formula.

`P(A`

`Ⴖ`

`B) = P(A) × P(B)`

Here,

**P(AႶB) **= Joint Probability of Event A and B

**P(A) **= Probability of Happening Event A

**P(B) **= Probability of Happening Event b

## 3 Suitable Examples to Calculate Joint Probability in Excel

This section of the article will teach you three suitable and tricky examples of calculating **Joint Probability in Excel**. Moreover, I should not mention that I have used the Microsoft Excel 365 version for this article; you can use any other version according to your convenience.

### Example 1: Calculating Joint Probability of Tossing Two Coins in Excel

In this example, I have taken two coins in order to calculate the joint probability. Firstly, I will toss the first coin, and my desire is to get a **Tail**. So, the probability of getting a **Tail **in the first coin becomes **0.5**. Secondly, I will toss the second coin, and I desire to get a **Head**. So, the probability of getting the **Head, **in this case, becomes **0.5**. Now, I will find out the joint probability of getting a **Tail **in the first coin and a **Head **in the second coin toss. For the purpose of demonstration, I have used the following sample dataset.

**📌 Steps:**

- Initially, select cell
**C8**and write down the following formula.

`=C6*C7`

- Lastly, hit the
**Enter**key to get the final result.

**Read More: How to Find Marginal Probability in Excel (2 Simple Ways)**

### Example 2: Evaluating Joint Probability of Rolling Two Dice

Furthermore, I will evaluate the joint probability of rolling two dice in the second example. In this case, my desirable outcome is **Two **on both dice after rolling, and each of them shows a probability of **0.17 (⅙)**. However, go through the dataset below and the steps in order to find the joint probability of rolling two dice.

**📌 Steps:**

- First, click on cell
**C8**and write the formula below.

`=C6*C7`

- Finally, press
**Enter**and the joint probability will appear.

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

**Similar Readings**

**How to Create Option Probability Calculator in Excel****Calculate Binomial Probability in Excel (with Easy Steps)****How to Model Uniform Probability Distribution in Excel (3 Ways)****Calculate Variance of Probability Distribution in Excel****How to Calculate Probability of Hypergeometric Distribution in Excel**

### Example 3: Calculating Joint Probability of Playing Cards in Excel

Last but not least, I will estimate the joint probability of playing cards in Excel. Usually, there are a total of **52 **cards in a card pack which contains **26 Red** cards and **4 **cards containing **Six**. However, I will calculate the joint probability of drawing a **Six **from the cards, which is **Red**. For the purpose of demonstration, I have used the sample dataset below.

Hence, go through the steps below in order to complete the task easily.

**📌 Steps:**

- Firstly, select cell
**C7**and enter the formula below.

`=C6/C5`

- Secondly, press the
**Enter**button to get the probability of drawing a**Six**from the cards.

- Thirdly, click on cell
**C9**. - Similarly, write down the following formula and press
**Enter**in order to get the probability of drawing a**Red**card.

`=C8/C5`

- Again, write the formula mentioned below in cell
**C10**.

`=C7*C9`

- Finally, hit the
**Enter**key, and you will receive your desired joint probability.

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

## Conclusion

These are all the steps you can follow** to calculate the joint probability in Excel.** Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.

For more information like this, visit **Exceldemy.com**.

**Related Articles**

**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)****How to Use Continuous Probability Distribution in Excel****Find Discrete Probability Distribution in Excel****How to Get Simulation Probability in Excel (with Easy Steps)**