Monte Carlo Analysis

Replies to This Discussion

Permalink Reply by Retha Kwok on March 14, 2008 at 10:43am

Here's one by Humberto Barreto and Frank M. Howland from the Econometrics department of Wabash College.

I think the real advantage of this Monte Carlo analysis Excel add-in over others is its simplicity in use, installation instructions and (what I hear to be) good ongoing support provided by its developers / authors.

Here's a description of the Excel add-in from their website:

This add-in, MCSim.xla, enables Monte Carlo simulation from any Excel sheet. The logic is quite simple: you select a cell that has or depends upon a random number (using either Excel's RAND or our RANDOM function) and the add-in recalculates the sheet for as many repetitions as you request. It outputs the results to a new sheet with summary statistics and a histogram. You may Monte Carlo more than one cell and you have several other options.

Attachments:

• MCSim.xla, 312 KB
• MCSim Installation Instructions.doc, 162 KB

▶ Reply to This

Permalink Reply by Yugesh on March 15, 2008 at 2:59am

Hi Retha

Thanks for providing info on MC analysis...I have not yet tried the add in provided by you...i will try it to run my model...

And come back to you..

Thanks once again

Yugesh

▶ Reply to This

Permalink Reply by luke on March 23, 2008 at 5:12pm

hi thanks mate just trying out the site and found out about this.
thanks

luke.

▶ Reply to This

Permalink Reply by vivek on July 13, 2009 at 10:59am

Hello Retha,

I am not able to open the excel file could you please send anoher one...

Cheers,

Vivek
viveknaik2006@gmail.com

▶ Reply to This

Permalink Reply by fabian on April 9, 2008 at 4:44pm

try the free version of "crystal ball" soft

▶ Reply to This

Permalink Reply by Dulanjie De silva on May 8, 2008 at 3:56am

Hi Yugesh,

I am Dulanjie Workig on a construction project for a new business. I need to evaluate the risks and variables undelying the different scenarios with respect to this project. I would be thankfull if you can send me the montecarlo X cel, if you have already reeived it, since it will make my workload much easier ,simpler and accurate.

▶ Reply to This

Permalink Reply by Yugesh on May 8, 2008 at 5:09am

Hi Dulanjie

MC Sim.xla file is already uploaded in ths forum by our friend Retha...

Apart from that i hvnt used any other software for MC analysis...

Yugesh

▶ Reply to This

Permalink Reply by Ricky on December 13, 2008 at 1:05pm

Many thanks. I'll use it for my school project work.

▶ Reply to This

Permalink Reply by Enrique Gonzalez on July 11, 2009 at 2:26pm

Hello all,

There exists an excellent alternative in terms of software for Monte Carlo Analysis. It is SIMULAR, developed by Professor Luciano Machain from the National University of Rosario in Argentina. I suggest you visit his web page at: http://www.simularsoft.com.ar/

You don't have to pay for the software but professor Machain acepts donations or at least an example of a model where his package was successfully used.

Regards,

Enrique

▶ Reply to This