A supplier contract calls for a key dimension of a part to be between 1.96 and 2.04 centimetres. The supplier has determined that the standard deviation of its process, which is normally distributed, is .04 centimetre. Use excels formulas.
A) if the actual mean of the process is 1.98, what fraction of parts will meet specifications?
B) if the mean is adjusted to 2.00, what fraction of parts will meet specifications?
C) How small must the standard deviation be to ensure that no more than 2% of parts are nonconforming, assuming the mean is 2.00?