Search results

  1. N

    Calculating Probability of Multiple Independent Events

    I've made a good start on the calculations. I have inputted formulae to calculate both 2 or 3 events occurring from a total of 3,4 & 5 events. I am noticing a few issues though. Firstly, as the number of total events is increasing my total probability calculated strays away from 1. For...
  2. N

    Calculating Probability of Multiple Independent Events

    Thank you very much! This helps greatly. I now understand how to calculate how many values will be required per calculation. Also, the binary system will definitely make it easier. I do intent to manually produce a 1024 row table. My current calculations used ~600 (which explains why my...
  3. N

    Calculating Probability of Multiple Independent Events

    Ah okay, that makes sense. You are correct in that 5 things may or may not happen. I am looking to calculate that 2 or more occur. In my mind, the probability of Event 1 (A) and Event 2 (B) occurring is independent of the results of 3/4/5 (C,D,E). However this raises an interesting point, 2 or...
  4. N

    Calculating Probability of Multiple Independent Events

    I did not include this. I don't really understand what this calculation entails. It is suggesting to me that the probability of both 1&2 occurring is dependent on P3,P4 & P5. Is that a correct assumption? All events calculated are independent of each other.
  5. N

    Calculating Probability of Multiple Independent Events

    Apologies, good point. with the calculation used, I believe it would calculate 'Any 2', whereas I would want it to calculate 2 or more.
  6. N

    Hi Pal, please insert some knowledge into my probability post. Yours truly, Tulipan

    Hi Pal, please insert some knowledge into my probability post. Yours truly, Tulipan
  7. N

    Calculating Probability of Multiple Independent Events

    Hello there, I have been working on producing an excel spreadsheet to automatically calculate probability values for multiple independent events occurring. Hopefully I find assistance in confirmation that the results acquired are correct - or at least on the right lines. I do not come from a...