How do I perform a Monte Carlo simulation in Excel?
 

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 ...

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