help with chapter Unit 3: Assignment

Run Chart

Problem 9-18
Malossdientes Candy Company		Calculation of Sigma Value
							1. Click the yellow cell, click on "fx" button above. Select "statistical" from category drop-down. Scroll down statistical selections. Find and select NORM.S.INV
			1	2
							2. NORM.S.INV dialog box will open. Type in the following into the "Probability" text box: (1-.0588). Click OK. (see explanation to the right)									The reason for the equation is we have to identify the probability of finding a value between 1.000 and the mean of the distribution (0.0588 or 5.88)
							3. In the blue cell, type in the standard sigma shift (p469)
							4. Sigma Level (value) will auto-calculate. Explain what the Sigma Level means below:
Run Chart
Number of VALUES (<= 30)			Enter number of samples
							Copy Defects column into the yellow cells below. Sample # matches row #
Sample	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25
Defects
Center	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
Sample	Defects	Center
							Chart will auto-populate and format
1	2	5.88
2	4	5.88
3	7	5.88
4	6	5.88
5	4	5.88
6	7	5.88
7	3	5.88
8	3	5.88
9	4	5.88
10	3	5.88
11	9	5.88
12	8	5.88
13	9	5.88
14	15	5.88
15	11	5.88
16	2	5.88
17	7	5.88
18	7	5.88
19	8	5.88
20	3	5.88					Explain what the chart is showing below:
21	7	5.88
22	1	5.88
23	4	5.88
24	5	5.88
25	8	5.88
Average	5.88

Defects Center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0