ab-logo

Code. Models. Analysis. Decisions.


Monte Carlo Simulation Tutorial with Excel

Video collection of data analysis tutorials with Monte Carlo Simulation using pure Excel and it's built-in Data Table feature. Monte Carlo simulation allows the analysis of complex systems that deal with uncertainty. The techniques demonstrated are native to Excel, no add-ins are used.

Monte Carlo Simulation is generally used to evaluate uncertainty or risk in real-life decision making where data is used to develop probability distributions on which to base uncertainty. Monte Carlo is particularly well-suited to model finance and investment decisions in both long and short term time horizons.

The spreadsheets used in these videos:

Portfolio Simulation

Stock Price Simulation

You may also be interested in a Monte Carlo Simulation tutorial in Python.

Porfolio Simulation

Stock Price Simulation