When running a Monte Carlo simulation with @RISK, multiple simulations are a useful tool to allow the comparison of simulation results when there is a change of parameters or distributions in a model (and to conduct simple optimisation analysis). Whilst simple to implement, there are a number of simple tips that can be useful to remember when doing so. [Read more…] about Using Multiple Simulations in @RISK™
Archives for October 2010
When parameterising a probability distribution for Monte Carlo simulation modelling, such as when using @RISK™ or RiskSolver™, one common issue is whether to use a P50 or a most likely value. This applies especially when using Triangular, PERT or Lognormal distributions. There are advantages and disadvantages of each. [Read more…] about Should I Use the P50 or the Most Likely Value for Inputs?
Following a number of requests for Public Courses from potential customers for whom an on-site seminar is not cost effective due to low participant numbers, I have recently decided to offer open training courses, as described in more detail on the site. There are four courses offered, in small groups, and courses are intensive, interactive and practical. The course range from the most fundamental core aspects of modelling in Excel to advanced topics in risk modelling, advanced Excel and VBA modelling and quantitative finance. [Read more…] about Launch of Public Training Courses