Question

23. Find the following regarding excel functions:

a.

A new surgical procedure is said to be successful 90% of the time. Suppose the procedure is performed five times. Assume that the results of each procedure are independent of one another. In this binomial distribution application, which Excel statement will find the probability of exactly 2 successful surgical procedures?

		=BINOMDIST(2,5,90%,TRUE)
		=BINOMDIST(2,5,90%,FALSE)
		=1-BINOMDIST(2,5,90%,TRUE)
		=1-BINOMDIST(2,5,90%,FALSE) b. A new surgical procedure is said to be successful 90% of the time. Suppose the procedure is performed five times. Assume that the results of each procedure are independent of one another. In this binomial distribution application, which Excel statement will find the probability of 2 or fewer successful surgical procedures? =1-BINOMDIST(2,5,90%,TRUE) =BINOMDIST(2,5,10%,FALSE) =BINOMDIST(2,5,90%,TRUE) =1-BINOMDIST(2,5,10%,FALSE) c. It is known that 10% of the customers in an electronics store purchase an MP3 player. A random sample of 30 customers is selected. Assume that the customers’ purchases are made independently. In this binomial distribution application, which Excel statement will find the probability of more than 10 customers who purchase an MP3 player in this electronics store? =1- BINOMDIST(10,30,10%,TRUE) =1-BINOMDIST(10,30,10%,FALSE) =BINOMDIST(10,30,10%,TRUE) =BINOMDIST(10,30,10%,FALSE) d. It is known that 10% of the customers in an electronics store purchase an MP3 player. A random sample of 30 customers is selected. Assume that the customers’ purchases are made independently. In this binomial distribution application, which Excel statement will find the probability of between 10 and 20 customers, inclusively, who purchase an MP3 player in this electronics store? =1-BINOMDIST(10,30,10%,TRUE) =1-BINOMDIST(10,20,10%,FALSE) =BINOMDIST(20,30,10%,FALSE)-BINOMDIST(10,30,10%,FALSE) =BINOMDIST(20,30,10%,TRUE)-BINOMDIST(9,30,10%,TRUE)

Answer 1

a) n = 5

p = 90%

Option-B) BINOMDIST(2,5,90%,FALSE)

b) Option-C) BINOMDIST(2,5,90%,TRUE)

c) Option-A) 1- BINOMDIST(10,30,10%,TRUE)

d) Option-D) BINOMDIST(20,30,10%,TRUE)-BINOMDIST(9,30,10%,TRUE)