Question: please help solve in excel using rand() function The time between arrivals of cars at the Petroco Service Station is defined by the following probability

please help solve in excel using rand() function

The time between arrivals of cars at the Petroco Service Station is defined by the following probability distribution: a. Simulate the arrival of cars at the service station for 20 arrivals, and compute the average time between arrivals. b. Simulate the arrival of 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. c. Compare the results obtained in (a) and (b)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Please do assignment in the worksheet MAT540Week 3 HomeworkChapter 141. The Hoylake Rescue Squad receives an emergency call every 1, 2, 3, 4, 5, or 6 hours, according tothe following probability...

MAT540 Homework Week 3 Page 1 of 3 MAT540 Week 3 Homework Chapter 14 1. The Hoylake Rescue Squad receives an emergency call every 1, 2, 3, 4, 5, or 6 hours, according to the following probability...

Hoylake Rescue Squad Probability of Time between calls P(x) 0.15 0.1 0.2 0.25 0.2 0.1 1 Cumulative (lower Time between bound) calls 1 2 3 4 5 6 EV = Average Time = Simulation simulation Number 1 2 3...

MAT540 Homework Week 3 Page 1 of 3 MAT540 Week 3 Homework Chapter 14 1. The Hoylake Rescue Squad receives an emergency call every 1, 2, 3, 4, 5, or 6 hours, according to the following probability...

1. The Hoylake Rescue Squad receives an emergency call every 1, 2, 3, 4, 5, or 6 hours, according to the following probability distribution. The squad is on duty 24 hours per day, 7 days per week:...

in excel and the steps please 2. The time between arrivals of cars at the Petroco Service Station is defined by the following probability distribution: Time Between Arrivals (min.) Probability 1 .15...

Please help with the below question. The time between arrivals of cars at the Petroco Services Station is defined by the following probability distribution: Time Between Emergency Calls (hr.)...

1.) The time between arrivals of cars at the Petroco Service Station is defined by the following probability distribution: Time Between Arrivals (min.) Probability 1 0.25 2 0.3 3 4 0.35 0.1 a.)...

1) A suburban specialty restaurant has developed a single drivethru window. Customers order, pay, and pick up their food at the same window. Arrivals follow a Poisson distribution, while service...

The time between arrivals of cars at the Petroco Service Station is defined by the following probability distribution. Time Between Arrivals Probability 1 .15 2 .30 3 .40 4 .15 = 1.00 A. Simulate the...

a) If you were constructing a 95% confidence interval of the population mean based on a sample of n=60 where the standard deviation of the sample s = 0.06, what is the critical value of t that you...

Sales managers would like to know whether their customers orders can be fulfilled or not. In long-term planning for the next half-year, the company has put up the master production schedule, and the...

Interest earned on Series EE bonds, U . S . Treasury bills, and U . S . Treasury bonds is Group of answer choices taxable at both the federal and state levels. not taxable at the federal or state...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...