Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can excel do Monte Carlo simulation?
Is it something I have buy?
|
#2
|
|||
|
|||
You can do Monte Carlos in Excel. It is not efficient for extremely complex
Monte Carlo. And you wil have to play with the data to do the million or multimillion monte carlo simulations. "Prads" wrote: Is it something I have buy? |
#3
|
|||
|
|||
Prads -
Is it something I have buy? < It is possible to perform Monte Carlo simulation using only Excel's built-in features. The uniform density random number generator worksheet function RAND can be used with various inverse cumulative distribution functions, e.g., NORMINV, to generate inputs to your worksheet model. The model can be recalculated and output values can be tabulated using Excel's Data Table command. The results can be charted using the Histogram tool or an XY (Scatter) chart for the cumulative frequency distribution. Add-ins for Excel automate many of these tasks. Visit Google.com, and search for "Excel Monte Carlo Simulation" (without the quotes). The industrial-strength add-ins are Crystal Ball (www.decisioneering.com) and @RISK (www.palisade.com). Many add-in developers offer tryout versions, like my own RiskSim (www.treeplan.com). - Mike www.mikemiddleton.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Software that works well with excel to conduct monte carlo simula. | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |