nighthawk airlines measured their numbers of lost bags in one month and found that they had lost 25 bags for…

nighthawk airlines measured their numbers of lost bags in one month and found that they had lost 25 bags for 10,000 customers. if the average number of bags per customer is 1.8, use the six sigma excel template to find at what sigma level is the airline operating. do not round intermediate calculations. round your answer to two decimal places.

nighthawk airlines measured their numbers of lost bags in one month and found that they had lost 25 bags for 10,000 customers. if the average number of bags per customer is 1.8, use the six sigma excel template to find at what sigma level is the airline operating. do not round intermediate calculations. round your answer to two decimal places.

Answer

Explanation:

Step1: Calculate the number of opportunities

The number of opportunities is the number of bags (since each bag can be lost). Given 10,000 customers and an average of 1.8 bags per customer, the number of opportunities $n$ is $n = 10000\times1.8=18000$.

Step2: Calculate the defect - rate

The number of defects (lost bags) is 25. The defect - rate $p$ is $p=\frac{25}{18000}\approx0.001389$.

Step3: Use the Z - score formula for Six Sigma

The formula to find the Z - score (sigma level) from the defect - rate in a non - centered process (the basic Six Sigma relationship) is $Z = NORMSINV(1 - p)$. In Excel, if $p$ is in cell A1, we can use the formula =NORMSINV(1 - A1). $Z = NORMSINV(1 - 0.001389)$ $Z\approx2.91$

Answer:

2.91