Please provide the formulas using excel to answer the following questions:
A large retailer has purchased 10,000 DVDs. The retailer is assured by the supplier that the shipment contains no more than 1% defective DVDs (according to agreed specifications). To check the supplier's claim, the retailer randomly selects 100 DVDs and finds six of the 100 to be defective.
(A) Assuming the supplier's claim is true, compute the mean and the standard deviation of the number of defective DVDs in the sample.
(B) Based on your answer to (A), is it likely that as many as six DVDs would be found to be defective, if the claim is correct?
(C) Suppose that six DVDs are indeed found to be defective. Based on your answer to (A), what might be a reasonable inference about the manufacturer's claim for this shipment of 10,000 DVDs?