Comparison of risk analysis Microsoft Excel add-ins

Last updated

The following is a comparison of various add-in packages available to do Monte Carlo probabilistic modeling and risk analysis. Add-ins covered are for Microsoft Excel on Windows. Mac software and tools for other platforms, such as R or Matlab are not included.

Monte Carlo methods, or Monte Carlo experiments, are a broad class of computational algorithms that rely on repeated random sampling to obtain numerical results. The underlying concept is to use randomness to solve problems that might be deterministic in principle. They are often used in physical and mathematical problems and are most useful when it is difficult or impossible to use other approaches. Monte Carlo methods are mainly used in three problem classes: optimization, numerical integration, and generating draws from a probability distribution.

Microsoft Excel Spreadsheet editor, part of Microsoft Office

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

Microsoft Windows is a group of several graphical operating system families, all of which are developed, marketed and sold by Microsoft. Each family caters to a certain sector of the computing industry. Active Microsoft Windows families include Windows NT and Windows IoT; these may encompass subfamilies, e.g. Windows Server or Windows Embedded Compact. Defunct Microsoft Windows families include Windows 9x, Windows Mobile and Windows Phone.

Contents

Decision-making software is reviewed separately.

General information

NameCompany nameOffice location(s)Product first releasedLast stable version Software license License options System Requirements Spreadsheet used
@RISK Industrial [1] Palisade CorporationAustralia, Japan, UK, USA19877.5 Proprietary Single user, network license Windows XP+ Excel 32-bit (Excel 2007+), Excel 64-bit
@RISK Professional [1] Palisade CorporationAustralia, Japan, UK, USA19877.5 Proprietary Single user, network license Windows XP+ Excel 32-bit (Excel 2007+), Excel 64-bit
Argo [2] Booz Allen HamiltonUSA20124.1FreewareN/AWindows XP+ Excel 32-bit (Excel 2007+), Excel 64-bit
Crystal Ball [3] Oracle CorporationUSA198711.1.4.4 Proprietary Single userWindows 2003+ Excel 32-bit (Excel 2003+), Excel 64-bit
Crystal Ball + Decision Optimizer [3] Oracle CorporationUSA198711.1.4.4 Proprietary Single userWindows 2003+ Excel 32-bit (Excel 2003+), Excel 64-bit
DiscoverSim + SigmaXL [4] SigmaXL Inc.Canada20122.1 Proprietary Single userWindows Vista+ Excel 32-bit (Excel 2010+), Excel 64-bit
Ersatz [5] EpigearAustralia20091.3 Proprietary Single userWindows 2000+ Excel 32-bit (Excel 2003+), Excel 64-bit
MC FLO [6] MC FLOsimSwitzerland2016Sebastián Proprietary Single userWindows 2000+ Excel 32-bit (Excel 2010+), Excel 64-bit
ModelRisk Complete [7] Vose SoftwareBelgium, USA20086.1 Proprietary Single user, network license Windows XP+ Excel 32-bit (Excel 2003+), Excel 64-bit
ModelRisk Basic [7] Vose SoftwareBelgium, USA20086.1FreewareSingle userWindows XP+ Excel 32-bit (Excel 2003+), Excel 64-bit
Monte Carnival [8] Monte CarnivalUSA20181.0 Proprietary Single UserWindows 95+ Excel 32-bit (Excel 1997+), Excel 64-bit
Quantum XL [9] SigmazoneUSA20103.50.04 Proprietary Single userWindows XP+ Excel 32-bit (Excel 2000+), Excel 64-bit
Risk AnalyzerAdd-ins.comUSA200311.02 Proprietary Single userWindows 2000+ Excel 32-bit (Excel 97+), Excel 64-bit
Risk Kit Suite [10] Wehrspohn GmbH & Co. KGGermany20077.2 Proprietary Free, single user, network license Windows 2000+ Excel 32-bit (Excel 2003+), Excel 64-bit
Risk Solver Pro [11] Frontline SystemsUSA200715.0 Proprietary Single user, network license Windows XP+ Excel 32-bit (Excel 2003+), Excel 64-bit, Excel Online
Risk Solver Pro + Premium Solver Pro [11] Frontline SystemsUSA200715.0 Proprietary Single user, network license Windows XP+ Excel 32-bit (Excel 2003+), Excel 64-bit, Excel Online
RiskAmp Personal [12] Structured Data LLCUSA200511.5 Proprietary Single userWindows 2000+ Excel 32-bit (Excel 2003+), Excel 64-bit
RiskAmp Professional [12] Structured Data LLCUSA200511.5 Proprietary Single userWindows 2000+ Excel 32-bit (Excel 2003+), Excel 64-bit
SAFE TOOLBOXES [13] Safe Quantitative TechnologiesUSA20161.0 Proprietary Single userWindows 2000+ Excel 32-bit (Excel 2003+), Excel 64-bit
Simtools xla [14] Roger Myerson, University of ChicagoUSA?3.31aFreewareN/AWindows 95+ Excel 32-bit (Excel 5+)
Similar [15] Luciano MachainArgentina?2.5FreewareN/AWindows XP+ Excel 32-bit (Excel 2003+)
Simulation Master Premium [16] Vortarus Technologies LLCUSA201718.12.03 Proprietary Single userWindows XP+ Excel 32-bit (Excel 2007+), Excel 64-bit
Simulation Master Standard [16] Vortarus Technologies LLCUSA201718.09.01 Proprietary Single userWindows XP+ Excel 32-bit (Excel 2007+), Excel 64-bit
Tukhi [17] KALX, LLCUSA?0.2.11.5FreewareN/AWindows 95+ Excel 32-bit (Excel 5+)
YASAI [18] and YASAIw [19] Rutgers University and Washington State Department of EcologyUSA20012.4, 2.0w29Freeware, Open source N/AWindows 95+ Excel 32-bit (Excel 97+), Excel 64-bit

Technical specification I

NameDistribution fittingCorrelation fitting [20] Time series fittingDecision treesOptimizer includedDatabase connectivity VBA calls to functions [21] C++ calls to functions [22] Six sigma supported
@RISK IndustrialYesYesYesPrecisionTree optionYesNoYesYesYes
@RISK ProfessionalYesYesNoPrecisionTree optionNoNoYesYesYes
ArgoNoYesNoNoYesNoNoNoNo
Crystal BallYesNoYesNoNoNoYesNoYes
Crystal Ball + Decision OptimizerYesNoYesNoYesNoYesNoYes
Crystal Ball EPM + Decision OptimizerYesNoYesNoYesYesYesNoYes
DiscoverSim + SigmaXLYesYesNoNoYesNoNoNoYes
ErsatzNoNoNoNoYesNoNoNoNo
MC FLOYesYesYesNoNoNoNoNoNo
ModelRisk CompleteYesYesYesNoNoYesYesYesYes
ModelRisk BasicYesYesYesNoNoNoYesYesNo
Monte CarnivalNoNoNoNoNoNoNoNoNo
Quantum XLYesNoNoNoYesNoNoNoYes
Risk AnalyzerNoNoNoNoNoNoNoNoNo
Risk Kit SuiteYesYesYesNoNoNoYesYes [23] No
Risk Solver ProYesNoXLMiner optionYesNoXLMiner optionYesYesYes
Risk Solver Pro + Premium Solver ProYesNoXLMiner optionYesYesXLMiner optionYesYesYes
RiskAmp PersonalNoNoNoNoNoNoNoNoNo
RiskAmp ProfessionalNoNoNoNoNoNoNoNoNo
SAFE TOOLBOXESYesYesYesNoNoNoYesNoYes
Simtools xlaNoNoNoFunctions / macrosNoNoYesNoNo
SimilarYesNoNoNoYesNoYesYesNo
Simulation Master PremiumYesYesYesDTace optionYesNoYesNoNo
Simulation Master StandardNoNoNoDTace optionNoNoNoNoNo
YASAI and YASAIwNoNoNoNoNoNoYesNoNo

Technical specification II

NameConverters forProbability calculation functions [24] UDF error analysis [25] Extreme value modeling [26] Expert elicitation tools [27] Data previsualizer ODE and numerical integration Assumption library
@RISK IndustrialCrystal BallYesNoNoYesYesNoYes
@RISK ProfessionalCrystal BallYesNoNoYesYesNoYes
ArgoNoYesNoNoNoYesNoNo
Crystal BallNoYesNoNoNoYesNoNo
Crystal Ball + Decision OptimizerNoYesNoNoNoYesNoNo
DiscoverSim + SigmaXLNoYesNoNoNoYesNoNo
ErsatzNoNoNoNoNoNoNoNo
MC FLONoYesYesNoYesYesNoNo
ModelRisk CompleteCrystal Ball, @RISKYesYesYesYesYesYesYes
ModelRisk BasicCrystal Ball, @RISKNoYesNoNoNoNoNo
Monte CarnivalNoNoNoNoNoNoNoNo
Quantum XLNoNoNoNoNoNoNoNo
Risk AnalyzerNoNoNoNoNoNoNoNo
Risk Kit SuiteNoYesYesYesYesYesNoNo
Risk Solver ProNoNoNoNoNoNoNoNo
Risk Solver Pro + Premium Solver ProNoNoNoNoNoNoNoNo
RiskAmp PersonalNoNoNoNoNoNoNoNo
RiskAmp ProfessionalNoNoNoNoNoNoNoNo
SAFE TOOLBOXESNoYesNoYesNoYesYesYes
Simtools xlaNoNoNoNoNoNoNoNo
SimilarNoNoNoNoNoNoNoNo
Simulation Master PremiumNoNoYesNoNoNoNoNo
Simulation Master StandardNoNoYesNoNoNoNoNo
YASAI and YASAIwNoNoNoNoNoNoNoNo

Simulation Controls

NameControl of seed values Maximum numbers of draws [28] Random number generator Lock / unlock random variables [29] Multiple simulation runs [30] Run macros before/after simulation [31] Stop run when output generates error [32] Apply specific sample in model [33] Precision control [34] Spreadsheet interpreter [35] Sampling method [36]
@RISK IndustrialYesUnlimitedSeveralYesYesYesYesYesYesNo MC, LHS
@RISK ProfessionalYesUnlimitedSeveralYesYesYesYesYesYesNo MC, LHS
ArgoYes20000 Mersenne Twister YesNoNoNoYesNoYes MC, LHS
Crystal BallYesUnlimitedMCG [37] YesYesYesYesNoYesYes MC, LHS
Crystal Ball + Decision OptimizerYesUnlimitedMCG [37] YesYesYesYesNoYesYes MC, LHS
DiscoverSim + SigmaXLYes1e7Marsaglia KISS + MonsterNoNoNoNoNoNoYes MC, LHS
ErsatzNoUnlimited7 RNGsYesYesYesNoNoNoNo MC
MC FLOYesUnlimited / Constrained by Excel Mersenne Twister YesYesNoYesYesNoNo MC
ModelRisk CompleteYesUnlimited Mersenne Twister YesYesYesYesYesYesNo MC
ModelRisk BasicYesUnlimited Mersenne Twister YesYesYesYesYesYesNo MC
Monte CarnivalNoUnlimitedSeveralYesYesNoYesNoNoNo
Quantum XLNo10000 Mersenne Twister NoNoNoNoNoYesYes MC
Risk AnalyzerNoConstrained by Excel?NoNoNoNoNoNoNo MC
Risk Kit SuiteYesUnlimited Mersenne Twister NoYesYesYesNoNoNo MC
Risk Solver ProYesUnlimitedSeveralYesYesYesNoYesNoYes MC, LHS, Sobol
Risk Solver Pro + Premium Solver ProYesUnlimitedSeveralYesYesYesNoYesNoYes MC, LHS, Sobol
RiskAmp PersonalYesConstrained by Excel Mersenne Twister YesNoNoNoNoNoNo MC, LHS
RiskAmp ProfessionalYesConstrained by Excel Mersenne Twister YesNoNoNoNoNoNo MC, LHS
SAFE TOOLBOXESYesUnlimitedMersenne Twister, RanLux and GFSRGYesYesYesNoYesNoNo MC, Antithetic, Fauré,Halton
Simtools xlaNoConstrained by ExcelExcel's RANDNoNoNoNoNoNoNo MC
SimilarNoConstrained by Excel?YesNoNoNoNoNoNo MC
Simulation Master PremiumYesConstrained by ExcelMCG [37] , Excel's RANDYesYesNoNoNoNoNo MC
Simulation Master StandardYesConstrained by ExcelMCG [37] , Excel's RANDYesNoNoNoNoNoNo MC
YASAI and YASAIwYesConstrained by ExcelL'Ecuyer's MRG32k3a [38] NoYesYesNoNoNoNo MC

Reporting results

NameIncludes reporting toolReport export formats [39] Save and retrieve resultsEditing of graphs [40] Histogram Cumulative Time series plotSpider [41] Tornado Scatter Pareto Box Statistics Simulation dataResults filtering [42]
@RISK IndustrialYesExcel, bitmapYesYesYesYesYesYesYesYesYesYesYesYesYes
@RISK ProfessionalYesExcel, bitmapYesYesYesYesYesYesYesYesYesYesYesYesYes
ArgoYesExcel, bitmapYesYesYesYesNoYesYesYesNoNoYesYesNo
Crystal BallYesExcelYesYesYesYesYesYesYesYesYesNoYesYesYes
Crystal Ball + Decision OptimizerYesExcelYesYesYesYesYesYesYesYesYesNoYesYesYes
DiscoverSim + SigmaXLYesExcelYesYesYesNoYesNoYesYesYesYesYesYesYes
ErsatzNoExcelYesYesYesNoNoNoYesYesNoNoYesNoNo
MC FLOYesExcelYesYesYesYesYesN/AYesYesYesN/AYesYesYes
ModelRisk CompleteYesPDF, PowerPoint, Word, Excel, ModelRisk ResultsViewer, bitmapYesYesYesYesYesYesYesYesYesYesYesYesYes
ModelRisk BasicYesPDF, PowerPoint, Word, Excel, ModelRisk ResultsViewer, bitmapYesYesYesYesYesYesYesYesYesYesYesYesYes
Monte CarnivalYesExcelYesYesNoNoNoNoNoNoNoNoYesYes
Quantum XLNoN/AExcelN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Risk AnalyzerNoN/AExcelN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Risk Kit SuiteYesExcelNoYesYesYesYesYesYesYesYesYesYesYesNo
Risk Solver ProYesExcelYesYesYesYesYesYesYesYesNoYesYesYesYes
Risk Solver Pro + Premium Solver ProYesExcelYesYesYesYesYesYesYesYesNoYesYesYesYes
RiskAmp PersonalNoExcelN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
RiskAmp ProfessionalNoExcelN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
SAFE TOOLBOXESYesNot required.YesYesYesYesYesNoNoYesNoYesYesYesYes
Simtools xlaNoExcelN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
SimilarNoExcelN/AN/AYesYesN/AYesYesN/AN/AN/AYesYesN/A
Simulation Master PremiumYesExcelYesYesYesYesYesYesYesYesNoNoYesYesNo
Simulation Master StandardYesExcelYesYesYesYesNoYesYesYesNoNoYesYesNo
YASAI and YASAIwNoExcelN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AYesN/A

Help file, support and training

Name UDFs linked to help file [43] Interfaces linked to help file [44] Help file in PDFHelp file onlineTechnical support availableLanguage versions [45] Online videosOnline trainingOnsite training
@RISK IndustrialYesYesYesYesYesZH, EN, FR, DE, JA, PT, ESYesYesYes
@RISK ProfessionalYesYesYesYesYesZH, EN, FR, DE, JA, PT, ESYesYesYes
ArgoNoNoYesYesYesENNoNoYes
Crystal BallNoYesYesYesYesEN, JA, ES, DE, FR, PTYesYesVia Partners
Crystal Ball + Decision OptimizerNoYesYesYesYesEN, JA, ES, DE, FR, PTYesYesVia Partners
DiscoverSim + SigmaXLN/AYesYesYesYesENYesNoYes
ErsatzNoNoYesYesYesENNoNoNo
MC FLONoNoYesNoYesDE, EN, ESYesNoNo
ModelRisk CompleteYesYesYesYesYesENYesYesYes
ModelRisk BasicYesYesYesYesYesENYesYesYes
Monte CarnivalYesYesYesYesYesENYesNoNo
Quantum XLN/AYesNoNoYesENNoNoYes
Risk AnalyzerN/AN/ANoNoYesENNo??
Risk Kit SuiteYesYesNoNoYesEN, FR, DEYesNoYes
Risk Solver ProYesYesYesYesYesENYesYesYes
Risk Solver Pro + Premium Solver ProYesYesYesYesYesENYesYesYes
RiskAmp PersonalNoNoYesYesYesENNoNoNo
RiskAmp ProfessionalNoNoYesYesYesENNoNoNo
SAFE TOOLBOXESNoNoNoYesYesENYesNoNo
Simtools xlaNoNoNoNoNoENNoNoNo
SimilarNoNoYesNoYesEN, ESNoNoNo
Simulation Master PremiumNoYesYesYesYesENYesNoNo
Simulation Master StandardNoYesYesYesYesENYesNoNo
YASAI and YASAIwNoNoNoNoNoENNoNoNo

See also

Footnotes and references

  1. 1 2 @RISK manual version 7.0, Palisade Corporation http://www.palisade.com
  2. Booz Allen Hamilton, Argo https://boozallen.github.io/argo/
  3. 1 2 Crystal Ball manual: Oracle® Crystal Ball http://www.oracle.com/us/products/applications/crystalball/index.html, Fusion addition Release 11.1.1.3 Statistical Guide
  4. DiscoverSim Workbook: SigmaXL® DiscoverSim http://www.sigmaxl.com/DiscoverSim_Features.shtml
  5. Ersatz website: http://www.epigear.com/index_files/ersatz.html
  6. MC FLO online resources: https://www.mcflosim.ch/en/
  7. 1 2 ModelRisk online help file: http://www.vosesoftware.com/vosesoftware/ModelRiskHelp/
  8. "Monte Carlo Simulation Add-In for Microsoft Excel - Monte Carnival". montecarnival.com. Retrieved 2018-01-16.
  9. Help file downloadable with software at http://www.sigmazone.com/
  10. The Risk Kit Suite is available as portable (no admin-rights required) or installer version. It consists of Risk Kit for Monte-Carlo simulations, Risk Kit R for advanced statistical analyses, and Risk Kit Data for an online data feed of financial data and social statistics from the European Central Bank ECB, the World Bank, the Federal Reserve Economic Data FRED, Eurostat and Yahoo!Finance. Risk Kit Suite on corporate website: https://www.wehrspohn.info/en/products/risk-kit-suite.html
  11. 1 2 Risk Solver online user guide: http://www.solver.com/suppxlsguide.htm
  12. 1 2 RiskAmp online user guide: http://www.riskamp.com/library/howto.php
  13. SAFE TOOLBOXES website: http://www.safetoolboxes.com
  14. http://home.uchicago.edu/rmyerson/addins.htm#simt
  15. Help file downloadable with software at http://www.simularsoft.com.ar/
  16. 1 2 "Simulation Master - Monte Carlo Simulation Add-In for Excel". Vortarus Technologies LLC. Retrieved 2018-01-28.
  17. http://tukhi.com/
  18. http://www.yasai.rutgers.edu/
  19. "Archived copy". Archived from the original on 2007-05-25. Retrieved 2014-02-06.CS1 maint: archived copy as title (link)
  20. Excel has tools for calculating correlation statistics for a data set. This refers to the software's ability to fit correlation structures to a data set and, where more than one correlation structure is available, to compare the levels of fit.
  21. Some add-ins provide VBA versions of their UDFs, which allow the user to build their own stochastic UDFs in VBA. Some add-ins also provide VBA functions that control a simulation. This allows the user to create VBA macros that will automatically run simulations and generate results.
  22. Some add-ins allow calls to C++ routines. These allow the user to create a stand-alone DLL that represents a part of the model which needs to be as fast as possible by making use of the faster performance of the original code (usually C++)
  23. Integrable as .NET-assembly
  24. Provides the facility to calculate probability mass (or density), cumulative probability, moments, etc. of a distribution directly in the spreadsheet.
  25. Standard error messages like #VALUE! when an input parameter is invalid is replaced by a message describing the reason of the error.
  26. Tools to evaluate the distribution of the minimum or maximum sample from a set of IIDs
  27. Graphical interfaces to facilitate determining distribution of uncertainty of some model parameter based on expert opinion.
  28. Some add-ins do not have a custom results viewer and export the data directly into the spreadsheet for analysis using the spreadsheet's native charting and statistical tools. The number of draws is then restricted by the ability of the spreadsheet to handle the size of the generated data.
  29. The ability to replace a random variable with a fixed value.
  30. Some add-ins allow the user to automatically run a model multiple times replacing decision variables with different values for each simulation run
  31. Some add-ins allow the user to run a VBA macro before a simulation (e.g. to import data from an external source), after a simulation (e.g. to export the results to a database) or before or after a random draw of the model (e.g. to perform an optimization).
  32. Stopping a simulation run when an output variable generates an error is a useful feature for debugging a model
  33. After a simulation run the user is able to insert a specific generated result back into the spreadsheet. This is useful, for example, if one wants to investigate the generated scenario that created the greatest profit or loss.
  34. The ability to specify a required level of precision for output results, usually the accuracy with which the mean or a percentile of the output has been determined. Precision control will stop a simulation run when the required accuracy is achieved
  35. Some add-ins will create a compiled version of the spreadsheet model before simulation. This has the benefit of a far faster simulation speed, but will not work with many types of models e.g. models that include VBA calls or functions like OFFSET and VLOOKUP.
  36. Only Monte Carlo sampling is compatible with copula correlation structures. Using Latin Hypercube or Sobol sampling removes the possibility of using other correlation structures like Archimedean copulas.
  37. 1 2 3 4 Multiplicative Congruential Generator
  38. L'Ecuyer et al. 2002. An object-oriented random-number package with many long streams and substreams. Operations Research 50(6)1073-1075. http://www.iro.umontreal.ca/~lecuyer/myftp/papers/streams00.pdf
  39. Exporting file formats to share graphical and statistical results.
  40. Ability to change colour schemes, fonts, add markers and legends, etc.
  41. See, for example: https://www.google.ca/search?q=spider+sensitivity+analysis&tbm=isch&tbo=u&source=univ&sa=X&ved=0ahUKEwjazfDmvOvJAhVJmR4KHTYJBO4QsAQIIA&biw=1920&bih=906
  42. The ability to select a subset of the simulation results (e.g. scenarios that result in a loss) thereby allowing the user to investigate scenarios of greatest interest.
  43. In Excel the Insert Function dialog box includes a 'Help on this function'-hyperlink. Some add-ins use this feature to provide a direct link to the applicable help file topic.
  44. Some add-ins with visual interfaces and dialog boxes include a help icon that directly links to the applicable help file topic for that interface
  45. ZH = Chinese, EN = English, FR = French, DE = German, JA = Japanese, PT = Portuguese, ES= Spanish

Further reading

International Standard Book Number Unique numeric book identifier

The International Standard Book Number (ISBN) is a numeric commercial book identifier which is intended to be unique. Publishers purchase ISBNs from an affiliate of the International ISBN Agency.

Related Research Articles

A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. A spreadsheet may also refer to one such electronic document.

Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6, which was declared legacy in 2008, and its associated integrated development environment (IDE). Although pre-.NET Visual Basic is no longer supported or updated by Microsoft, the VBA programming language was upgraded in 2010 with the introduction of Visual Basic for Applications 7 in Microsoft Office applications.

SPSS Statistical analysis software

SPSS Statistics is a software package used for interactive, or batched, statistical analysis. Long produced by SPSS Inc., it was acquired by IBM in 2009. The current versions (2015) are named IBM SPSS Statistics.

Windows Script Host

The Microsoft Windows Script Host (WSH) is an automation technology for Microsoft Windows operating systems that provides scripting abilities comparable to batch files, but with a wider range of supported features. This tool was first provided on Windows 95 after Build 950a on the installation discs as an optional installation configurable and installable by means of the Control Panel, and then a standard component of Windows 98 and subsequent and Windows NT 4.0 Build 1381 and by means of Service Pack 4. The WSH is also a means of automation for Internet Explorer via the installed WSH engines from IE Version 3.0 onwards; at this time VBScript became means of automation for Microsoft Outlook 97. The WSH is also an optional install provided with a VBScript and JScript engine for Windows CE 3.0 and following and some third-party engines including Rexx and other forms of Basic are also available.

Monte Carlo methods are used in corporate finance and mathematical finance to value and analyze (complex) instruments, portfolios and investments by simulating the various sources of uncertainty affecting their value, and then determining the distribution of their value over the range of resultant outcomes. This is usually done by help of stochastic asset models. The advantage of Monte Carlo methods over other techniques increases as the dimensions of the problem increase.

In mathematical finance, a Monte Carlo option model uses Monte Carlo methods to calculate the value of an option with multiple sources of uncertainty or with complicated features. The first application to option pricing was by Phelim Boyle in 1977. In 1996, M. Broadie and P. Glasserman showed how to price Asian options by Monte Carlo. In 2001 F. A. Longstaff and E. S. Schwartz developed a practical Monte Carlo method for pricing American-style options.

Financial modeling is the task of building an abstract representation of a real world financial situation. This is a mathematical model designed to represent the performance of a financial asset or portfolio of a business, project, or any other investment.

RATS, an abbreviation of Regression Analysis of Time Series, is a statistical package for time series analysis and econometrics. RATS is developed and sold by Estima, Inc., located in Evanston, IL.

VisIt

VisIt is an open-source interactive parallel visualization and graphical analysis tool for viewing scientific data. It can be used to visualize scalar and vector fields defined on 2D and 3D structured and unstructured meshes. VisIt was designed to handle very large data set sizes in the terascale range and yet can also handle small data sets in the kilobyte range.

GNU MCSim is a suite of simulation software. It allows one to design one's own statistical or simulation models, perform Monte Carlo simulations, and Bayesian inference through Markov chain Monte Carlo simulations. The latest version allow the use of simulated tempering MCMC simulations.

XLfit is a Microsoft Excel-based plug-in which performs Regression, curve fitting and statistical analysis. XLfit generates 2D and 3D graphs and analyses data sets produced by any type of research. XLfit’s curve fitting engine allows linear and non-linear curve fits, smoothing, statistics, weighting and error bars.

Fairmat

Fairmat is a free-of-charge multi-platform software that allows to model financial contracts or projects with many contingencies by decomposing it into basic parts. Complex structures and dependencies are modelled using a graphical interface. Virtually any pay-off function and asset class( from interest rate derivatives to equity-linked notes) can be described using a simple algebraic language.

Ecolego

Ecolego is a simulation software tool that is used for creating dynamic models and performing deterministic and probabilistic simulations. It is also used for conducting risk assessments of complex dynamic systems evolving over time.

Stochastic empirical loading and dilution model

The stochastic empirical loading and dilution model (SELDM) is a stormwater quality model. SELDM is designed to transform complex scientific data into meaningful information about the risk of adverse effects of runoff on receiving waters, the potential need for mitigation measures, and the potential effectiveness of such management measures for reducing these risks. The U.S. Geological Survey developed SELDM in cooperation with the Federal Highway Administration to help develop planning-level estimates of event mean concentrations, flows, and loads in stormwater from a site of interest and from an upstream basin. SELDM uses information about a highway site, the associated receiving-water basin, precipitation events, stormflow, water quality, and the performance of mitigation measures to produce a stochastic population of runoff-quality variables. Although SELDM is, nominally, a highway runoff model is can be used to estimate flows concentrations and loads of runoff-quality constituents from other land use areas as well. SELDM was developed by the U.S. Geological Survey so the model, source code, and all related documentation are provided free of any copyright restrictions according to U.S. copyright laws and the USGS Software User Rights Notice. SELDM is widely used to assess the potential effect of runoff from highways, bridges, and developed areas on receiving-water quality with and without the use of mitigation measures.. Stormwater practitioners evaluating highway runoff commonly use data from the Highway Runoff Database (HRDB) with SELDM to assess the risks for adverse effects of runoff on receiving waters.

SolverStudio is a free Excel plug-in developed at the University of Auckland that supports optimization and simulation modelling in a spreadsheet using an algebraic modeling language. It is popular in education, the public sector and industry for optimization users because it uses industry-standard modelling languages and is faster than traditional Excel optimisation approaches.

Micro Saint Sharp

Micro Saint Sharp is a general purpose discrete-event simulation and human performance modeling software tool developed by Alion Science and Technology. It is developed using C# and the .NET framework. Micro Saint Sharp allows users to create discrete-event simulations as visual task networks with logic defined using the C# programming language.