I have 10 independent events and I would like to be able to work out the probability of EXACTLY 2,3,4,5 etc. happening, I can gain the probability of 1 happening by taking the probability of the sum of any happening and I can get the probability of more than 1 happening by taking away the probability of 0 happening, I can also get chances of 2 happening by taking away the chance of just 1 happening from the chance of 0, but I am struggling with how I can do this with exactly 2 without individually calculating the chances of event 1 & 2, chances of event 1 & 3, so on and so forth. Is there a way to do this with Excel/Google Sheets? I looked into binomial distribution but I think this requires the probability of each event to be the same.
Not a hugely maths savvy person, so your patience (and simplicity) in answering would be much appreciated.
The table shows the probabilities I have for the 10 events.