Using Excel to calculate binomial probabilities: Suppose (as is roughly true) ab

Question

Using Excel to calculate binomial probabilities: Suppose (as is roughly true) about 30% of all adult Internet users hare posted videos online. A sample survey interviews an SRS of 1555 Internet users. What is the actual distribution of the number of people in the sample who have posted videos online? Use the excel function "BINOMDIST" to find the exact probability that 450 or fewer of the people in the sample have posted videos online. Use the excel function "BINOMDIST" to find the exact probability that more than 727 (about half) of the people in the sample have posted videos online. Use the excel function "BINOMDIST" to find the exact probability that between 1000 and 1100 of the people in the sample have posted videos online. Using Excel to construct 5 confidence intervals:

Explanation / Answer

(a)

Let X is a random variable shows the number of users posted videos online. Here X has binomial distribution with parameter n=1555 and p=0.30.

(b)

Write the excel function : =BINOMDIST(450,1555,0.30,true)

Answer is: 0.1882

(c)

Write the excel function :

=1-BINOMDIST(727,1555,0.3,TRUE)

Answer is : 0.0000

(d)

Write the excel function:

=BINOMDIST(1100,1555,0.3,TRUE)-BINOMDIST(1000,1555,0.3,TRUE)

Answer is: 0.0000

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.