Random number generation using discrete probability distribution.
The time between arrivals of cars at the Petroco Service Station is defined by the following probability distribution:
|
Time between intervals(min)
|
Probability
|
|
1
|
0.15
|
|
2
|
0.30
|
|
3
|
0.40
|
|
4
|
0.15
|
|
|
1.00
|
Using Excel:
1. Simulate the arrival of cars at the service station for 20 arrivals and compute the average time between stations.
2. Simulate the arrival of the cars at the service station for 1 hour, using a different stream of random numbers from those used in (a) and compute the average time between arrivals.
3. Compare the results obtained in (a) and (b).