Relationship between the poisson and exponential

Assignment Help Basic Statistics
Reference no: EM131887185

Can someone tell me how to get the correct answer to this statistics question using excel formula.

The question is: Recalling the relationship between the Poisson and exponential distributions, find the probability that the time between two successive customer arrivals is more than four minutes. The poisson distribution has an expected arrival rate of 20 customers per hour.

Using that i set up this formula in excel:

More than four minutes = 1- EXP.Dist(4,20,true) --- answer is 1

Two minutes= EXP.Dist(2,20,true)----answer is 0

The problem is I am not getting the correct values. I know the correct values. I am just not sure how to get that answer in excel.

The correct values should be:

More than four minutes = 0.26

Two minutes = 0.49

Can someone explain what i am doing wrong as far as setting up the equation in excel.

Reference no: EM131887185

Questions Cloud

State of rhode island disintegrated : In February 2002, a piece of ice sheet biger than the state of Rhode island disintegrated in 30 days. This ice sheet
What is the current yield-calculate yield to call : Calculate the yield to maturity. What is the current yield. Calculate Yield to Call.
Explain what are the challenge that you will face as a nurse : Summary that includes:How are the domains connected? What is your vision of nursing for the future? What are the challenges that you will face as a nurse?
Create a training course to highlight the important elements : Create a one-day training course that highlights the important elements of what you have just learned within the past ten (10) weeks.
Relationship between the poisson and exponential : Recalling the relationship between the Poisson and exponential distributions, find the probability that the time between two successive customer arrivals
Difference between apple common and preferred stocks : Why must Risk be balanced with Return? What is the difference between Apple common and preferred stocks?
First four years in the bond amortization schedule : Find the total amount for accumulation of discount during the first four years in the bond amortization schedule.
Describe the strategy for implementing health promotion plan : Describe the strategy for implementing the health promotion plan. Explain how you will monitor and evaluate the plan for quality improvement.
Receivable by buying foreign currency option : Further assume that management of the company decides to hedge against foreign currency risk regarding accounts receivable by buying foreign currency option.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd