Monte Carlo Simulation Notes

Introduction to Monte Carlo Simulation

  • The Monte Carlo simulation is a method used to account for uncertainty in decision-making processes.
  • It provides a way to capture the impact of uncertainty in various scenarios.

Origin of the Monte Carlo Method

  • The method was first introduced in the late 1940s by Stanislaw Ulam and John von Neumann, while working on the nuclear weapons project at Los Alamos National Laboratory.
  • The term "Monte Carlo" is derived from the iconic casino in Monaco, chosen as a code name due to Ulam's uncle's gambling activities there.

Key Terminology

  • Probability Distribution: Represents a range of possible values for a random variable along with the associated probabilities of these values occurring.
  • Simulation Model: An extension of spreadsheet models that uses probability distributions in place of single values for parameters, allowing for more comprehensive modeling of uncertainty.
  • Random Variables: Parameters that are not known with high certainty; values for these are generated randomly in simulation models using specific functions in Excel.

Using Excel for Monte Carlo Simulations

  • Monte Carlo simulations will be executed using Excel.
  • Random Generation Functions: Excel’s functions will be employed to pull random values from various probability distributions, both discrete and continuous.
  • Different distributions may require different techniques within Excel for proper implementation.

Learning through Examples

  • The Sanatronic and Landshark examples will demonstrate:
    • How to extract values from different distributions.
    • How to run a Monte Carlo simulation using these distributions.
  • After conducting the simulation, outcomes such as average values, variability, confidence intervals, and probability questions can be analyzed.

Important Resources

  • Appendix 11.1 in the textbook is essential for understanding common probability distributions used in simulations.
    • This appendix includes:
    • A list of both continuous and discrete distributions.
    • Descriptions and examples of each distribution.
    • Instructions on how to implement these distributions in Excel.
  • Students are encouraged to utilize this resource for practice problems and homework to enhance their understanding of how to utilize different distributions effectively.