Table of Contents - Monte Carlo Simulation Tutorial

• Introduction to Monte Carlo

• Monte Carlo building blocks in Excel

  • Worksheet-based and VBA-based approaches

  • Using the RAND() function

  • Learning to model the problem

• Building a worksheet-based simulation

  • Simple coin-toss

  • How many iterations are enough?

  • Multiple coin-toss

  • Commute time

    • Defining the problem

    • Modeling the variables

    • Building the worksheet

  • Analyzing the data

    • Freezing the model

      • Manual recalculation

      • "Paste Values" function

    • Basic statistical functions

    • PERCENTILE() function

    • Excel charts

• Building a VBA-based simulation (Visual Basic for Applications)

  • Creating a VBA module

  • Creating a VBA Monte Carlo function

  • Function input from worksheet

  • Function output to worksheet

    • Single cell approach

    • Data table approach

  • Simple coin-toss

  • Multiple coin-toss

  • Commute time

• Advanced topics

  • Modeling normal distributions

  • Modeling probability distributions

  • Analysis using pivot tables and charts

• More examples

Prev | Next