Here is the link to \"Binomial probability table.xlsx\" https://drive.google.com

Question

Here is the link to "Binomial probability table.xlsx"

https://drive.google.com/file/d/0B6vqkj-k2RxOUGcxYW01bkwyQ2M/view

Please explain how you got answer or send back completed document. Thank you.

Problem 6 A survey found that 50% of the investors has erchange-traded funds in his/her portfolio. Consider a sample of 5 investors. a. Use the template in Binomial probability table-rlsa to compute the probability distribution, erpected value and variance using Ercel. b. Make a probability distribution plot using Ercel. c. What is the probability that two of them have erchanged-traded funds in their portfolio. d. If 90% of the investors has eac funds in his/her portfolio, compute the probability hanged-traded distribution, erpected value and variance using Ercel. Compare the results with a. e. Compute the probability distribution in c using Ercel.

Explanation / Answer

a. here n=5 and p=0.50

mean=np=2.5 and sd=1.12

b. P(x)=ncxp^x(1-p)^n-x

c. P(x=2)=0.3215

d. now p=0.90 so mean=np=4.5 and sd=0.67

P(x)=0.0081

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---