18. The number of defects found in 25 samples of 100 Malossdientes Candy Company lemon drops taken on a daily basis from a production line over a five- week period is given in the worksheet Prob. 9-18.a. Compute dpmo and find the sigma level.b. Plot these data on a run chart. Can you identify any special causes? C. Explain what the Sigma Level means below: **Title: Understanding Sigma Value Calculations in Quality Control**---### Calculation of Sigma Value**Instructions:**1. Click the yellow cell, then click on “ƒx” button above. Select “Statistical” from the dialog drop-down. Scroll down to find statistical selections. Find and select “NORM.S.INV.” dialog box will open. Type in the following info: “Probability text box: .99865).” Click OK. (See explanation to the right)2. In the line level, type in the standard sigma shifts (.0845)3. Sigma Level [value] will auto-calculate. Explain what the Sigma Level means.---**Data Entry Table:**- **Number of Samples:** 25- **Sample Values:** - Sample Numbers: 1 to 25 - Defects: 6 (for samples 1-25) - Center: 5.98 (for samples 1-25)---### Explanation of Chart:**Chart Type:**- Line Chart**Data Represented:**- X-axis: Sample Numbers (1-25)- Y-axis: Defect Counts---**Chart Description:**- This chart compares the number of defects against the sample numbers.- The blue line represents the actual number of defects encountered.- The red line marks the center, which is a constant value of 5.98 across all sample numbers.- The line graph shows fluctuations in defect numbers around the center value, with some peaks and troughs indicating variations over the 25 samples.---**Instructions for Analysis:**- Analyze chart data; do not describe the chart.- Analyze and explain what the chart data reveals.- Incorporate analysis of data, and your response to the problem questions in the text, in a narrative format using the Report Template.---**Note:** The reason for using the equation is to identify the probability of finding a value between 1,000 and the distribution mean (0.99865 or 5.98).

Defects Per Million Opportunities is what DPMO stands for. It is a statistical indicator of process quality that counts the amount of errors that a process encounters out of every million chances. A procedure with a lower DPMO is of higher quality. It is computed by multiplying the number of defects by the number of opportunities for defects, and then multiplying the result by one million.Excel Calculations:Average or Center = 5.88No. of defects = 25Sample size = 100DPMO = Defects per million opportunities (DPMO) = (No. of defects/Sample size)*1,000,000 = (5.88/100) * 1,000,000 = 58,800Sigma level =NORMSINV(1-5.88/100)+1.5 = 3.06Run Chart:Part (A):DPMO = 58,800Sigma level = 3.06Part (B):The required chart is mentioned above.Samples 14 and 15 in the following chart are very far from the center, or 5.88, but other than that, the process appears to be stable with no unusual variation or special causes.Part (C):The number of standard deviations between the mean and the control limits is known as the Sigma Level in a control chart. It is a measure of how well the process is centered and the degree of variation present in the process. A process with a higher sigma level is more likely to generate goods or services that satisfy client requirements since a higher sigma level is correlated with a lower DPMO. A Six Sigma process, for instance, produces just 3.4 DPMO. A process with this high Sigma level is exceedingly capable, very efficient, and has very low error rates.