(Answered) Can someone tell me how to get the correct answer to this

Statistics

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.

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M92715532
Price:- $20

Verified Expert

Priced at $40 Now at $20, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Statistics and Probability

Why has libor played such a central role in international

Why has LIBOR played such a central role in international business and financial contracts? Why has this been questioned in recent debates over its value reported?

A population has a mean mu79 and anbspstandard deviation

A population has a mean μ=79 and a standard deviation σ=24. Find the mean and standard deviation of a sampling distribution of sample means with sample size n=248 μx= ?Simplify your? answer. σx= rounded to three decimal ...

Suppose a researcher is interested in the number of good

Suppose a researcher is interested in the number of good versus bad dreams that students have during final exam week. The researcher states that p = 0.52 that a student will have a bad dream during final exam week. (a) ...

Assumes the following probability pcustomer make a purchase

Assumes the following probability" P(customer make a purchase) = 0.300 P(Customer does not make a purchase) = 1-0.300 Compute the P(1purchase) and enter your answer in 3 decimal places.

An insurance company is selling a perpetuity contract that

An insurance company is selling a perpetuity contract that pays $2,00 monthly. The contract currently sells for $100,000. (a) What is the monthly return on this investment vehicle? (b) if instead the amount of monthly in ...

1 a certain compact disc player randomly plays each of 10

1. A certain compact disc player randomly plays each of 10 songs on a CD. Once a song is played, it is not repeated until all the songs on the CD have been played. In how many different ways can the CD player play the 10 ...

Find the modified internal rate of return mirr the annual

Find the modified internal rate of return (MIRR) The annual rate is 8.24%. Initial outlay is $356,800. Year 1: $163,100 Year 2: $173,100 Year 3: $181,300 Year 4: $175,700 Year 5: $161,400

A firm requires an investment of 18000 and will return

A firm requires an investment of $18,000 and will return $26,000 after one year. If the firm borrows $10,000 at 8% what is the return on levered equity?

A sales table at anthonys department store contains a pile

A sales table at Anthony's Department Store contains a pile of sweaters, 19 medium size and 20 small size. A sweater is selected at random. Find the probability that it is a small size. Round your percentage to the tenth ...

1i which of the following characterizes a market ordera a

1) i. Which of the following characterizes a market order? a) A market order, which is considered a small order, is when 100 shares of a stock are ordered b) A market order is when the investor specifies the maximum pric ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert