Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

********if you are not going to read the question, please do NOT answer**** ***I

ID: 3067845 • Letter: #

Question

********if you are not going to read the question, please do NOT answer****
***I have asked this question twice already and the correct numbers were totally ignored**
I need help understanding how the answer is found also. I am confused where z* is found.

It is 1 out of 2,500,000!!! NOT 250,000


Question:
If a company allows a maximum part failure rate of 1 out of 2,500,000 parts. To insure this
quality goal, failed parts must be how many standard deviations away from the mean? (Use
Excel to calculate the answer and give the Excel formula you used.)

Explanation / Answer

here probability of failure p=1/2500000=0.0000004

threfore corresponding one tailed probability =1-0.0000004/2=0.9999998

from normal distribution

corresponding to 99.99998 percentile crtiical z =normsinv(0.9999998)=5.069

hence failed parts must be 5.069 standard deviation from mean

( please revert for any clariication required)