How do you calculate the probability of no more than 1 defective in a sample of 50 pieces from a lot with a 1% defect rate in Excel?
a. =BINOM.DIST(1,50,0.01,TRUE)
b. =BINOM.DIST(0,50,0.01,TRUE)
c. =BINOM.DIST(2,50,0.01,TRUE)
d. =BINOM.DIST(1,50,0.99,TRUE)