A computer manufacturer claims that at most 2% of the products shipped are defective. A store receives shipments of 40 computers.

(a) Assuming the worst case scenario, what fraction of shipments to the store will have at least one defective computer?

(b) Using Excel's random number generation, simulate making 1000 shipments of 40 computers from the manufacturer described in (a), assuming that there are 2% defectives in each shipment. What fraction of the 1000 shipments contain at least one defective computer? How does this number compare with the probability you computed in (a)?