![]() ![]() ![]() ![]() A global optimisation facility is useful for difficult problems, and statistics can be optimised – such as dpm or Ppk. Sensitivity analysis is supported based on correlation or stepwise regression and includes quadratic terms. It provides 53 continuous and 10 discrete distributions, with distribution fitting and automatic best fit. A RISKOptimizer combines Monte Carlo simulation with optimization techniques to find the best combination of factors that lead to a desired result under uncertain conditions.ĭiscoverSim is bundled with SigmaXL Version 7 and is an Excel add-in for Monte Carlo Simulation and optimization. Tornado charts and scatter plots are also supported, as are sensitivity and scenario analysis. Results are presented using high quality graphics with a variety of chart types (histograms, area, line, cumulative,box plot etc.). Integration with MS Project is supported or project risk modelling, and various mechanisms exist to define probabilities (distributions, compound distributions, percentile distribution parameters). The whole simulation environment is contained within Excel, and a BestFit distribution fitting facility supports the best distribution model (of which there are 50). This diversity should present enough options to find the most suitable product for particular performs risk analysis using Monte Carlo simulation in an Excel environment. This list of Excel add-ins covers varying levels of sophistication and cost – from Risk Analyser at US$49 to others which cost thousands of dollars. Monte Carlo Simulation continues to increase in popularity as risk becomes a more pressing issue in many activities. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |