Please solve using excel If a process mean is centered between the upper and low

Question

Please solve using excel

If a process mean is centered between the upper and lower specifications at a distance of six standard deviations from each, what is the probability of a product not meeting specifications? Using the result that 0.000001 equals one part per million, express the answer in parts per million. Assume that the process measurements can be modeled with a Normal distribution. Solve this problem using Excel so you can account for the necessary decimal places. (Note: A process is said to be of six-sigma quality if the process mean is at least six standard deviations from the nearest specification.)

Explanation / Answer

her from excel function norm.dist

prodcut not meeting specs =1-P(-6<Z<6)= 1-(norm.dist(6,0,1,true) - norm.dist(-6,0,1,true)) =1.973*10-9

for part per million 0.001973 part/ million

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects