Simulate the arrival of cars at the service station

Reference no: EM1322616

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).

Reference no: EM1322616

Questions Cloud

Comparison of paired and unpaired samples test : Comparison of paired and unpaired samples test - Identify which of the two tests (Independent samples and Paired samples) test is the preferred test and justify your choice.

Dice probabilities using excel : If the player does not win or lose on his second roll he continues to roll, using the same criteria given for the second roll.

Provide a brief description of the main features : Provide a brief description of the main features of these data from the scatter plot and Describe why you would use performance as the predictor variable and performane related pay as the dependent variable in such a model.

Probability by normal approximation for data : What is the probability that the next 100 customers will spend an average of less than $56 on dinner?

Simulate the arrival of cars at the service station : Simulate the arrival of cars at the service station for 20 arrivals and compute the average time between stations and Simulate the arrival of the cars at the service station for 1 hour

Finding probability of a rating : If an applicant is randomly selected, find the probability of a rating that is between 200 and 275.

Model assumptions for a regression model : Fitting of multiple linear regression equation - Give a list of the model assumptions for a regression model.

Find the indicated probability : The diameters of bolts produced by a certain machine are normally distributed with a mean of 0.30 Inches and a standard deviation of 0.01 inches.

Challenges on accurate data gathering : Describe methods you would use to analyze one of these three different markets: consumer, industrial or international markets. What challenges would you face to ensure accurate data gathering in the market

User Account

All Pages