process and machine capability for more information look on the sheet "instruction"

i xi i xi i xi i xi values could be changed

1 19.85 51 101 151 values are calculated (button "Calculation") random sample chronical
2 21.56 52 102 152
25.00
3 18.22 53 103 153 part:
4 17.70 54 104 154 part number:
5 16.99 55 105 155 drawing:
6 17.83 56 106 156 inspector: 20.00
7 19.74 57 107 157 measuring device:
8 18.55 58 108 158 date:
9 18.52 59 109 159 attribute:
10 19.18 60 110 160 measuring unit: 15.00
11 20.72 61 111 161 nominal value = 18.50
12 18.77 62 112 162 lower spec. limit LSL = 15.00
13 19.61 63 113 163 upper specifications limit USL = 22.00
10.00
14 19.18 64 114 164
15 17.13 65 115 165 Cmk < 1.33 process not capable
16 18.70 66 116 166 Cmk between process limited capable
17 67 117 167 Cmk > 1.66 process capable 5.00
18 68 118 168
19 69 119 169 sample size 16
20 70 120 170 mid 18.89
21 71 121 171 standard deviation s 1.23 0.00
0 2 4 6 8 10 12 14 16 18
22 72 122 172 values are according Andersson not normal distributed
23 73 123 173 Darling test + 3 Sigma USL value mid LSL - 3 Sigma
24 74 124 174
25 75 125 175
26 76 126 176 Cmu 1.05 0 histogram probability plot
27 77 127 177 Cmo 0.84 not normal distributed
probability values 0.70 4
28 78 128 178 Cm 0.95 normal distributed
29 79 129 179 Cmk 0.84 0.60 3
30 80 130 180 evaluation Cmk => process not capable
31 81 131 181 0.50 2
32 82 132 182 median 18.74
33 83 133 183 range 4.57 0.40 1
34 84 134 184 minimum 16.99
35 85 135 185 maximum 21.56 0.30
0
14 15 16 17 18 19 20 21 22 23 24
36 86 136 186
0.20
37 87 137 187 calculated performance in ppm -1
38 88 138 188 pLSL 802 0.10
39 89 139 189 exceedance pUSL 5841 -2
40 90 140 190 p 6643 0.00
8.00 10.00 12.00 14.00 16.00 18.00 20.00 22.00 24.00 26.00 28.00 -3
41 91 141 191
42 92 142 192 observed performance in ppm + 3 Sigma USL valus
43 93 143 193 pLSL 0 normal distr, LSL - 3 Sigma -4

44 94 144 194 exceedance pUSL 0

45 95 145 195 p 0
46 96 146 196
47 97 147 197
48 98 148 198
49 99 149 199
50 100 150 200

© by sixsigmablackbelt.de
 for more information look on the sheet "instruction"

random sample chronical

25.00

20.00

15.00

10.00

5.00

0.00
0 2 4 6 8 10 12 14 16 18

+ 3 Sigma USL value mid LSL - 3 Sigma

probability plot
4

0
14 15 16 17 18 19 20 21 22 23 24

-1

-2

-3

-4

© by sixsigmablackbelt.de
For calculating the figures you have to install the "Sixsigmablackbelt-Analysis" add in
You can install it via Microsoft

After installing, go to the template sheet, change your values and just push the button "Ca
If you want to calculate more than 20 values, you can get
the full licence via our partner mycommerce.
ackbelt-Analysis" add in

and just push the button "Calculate"