You can use this addin called mcsim for excel to do monte carlo

http://www3.wabash.edu/econometrics/EconometricsBook/Basic%20Tools/ExcelAddIns/MCSim.htm

Or you can use r

Down load r here

https://cran.r-project.org/bin/windows/base/

http://www.stat.ufl.edu/archived/casella/ShortCourse/MCMC-UseR.pdf

some examples

https://support.office.com/en-us/article/Introduction-to-Monte-Carlo-simulation-64c0ba99-752a-4fa8-bbd3-4450d8db16f1#bm5

http://www.lumenaut.com/download/examples/Oil&Gas/Reserve%20Estimation/monte_carlo_%20oil_and_gas%20_reserve_estimation_080601.pdf

https://www.countbayesie.com/blog/2015/3/3/6-amazing-trick-with-monte-carlo-simulations

https://web.stanford.edu/class/bios221/labs/simulation/Lab_3_simulation.html

If you state what you are trying to simulate, I might be able to help.

Monte Carlo simulations is a widely used techniques these days, and certainly in ohysics and chemistry of fluids (in the bulk or near an interface) such simulations are accepted as gold standard. I am more familiar with the techniques involved in simulation of fluids. Perhaps the best practical reference I can cite is the book of Allen and Tylsdeley on Computer simulation of liquids. The exact title might be slightly different though.

I usually use excel, combined with macros, visual basic for creating my functions and data table command.

Example of Monte Carlo simulation using excel and data table can be found in the link below:

https://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/

But as Mr. Sood wrote, it depends on what you are trying to simulate.

Regards,

Erion

Your question is similar like "which car should i buy" ?

It depend on your budget, your city condition, your salary, number of your childs so on.

Please first mention about your research interests and your aim to apply MC simulations. In this way, your question will be much more suitable to discuss.

It seems that you have not quite understood what "Monte Carlo Simulation" actually is.

Say, you have a system that can go into 3 different states, with a probability of 50%, 30% and 20%. The only condition is that all probabilities have to add to 100%.

Then you let the computer calculate a (pseudo-) random number r, these are usually in the range of 0..1. The name "Monte Carlo" actually comes from this randomness, after the famous casino.

if (r