Hi, everyone.
I’ve got n independent events, each of them with a known probability, and I was wondering if EXCEL, given this input, could return a table with all possible combinations of event occurrences and their respective probability.
This is pretty straightforward to do up to a limited number of events (actually, it can be done easily up to any number of events, following a simple procedure), but I would rather use a function, provided there’s one available.
Here’s the simplest example of what I’m looking for:
INPUT:
Event A: probability 30%
Event B: probability: 60%
OUTPUT:
A and B: 18%
A and NOT B: 12%
NOT A and B: 42%
NOT A and NOT B: 28%
Do you know if anything similar exists in EXCEL?
Thanks for your help.
Regards,
Nuno
I’ve got n independent events, each of them with a known probability, and I was wondering if EXCEL, given this input, could return a table with all possible combinations of event occurrences and their respective probability.
This is pretty straightforward to do up to a limited number of events (actually, it can be done easily up to any number of events, following a simple procedure), but I would rather use a function, provided there’s one available.
Here’s the simplest example of what I’m looking for:
INPUT:
Event A: probability 30%
Event B: probability: 60%
OUTPUT:
A and B: 18%
A and NOT B: 12%
NOT A and B: 42%
NOT A and NOT B: 28%
Do you know if anything similar exists in EXCEL?
Thanks for your help.
Regards,
Nuno