From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Calculate compound probabilities

Calculate compound probabilities - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial

Calculate compound probabilities

“

- [Instructor] In the previous movie, I described how to calculate simple probabilities, that is the probability of a single trial. In this movie, I will describe compound probabilities. Compound probabilities assume that you want to analyze multiple independent trials. And by independent, that means that the second trial or outcome, in other words, the second flip of a coin or a throw of a die, is independent of the first. If you do have multiple independent trials, then you will multiply probability to get a compound probability. So flipping a coin will end up on heads half the time. So the probability of getting heads twice in a row assuming that the coin is fair would be one half times one half equals one quarter. One easy mistake to make is to assume that compound probability after you've already started. In other words, one of the trials has been done. If you're flipping a coin, again, a fair coin, with a one half…

Contents