Can someone solve this using Microsoft Excel and use Poisson probability distribution. Airline passengers arrive randomly and independently at the passenger screening facility at a major international airport. The mean arrival rate is 10 passengers per minute. What is the probability of no arrivals in a 1-minute period? What is the probability of 3 or fewer arrivals in a 1-minute period? What is the probability of no arrivals in a 15-second period? What is the probability of at least 1 arrival in a 15-second period?
Continuous Probability Distributions
Probability distributions are of two types, which are continuous probability distributions and discrete probability distributions. A continuous probability distribution contains an infinite number of values. For example, if time is infinite: you could count from 0 to a trillion seconds, billion seconds, so on indefinitely. A discrete probability distribution consists of only a countable set of possible values.
Normal Distribution
Suppose we had to design a bathroom weighing scale, how would we decide what should be the range of the weighing machine? Would we take the highest recorded human weight in history and use that as the upper limit for our weighing scale? This may not be a great idea as the sensitivity of the scale would get reduced if the range is too large. At the same time, if we keep the upper limit too low, it may not be usable for a large percentage of the population!
Can someone solve this using Microsoft Excel and use Poisson
Airline passengers arrive randomly and independently at the passenger screening facility at a major international airport. The
-
What is the probability of no arrivals in a 1-minute period?
-
What is the probability of 3 or fewer arrivals in a 1-minute period?
-
What is the probability of no arrivals in a 15-second period?
-
What is the probability of at least 1 arrival in a 15-second period?
(1)
Obtain the probability of no arrivals in a 1-minute period.
The probability of no arrivals in a 1-minute period is obtained below as follows:
The required probability is,
Use Excel to obtain the probability value for x equals 0.
Follow the instruction to obtain the P-value:
- Open EXCEL
- Go to Formula bar.
- In formula bar enter the function as“=POISSON”
- Enter the value of x as 0.
- Enter the mean as 10.
- Enter the cumulative as false.
- Click enter.
EXCEL output:
From the Excel output, the P-value is 0.0000
The probability of no arrivals in a 1-minute period is 0.0000
Step by step
Solved in 4 steps with 4 images
