Kopie von Event Risk 1 - Basic @RISK Model.xlsx - Event...

• 4

This preview shows page 1 - 2 out of 4 pages.

Event Risk 1 - Basic @RISK ModelThere are many situations where events either occur or don't occur. @RISK can be used to simulRiskBinomial(1,p), where p is the probability that the event occurs. This generates 1 (event occur(event doesn't occur) with probability 1-p. (Starting in version 6.0 of @RISK, you can use the funcThe current model assumes that the 10 possible adverse events are probabilistically independenin column C. The occurrence of any of these has the dollar impact listed in column E, and the impevents, leading to the sum of the actual impacts in cell C18. As the histogram of total impact indidiscrete; events either occur or they don't.A lesson in probability. What is the probability that none of the events occurs, so that the dollarto be independent, the probability that all blue cells are 0 is the productof their individual probacalculated in cell H15. This should match (within sampling error) the probability of a \$0 impact, fEvent Risk 1 - Basic @RISK Model