Basic Monte Carlo Simulation Using Simulation Master

This video demonstrates a basic Monte Carlo simulation using Simulation Master. Simulation Master is an Excel add-in for Monte Carlo simulation. For more information, please visit the Simulation Master product page.

Basic Monte Carlo Simulation Topics

Random variable function set-up in Excel model

Using the Simulation Master "RV" worksheet functions to create random variables used to generate random variable values during the simulation.

Coloring model inputs for easy identification

Simulation Master has a tool that identifies "RV" worksheet functions that are random variable inputs and will color them green with one click.

Running the simulation

How to enter simulation parameters and run the simulation.

Probability analysis of simulation results

Analyzing the probability of a range of outcomes using the probability analysis tool.

Creating a summary report

How to create a summary report that contains summary statistics, histogram, frequency polygon, and cumulative frequency chart.


For more videos, visit our YouTube channel.

Excel is a registered trademark of Microsoft Corporation.  Used with permission from Microsoft.