Open In App

How to Calculate Conditional Probability in Excel?

Improve
Improve
Like Article
Like
Save
Share
Report

Conditional probability is calculating the probability of an event provided the event associated is already done. In other words, If we have to find the conditional probability of two events suppose A and B, then we are finding the probability of event A happening given that event B has already occurred. The formula of conditional probability having events A and B are as follows:

P (A|B) = \frac{P(A\cap{B})}{P(B)}

Steps to Calculate Conditional Probability in Excel

For example, The data below represents a population of a town that uses social networking sites namely LinkedIn and Facebook. The data shows the number of people using Facebook and Using LinkedIn, the number of people using Facebook but not using LinkedIn, and so on. The total population taken is 200.

Dataset-to-calculate-conditional-probability

 

Now, we need to calculate,

  • Probability of people using Facebook. P(Use Facebook)
  • Probability of people using Facebook and using LinkedIn. P(Use Facebook AND Use LinkedIn)
  • The conditional probability of people using Facebook who also uses LinkedIn. P(Use Facebook| Use LinkedIn)
  • The conditional probability of people using LinkedIn who also uses Facebook. P(Not Use LinkedIn| Use Facebook)

Calculating Probability of People using Facebook (Use Facebook)

Step 1: Divide the total number of Facebook users by the total number of users. The formula for this is =F3/F5.

Using-formula-for-probability

 

Step 2: Press Enter key and you’ll get the results.

use-facebook-output

 

Calculating Probability of People Using Facebook and Using LinkedIn. P(Use Facebook AND Use LinkedIn)

Here, we need to calculate the probability of people who uses Facebook and LinkedIn. 

Step 1: Find the number of people who uses Facebook and LinkedIn.

Step 2: Apply the formula in the cell where you want your results to appear =D3/F5.

use-facebook-and-use-linkedin-formula

 

Step 3: Press Enter key and you’ll get the results.

use-facebook-and-use-linkedin-output

 

Calculating Conditional Probability of People Using Facebook Who Also Use LinkedIn. P(Use Facebook| Use LinkedIn)

Step 1: Find the number of people who uses Facebook and LinkedIn.

Step 2: Apply the formula in the cell where you want your results to appear =D3/D5. The only change in this question is we need to find the probability among people who use LinkedIn irrespective of their usage of Facebook. i.e the population or the sample space has changed to all the people who use LinkedIn.

P(Use Facebook| Use LinkedIn)

 

Step 3: Press Enter key and you’ll get the results.

use-facebook-conditional-probability-output

 

Calculating Conditional Probability of People not Using LinkedIn Who Also Use Facebook P(Not Use LinkedIn| Use Facebook)

Step 1: Find the number of people who uses Facebook and don’t use LinkedIn.

Step 2: Apply the formula in the cell where you want your results to appear =E3/F3. The only change in this question is we need to find the probability among people who don’t use LinkedIn irrespective of their usage of Facebook. i.e the population or the sample space has changed to all the people who use Facebook.

Final-output

 

Step 3: Press Enter key and you’ll get the results.

Output:

Output

 


Last Updated : 04 Jan, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads