ZuoTi.Pro
Question

IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE Suppose the number of customers arriving each hour at the only checkout counter in a local pharmacy is approxima hour. a. Find the probability that exactly 10 customers arrive in a given hour. b. Find the probability that at least five customers arrive in a given hour 1) tely Poisson distributed with an expected arrival rate of 20 customers per c. Find the probability that no more than 25 customers arrive in a given hou. d. Find the probability that between 10 and 30 customers (inclusive) arrive in a given hour. (Ctrl)
math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Let X is a random variable shows the number of customers arrive per hour. Here X has Poisson distribution with parameter lambda=20 .

The pdf of X is

e P(X =x) = al--,x = 0, 1 , 2, 3

(a)

The probability that exactly 10 customers arrive in a given hour is

20 10!0.00582

(b)

e-20201 = 1.00000

(c)

25. e-20 201 = 0.88782

(d)

30 20 201 - , e P(10 X 30) ー0.981529906 10

0 0
Add a comment
Know the answer?
Add Answer to:
IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE Suppose the number...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • N AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE Use Excel function...

    N AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE Use Excel function and write down the Poisson Distribution (with mean = 5.5) in a Table and plot the chart. 1) (Ctrl)" |

  • IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE The annual number...

    IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE The annual number of industrial accidents occurring in a manufacturing plant is known to follow a Poisson distribution with mean 12. a. What is the probability of observing of observing exactly 12 accidents during the coming year? b. What is the probability of observing no more than 12 accidents during the coming year? c. What is the probability of observing at least 15 accidents during the coming...

  • UsePoissonsheet to answer this question. Suppose that X, the number of customers arriving each ...

    UsePoissonsheet to answer this question. Suppose that X, the number of customers arriving each hour at the only checkout counter in a local pharmacy, is approximately Poisson distributed with mean = 20 customers per hour. Find the probability that Xis more than 24. Round your answer to 4 decimal places. Put a box around your answer.  

  • IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE 1) buring the...

    IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE 1) buring the period of time that a local university takes phone-in registrations, calls come in at the rate of one every two minutes a. Clearly state what the random variable in this problem is? b. What is an appropriate distribution to be used for this problem and why? c. What is the expected number of calls in one hour? d. What is the probability of receiving...

  • IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE 1) In a...

    IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE 1) In a typical month, an insurance agent presents life insurance plans to 40 potential Historically, one in four such customers chooses to buy life insurance from this agent. You may treat this as a binomial experiment. a. What is the probability of success for this problem? b. What is the total number of trials in this problem? c. Create a probability distributio n table which includes...

  • The number of customers arriving at a local business every 15 minutes is 3.  Supposing the arrival...

    The number of customers arriving at a local business every 15 minutes is 3.  Supposing the arrival of customers follows a Poisson distribution, answer the following questions: What is the probability that exactly 5 people arrive in the next 15 minutes? What is the probability that at least 4 people arrive in the next 15 minutes? Probability that between 2 and 6 people arrive inclusive? Expected number to arrive in the next hour? Expected number to arrive in an 8 hour...

  • Customer arrivals at a checkout counter in a department store have a Poisson distribution with an...

    Customer arrivals at a checkout counter in a department store have a Poisson distribution with an average of seven per hour. For a given hour, find the probability that a. exactly nine customers arrive b. no more than three customers arrive c. at least two customers arrive

  • the number of customers that arrive to a clinic is poisson distributed with 10 per hour....

    the number of customers that arrive to a clinic is poisson distributed with 10 per hour. there have been no arrival for the past 45 minutes. find the probability that the time to the next arrival exceeds 2 minutes. show all work demonstrating the memoryless property of the exponential

  • Mixed Poisson/exponential (draw pictures where appropriate and show formulas with numbers plugged...

    Mixed Poisson/exponential (draw pictures where appropriate and show formulas with numbers plugged in as well as answers.) Customers arrive at the drive-up window of a fast-food restaurant at a rate of 2 per minute during the lunch hour (noon-1pm). What is the probability that exactly 3 customers will arrive in 1 minute? What is the probability that at least 1 customer will arrive in 5 minutes? What is the probability that no customers will arrive in 2 minutes? Given a...

  • IN A EXCEL FILE USING EXCEL FORMULAS AND CALCULATIONS MUST SHOE FORMULAS IN CELL! SHOW THE STEPS ...

    IN A EXCEL FILE USING EXCEL FORMULAS AND CALCULATIONS MUST SHOE FORMULAS IN CELL! SHOW THE STEPS IN SOLUTION APPROACH. Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT