Register to reply

Bus simulation in excel, exponential distribution departure

Share this thread:
AGS
#1
Nov1-09, 03:40 AM
P: 1
1. The problem statement, all variables and given/known data

The bus service operates between points A and B. The buses depart from the terminal station A with headways that follow the negative exponentioal distributiona with parameter 10 trips per hour.
Assume that the characteristics of the system remain the same over time (not time dependent). Run simulation for 5 hours and find the average headway in each of the 5 hours.

So what Im having trouble with is the exponential distributed departure for each bus.

2. Relevant equations
no eq. given


3. The attempt at a solution
I think that the formula to work with is
f(x)=lamda*exp(-lamda*x)
Im little confused if lamda is 10 or 10/60=1/6 but it 1/6 makes more sence to me since I think the mean (mui=expected value) headway is 6 minutes and lamda=1/mui.
Im using excel and used the randbetween(0,35) to give me random x and than I plotted it and got a plot that looked ok. I also tried with lamda=10 but than I used rand() that gives random number between (0,1).
My problem is that I donīt know how to use this information to get random exponential distrebuted headways for each bus!
Should I maby use the inverse? T=-lnU/lamda (use rand() to get U)
Phys.Org News Partner Science news on Phys.org
Physical constant is constant even in strong gravitational fields
Montreal VR headset team turns to crowdfunding for Totem
Researchers study vital 'on/off switches' that control when bacteria turn deadly
Cygni
#2
Nov1-09, 05:51 AM
P: 38
Hey,

Given that you have time constraint, parameter [tex]\lambda[/tex] and that that the bus journeys are discrete I think u will have to use Poisson distribution to generate the probabilities, however, You must not forget to multiply the parameter by 5 as your simulation is going to take 5 hours. Once this is completed one can generate probabilities for 5 hour bus journeys and create a rule for simulation.


Register to reply

Related Discussions
Motion Simulation using Graphing Technique in Microsoft Excel Math & Science Software 0
Distribution Curve in excel Math & Science Software 3
Exponential growth and exponential distribution Set Theory, Logic, Probability, Statistics 3
Normal distribution in excel General Physics 11
Need help on radial distribution on excel Chemistry 1