Modeling and Simulation

Simulating a Coin Toss

1
Simulating a Coin Toss

• In this module, we shall

see how we can
simulate a coin toss
using Excel

2
The Problem

• We want to simulate a
sequence of 10 coin
tosses.
• Coin is a “fair” coin
• Fair means same chance
of heads vs. tail

3
Type of Simulation: Monte Carlo Simulation

• There are no events

• No clock times being
tracked

4
Description: Solutions

• The spreadsheet example

has 4 solutions.
• Two use RAND() and
other two use Rnd01
function

5
Simulation

6
Summary

• In this module, we have

examined how we can use
VBA to simulate a coin
toss.