Part 2. MM4XL Tools > 1. Strategic Tools > Risk Analyst > 4. Functions > 3. Distribution Functions > mmERLANG(Scale, Shape)

Risk Analyst

mmERLANG(Scale, Shape)

Example

=mmERLANG(2, 1) can equal 0.520087719

Application

This distribution is most used in relation to waiting-line theory, and it is used to calculate the time elapsing between events. It may help, for instance, to calculate how long it takes until the next client enters the shop, how long it takes to produce a handmade decoration, and so on.

How to use

This formula returns the amount of time between events. Say we are modeling the client flow to our fast-food restaurant. As a result of regular observation, we know that it takes 3 minutes for an employee to serve a client. The formula below may be used to simulate the amount of time between 0 and 5 minutes needed to serve a client:

=mmERLANG(3, 0.373)

Copy the formula above in 100 cells. You will find that most simulated values will range between 0 and 5, with over 98% of the values being less than 3 minutes.

Technical profile

Type Continuous distribution.
Syntax =mmERLANG(Scale, Shape)
Domain  Monte Carlo Simulation Software: Management Process Risk Analysis.
Mode If the Scale is larger than or equal to 1 then Mode = Shape(Scale-1)
Parameters Scale = b > 0; b = integer
Shape = c > 0
Remarks If any argument is nonnumeric mmERLANG returns the #VALUE! error value.
Relationships It is related to the Exponential and to the Gamma variates.
Graphs
mmERLANG(2, 1) mmERLANG(20, 5)
 Monte Carlo Simulation Software: Management Process Risk Analysis  Monte Carlo Simulation Software: Management Process Risk Analysis
Lifetime license:
MM4XL All Tools
Price: euro 238.00

Vote this tool
335 votes: vote vote vote vote vote
5 stars:
133
4 stars:
178
3 stars:
16
2 stars:
6
1 star:
2
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: