You do not need to create a distribution for each input cell - use one distribution for a group of related cells. Ĭustomizable probability distribution.Your input variables (cells) and their distributions are listed on a special premise sheet for you to conveniently review. No annual support contract required to talk to a support person for help. Three helpful example files with step by step instructions show you how to use the Risk Analyzer. Many other Monte Carlo simulation programs embed special functions that require all users of the workbooks to purchase their expensive programs.Įasy to learn - you do not need to attend expensive training courses to learn how to use.

You do not put any special functions into your workbooks, which allows you to share your workbooks with others who do not have the Risk Analyzer.

Sample Input Variable Distribution ReportĮxtremely fast flexible and completely menu driven for ease of use.

The following are worksheets and reports (PDF format) constructed by the Risk Analyzer.

The following is a sample Excel Model (PDF format):Įxcel model of a construction estimate and profit - constructed by the user The following illustrates the different types of distributions that are available, each of which can be customized to your needs: All you need to know is what values your input variables are likely to have: the minimum and maximum values and the distribution shape (uniform normal or skewed in one direction). It is unnecessary to embed custom functions into your workbooks. You do not need to know statistics or how to write probability formulas in order to use the Risk Analyzer. Monte Carlo simulation is simply the creation of many 'what if' cases to determine the expected results of a study. The Risk Analyzer works by doing Monte Carlo simulations. In addition to result charts like the one above, the Risk Analyzer also gives you histograms that show cumulative probabilities and tornado charts that show the sensitivity of the output variables to your input variables. The Risk Analyzer gives you tables and graphics that illustrate the risks of the proposal. It is compatible with Microsoft Excel 2007 to 2021 and Office 365. Then the Risk Analyzer add-in for Microsoft Excel is

If you are evaluating an investment proposal,Ī proposal involving financial risk, or a scientific study,

Excel image assistant crack