Answered step by step
Verified Expert Solution
Question
1 Approved Answer
NEED TO USE EXCEL SOLVER Q Cars arrive at a repair garage at an average rate of =3 per hour, Poisson distributed. Draw a probability
NEED TO USE EXCEL SOLVER
Q Cars arrive at a repair garage at an average rate of =3 per hour, Poisson distributed.
- Draw a probability distribution for the number of arrivals in an hour (say from 0 to 10). Use Excel's Poisson.dist function. This should look like the diagram at the bottom of slide #10 in the Analytics of Waiting Lines Ppt file.
- What is the probability that at least 2 cars will arrive in a one-hour time period?
- Draw a probability density function for the inter-arrival time. Use Excel's Expon.dist function.
- A car has just arrived at the garage. What is the probability that the next car will not arrive in at least the next 30 minutes?
- A car has just arrived at the garag What is the probability that the next car will arrive in between 10 and 15 minutes?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started