How to Calculate Joint Probability in Excel (3 Ideal Examples)

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.


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(AB) = 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

Calculating Joint Probability of Tossing Two Coins in Excel

  • 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

Evaluating Joint Probability of Rolling Two Dice in Excel

  • Finally, press Enter and the joint probability will appear.

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


Similar Readings


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.

Sample Dataset for Calculating Joint Probability of Playing Cards in Excel

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

Calculating Joint Probability of Playing Cards in Excel

  • 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

Mehedi Hasan

Mehedi Hasan

Hi, I am Mehedi. I have completed my B.Sc. from Bangladesh University of Engineering and Technology. I have a strong interest in innovation and research in the field of Data Science and Machine Learning. Gradually, I now understand the value of Data Analysis and I am trying to learn everyday.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo