Scribd
Upload
4 views7 pages

Simulating Random Service Times in Excel

This document outlines a module on simulating random service times using Monte Carlo simulation. It describes the assignment of discrete values to callers based on specified probabilities and demonstrates how to convert continuous numbers to discrete values using cumulative probability in Excel VBA. The key takeaway is the importance of assigning limits based on cumulative probability for each value in the simulation.

Uploaded by

homeimran0335
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
4 views7 pages

Simulating Random Service Times in Excel

This document outlines a module on simulating random service times using Monte Carlo simulation. It describes the assignment of discrete values to callers based on specified probabilities and demonstrates how to convert continuous numbers to discrete values using cumulative probability in Excel VBA. The key takeaway is the importance of assigning limits based on cumulative probability for each value in the simulation.

Uploaded by

homeimran0335
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Modeling and Simulation

Simulating a Random
Service Time

1
Simulating a Random Service Time

• In this module, we shall


see how we can
simulate a Random
service time

2
The Problem

• We want to simulate a set


of discrete values from
continuous variables.
• Callers are assigned 3
different times with
different probabilities.
• 3 with a probability of
30%
• 6 with a probability of
45%
• 10 with a probability of
25%

3
Type of Simulation: Monte Carlo Simulation

• There are no events


• No clock times being
tracked

4
Description: Solution

• The spreadsheet example


converts the continuous
number to discrete using
cumulative probability

5
Simulation

6
Summary
• In this module, we have
examined how we can
use Excel VBA functions
to simulate a discrete
distribution.
• The key idea is to assign
limits based on
cumulative probability
for each value

You might also like