kras wrote:
> For example, I've been told that if event A has probability of 60%,
> respectively event B has probability of 40%, this means that there is
> 13% chance of four consecutive events A and 2-3% chance of four
> consecutive events B. I would like to implement this in excel sheet.

=binomdist(4,4,60%,0) results in 12.96%.
=binomdist(4,4,40%,0) results in 2.56%

This presumes that A and B are mutually-exclusive and the only
possible outcomes, and the probabilities remain the same for all
trials. It also assumes that there are a fixed number of trials, and
the outcome of the trials are independent.