Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I perform a Monte Carlo simulation in Excel?
|
#2
|
|||
|
|||
What a large topic. Can you be more specific?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Pedro Fragoso Pires" <Pedro Fragoso wrote in message ... |
#3
|
|||
|
|||
Pedro Fragoso Pires -
Build some kind of spreadsheet model with some uncertain inputs and an output that depends on those uncertain inputs. If you want to only use Excel's built-in features, use RAND and transformations of RAND to provide random values for the uncertain inputs. Use Excel's Data Table command to recalculate inputs and collect corresponding output values. Summarize the output values using Excel's Descriptive Statistics and Histogram data analysis tools, or use Excel's worksheet functions and Chart Wizard. If you want to use an Excel add-in to handle most of those tasks (after you have built your own model), you could try my RiskSim add-in, with tryout version and manual available from the "Download Free Tryout" page at www.treeplan.com. Or, use Crystal Ball from www.crystalball.com or @Risk from www.palisade.com. - Mike www.mikemiddleton.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
OPENING TWO DIFFERENT EXCEL PROGRAMS | Excel Discussion (Misc queries) | |||
pivotcell object to excel 2000 | Excel Discussion (Misc queries) |