Please do the problem in Microsoft excel and show all the steps on how to do the

Question

Please do the problem in Microsoft excel and show all the steps on how to do the problem in Excel.

60. Let X denote the distance (m that an animal moves from its birth site to the first territorial vacancy it encounters Suppose that for banner-tailed kangaroo rats, X has an expo- nential distribution with parameter a 01386 (as sug- gested in the article "Competition and Dispersal from Multiple Nests," Ecology, 1997: 873-883). a. What is the probability that the distance is at most 100 m? At most 200 m? Between 100 and 200 m? b. What is the probability that distance exceeds the mean distance by more than 2 standard deviations? c. What is the value of the median distance?

Explanation / Answer

a) here probabilty that distance is at most 100 m P(X<100)=expon.dist(100,0.01386,true)=0.7499

P(X<200)=expon.dist(200,0.01386,true)=0.9375

P(100<X<200)=expon.dist(200,0.01386,true)-expon.dist(100,0.01386,true) =0.1875

b)here mean =1/0.01386=72.15

and std deviation =mean =72.15

hence mean +2*std deviation =72.15+2*72.15=216.45

hence P(X>216.45)=1-P(X<216.45)=1-expon.dist(216.45,0.01386,true)=0.0498

c) for median p=0.5

hence value of t=ln(2)/0.01386 =50.01

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---