How to 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) Use the PROB function.
b) Employ the BINOM.DIST function.
c) Utilize the POISSON.DIST function.
d) Implement the NORMAL.DIST function.