Hey,
I'm trying to create a Monte Carlo simulation for this excel sheet. Essentially in this excel, I have a number of different risks, with a different likelihood. Each likelihood corresponds to a particular probability of occurrence. And each risk is associated with a cost.
So what i'm trying to do is create a simulation for each risk where if I put in the likelihood (probability) and the cost, the excel runs a formula/function or VBA that gives me let's say 100 iterations different costs that fall within the probability range. Then graphically it graphs's the the iterations on the x-axis and the all costs on the y-axis.
Not to make it more complicated but if it can do different distributions like below that'd be great!
1= Uniform
2= Normal
3= Bernoulli
4= Binomial
5= Poisson
6= Patterned
7= Discrete
And unfortunately, this has to be run in Excel alone without any add-ons like @RISK, etc. Thank you in advance for the help!!
Bookmarks