bus simulation in excel, exponential distribution departure


by AGS
Tags: departure, distribution, excel, exponential, simulation
AGS
AGS is offline
#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
Better thermal-imaging lens from waste sulfur
Hackathon team's GoogolPlex gives Siri extra powers
Bright points in Sun's atmosphere mark patterns deep in its interior
Cygni
Cygni is offline
#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