《全尺寸CPK自动计算表(30数值).xls》由会员分享，可在线阅读，更多相关《全尺寸CPK自动计算表(30数值).xls（77页珍藏版）》请在三一文库上搜索。
1、工工序序能能力力指指标标分分析析表表 名名称称安安装装板板P/NP/N 627834-01627834-01编编制制谢谢焱焱华华 尺尺寸寸编编号号070708080910101111 規規格格上上限限：111.15111.15109.15109.15104.65104.65103.80103.8078.6578.65 規規格格中中心心：111.00109.00104.50104.50103.50103.5078.5078.50 規規格格下下限限：110.85110.85108.85108.85104.35104.35103.20103.2078.3578.35 測測量量仪仪器器 投投影影仪仪投
2、投影影仪仪投投影影仪仪投投影影仪仪投投影影仪仪 管管理理项项目目1110.151110.151090.151090.15104.50.15104.50.15103.50.378.50.1578.50.15 1111.006108.989104.547103.55078.519 2111.024108.977104.513103.51378.487 3110.993108.959104.578103.43478.529 4111.017109.005104.525103.44878.490 5111.023109.018104.532103.54978.477 6110.928108.99110
3、4.488103.52378.545 7110.970109.036104.447103.55178.528 8110.973108.964104.476103.53278.581 9111.020108.967104.513103.62078.527 10110.945108.972104.458103.58578.526 11110.969109.022104.489103.44078.487 12111.003109.019104.491103.46178.512 13110.971108.978104.500103.55178.564 14111.014109.014104.51010
4、3.40678.534 15110.996109.061104.518103.48078.503 16111.003109.011104.517103.45678.501 17111.009108.977104.490103.57478.496 18110.960109.013104.499103.58178.506 19111.003108.971104.495103.54478.520 20111.011109.031104.467103.52178.503 21111.005108.976104.472103.48678.539 22111.021108.936104.518103.49
5、578.489 23110.989108.996104.532103.58178.513 24110.978108.990104.529103.51078.548 25110.991108.992104.512103.53178.556 26111.030109.038104.466103.61978.528 27111.065108.999104.504103.47578.523 28111.004108.970104.490103.48978.555 29110.947108.999104.520103.50078.489 30111.016109.004104.448103.47878.
6、517 31 32 33 34 35 統计值项目1110.151090.15104.50.15103.50.378.50.15 n 3030303030 Max111.0650109.061104.578103.6278.581 Min110.928108.936104.447103.40678.477 平均110.9961108.9958104.5015103.516178.5197 标准偏差0.0290 0.02740.02940.05470.0257 3 管理上限111.0833 109.0781104.5898103.680178.5968 3管理下限110.9090 108.9136
7、104.4132103.352178.4427 不良数0 0000 不良率0.0000% 0.0000%0.0000%0.0000%0.0000% 推测不良率0.0000% 0.0000%0.0000%0.0000% .0.0000% Cp1.7213 1.82421.69851.82921.9469 k0.0258 0.02780.00980.05370.1316 Cpk1 1. .6 67 76 69 9 1 1. .7 77 73 36 61 1. .6 68 81 19 91 1. .7 73 31 10 01 1. .6 69 90 07 7 cpk1.66 : 表明工序能力非常充分
8、，可摸索维持管理的方法。 1.33cpk1.66 : 表明工序能力属充分的水平。 1.00cpk1.33 :表明工序能力属普通水平，发生不良的可能性很大，需加強工序管理并摸索改善方法。 cpk1.0 : 表明工序能力不夠充分，常发生质量事故。所以有必要為工序的安定化和质量的改善不断努力。 0.17429110.9090.2108.9136 0.22104.41320.2103.35210.178.44269 0.0058096110.91480.4108.9191 0.38104.4190.4103.3630.278.44782 110.99323110.92060.6108.9246 0.6
9、4104.42490.6103.3740.378.45296 2.9%110.92641108.9301 1.03104.43081103.38490.578.4581 110.93221.5108.93551.6104.43671.5103.39580.878.46323 0.1644533263626040110.9382.3108.941 2.39104.44262.2103.40681.278.46837 0.0054818110.94383.2108.9465 3.43104.44853.2103.41771.778.47351 108.9931110.94974.5108.952
10、4.73104.45444.4103.42862.478.47864 2.7%110.95555.9108.9575 6.25104.46035.8103.43963.178.48378 110.96137.5108.9629 7.95104.46617.4103.4505478.48891 0.176628657806788110.96719.2108.9684 9.71104.4729103.46144.978.49405 0.0058876110.972911108.9739 11.4104.477911103.47245.778.49919 104.4985110.978712108.
11、9794 12.8104.483812103.48336.478.50432 2.9%110.984513108.9849 13.9104.489713103.4942778.50946 110.990314108.9904 14.5104.495613103.50527.378.5146 0.3280185654964500110.996114108.9958 14.5104.501513103.51617.378.51973 0.010934111.001913109.0013 13.9104.507413103.527778.52487 103.5106111.007812109.006
12、8 12.8104.513212103.5386.478.53001 5.5%111.013611109.0123 11.4104.519111103.54895.778.53514 111.01949.2109.0178 9.71104.5259103.55984.978.54028 0.154093925678580111.02527.5109.0232 7.95104.53097.4103.5708478.54542 0.0051365111.0315.9109.0287 6.25104.53685.8103.58173.178.55055 78.5172111.03684.5109.0
13、342 4.73104.54274.4103.59262.478.55569 2.6%111.04263.2109.0397 3.43104.54863.2103.60361.778.56083 111.04842.3109.0452 2.39104.55452.2103.61451.278.56596 111.05421.5109.05071.6104.56031.5103.62540.878.5711 111.061109.0561 1.03104.56621103.63640.578.57623 111.06580.6109.0616 0.64104.57210.6103.64730.3
14、78.58137 111.07170.4109.0671 0.38104.5780.4103.65820.278.58651 111.07750.2109.0726 0.22104.58390.2103.66920.178.59164 下限不良： 0.0000% 上限不良：0.0000% 下限不良： 0.0000% 上限不良：0.0000% 下限不良： 0.0000% 上限不良；0.0000% 下限不良： 0.0000% 上限不良：0.0000% 111.12111.07111.02110.97110.92110.87110.82 0 2 4 6 8 10 12 14 16 109.12109
15、.07109.02108.97108.92108.87108.82 0 5 10 15 20 104.62104.57104.52104.47104.42104.37104.32 0 5 10 15 103.75103.65103.55103.45103.35103.25103.15 0 2 4 6 8 78.6178.5678.5178.4678.4178.36 0 2 4 6 8 10 12 14 16 18 07 08 09 10 11 工工序序能能力力指指标标分分析析表表 下限不良； 0.0000% 上限不良：0.0000% R10.3 窜困埃拜0.002727 110.85110.8
16、527110.8555 y蔼4.39E-050.000070.000111 y蔼213.7234300 y蔼3000 R20.3 窜困埃拜0.002727 108.85108.8527108.8555 y蔼1.04E-051.75E-052.93E-05 y蔼214.5391600 y蔼3000 R30.3 窜困埃拜0.002727 104.35104.3527104.3555 y蔼2.42E-053.88E-056.16E-05 y蔼213.5394800 y蔼3000 R40.6 窜困埃拜0.005455 103.2103.2055103.2109 y蔼4.01E-077.11E-071.
17、25E-06 y蔼27.29722700 1.00cpk1.33 :表明工序能力属普通水平，发生不良的可能性很大，需加強工序管理并摸索改善方法。 cpk1.0 : 表明工序能力不夠充分，常发生质量事故。所以有必要為工序的安定化和质量的改善不断努力。 78.6178.5678.5178.4678.4178.36 0 2 4 6 8 10 12 14 16 18 y蔼3000 R50.3 窜困埃拜0.002727 78.3578.3527378.35545 y蔼5.09E-091.02E-082.03E-08 y蔼215.5288700 y蔼3000 00#REF! 00#REF! #REF!#R
18、EF!#REF! #REF!#REF!#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! #REF!#REF!#REF! #REF!#REF!#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! 00#REF! #REF!#REF!#REF! #REF!#REF!#REF! 00#REF! 00#REF! 0#REF!#REF! 0#REF!#REF! 0#R
19、EF!#REF! 0#REF!#REF! 0#REF!#REF! 0#REF!#REF! 0#REF!#REF! 0#REF!#REF! #REF!#REF!#REF! #REF!#REF!#REF! 0#REF!#REF! 0#REF!#REF! #REF!#REF!#REF! #REF!#REF!#REF! #REF!#REF!#REF! #REF!#REF!#REF! #REF!#REF!#REF! #REF!#REF!#REF! #REF!#REF!#REF! 眠沥阂樊荐00 眠沥阂樊啦5.297016-5.03079 0.23 0.41 0.68 1.1 1.71 2.55 3.66
20、 5.04 6.67 8.48 10.4 12.2 13.7 14.9 15.5 15.5 14.9 13.7 12.2 10.4 8.48 6.67 5.04 3.66 2.55 1.71 1.1 0.68 0.41 0.23 110.8582110.8609110.8636110.8664110.8691110.8718110.8745110.8773 0.0001740.000270.0004170.0006370.0009640.0014470.0021540.003177 00000000 00000000 108.8582108.8609108.8636108.8664108.86
21、91108.8718108.8745108.8773 4.85E-057.96E-050.0001290.0002080.0003310.0005220.0008140.001259 00000000 00000000 104.3582104.3609104.3636104.3664104.3691104.3718104.3745104.3773 9.72E-050.0001520.0002350.0003620.0005510.0008320.0012460.00185 00000000 00000000 103.2164103.2218103.2273103.2327103.2382103
22、.2436103.2491103.2545 2.17E-063.73E-066.34E-061.07E-051.78E-052.95E-054.82E-057.81E-05 00000000 00000000 78.3581878.3609178.3636478.3663678.3690978.3718278.3745578.37727 3.97E-087.7E-081.48E-072.8E-075.25E-079.73E-071.78E-063.23E-06 00000000 00000000 #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF!
23、 #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!
24、00#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#RE
25、F!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #RE
26、F!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!
27、#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! 000000 5.624696-5.320665.045614-5.14526 110.88110.8827110.8
28、855110.8882110.8909110.8936110.8964110.8991 0.0046440.006730.0096670.0137640.0194250.0271740.037680.051791 00000000 00000000 108.88108.8827108.8855108.8882108.8909108.8936108.8964108.8991 0.0019260.0029190.0043790.0065050.0095690.0139360.0200960.028693 00000000 00000000 104.38104.3827104.3855104.388
29、2104.3909104.3936104.3964104.3991 0.0027230.0039730.0057490.0082470.0117290.0165380.0231210.032048 00000000 00000000 103.26103.2655103.2709103.2764103.2818103.2873103.2927103.2982 0.0001250.0001990.0003130.0004870.000750.0011450.001730.002588 00000000 00000000 78.3878.3827378.3854578.3881878.3909178
30、.3936478.3963678.39909 5.8E-061.03E-050.0000183.12E-055.34E-059.05E-050.0001520.000251 00000000 00000000 #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#RE
31、F! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!0#
32、REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!0#REF!#REF!0
33、0#REF! #REF!#REF!0#REF!#REF!00#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00
34、#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!00#REF!#REF!00#REF! #REF!00#REF!#REF!00#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#RE
35、F!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! 000000 5.192999-5.781995.072231-6.60896 110.9018110.9045110.9073110.91110.9127110.9155110.9182110.9209 0.070560.0
36、952880.1275530.1692440.2225910.2901850.3749840.48031 00000000 00000000 108.9018108.9045108.9073108.91108.9127108.9155108.9182108.9209 0.0405660.0567850.0787070.1080170.146780.197490.2631010.347057 00000000 00000000 104.4018104.4045104.4073104.41104.4127104.4155104.4182104.4209 0.0440410.0600050.0810
37、570.1085590.1441510.1897750.2477040.320553 00000000 00000000 103.3036103.3091103.3145103.32103.3255103.3309103.3364103.3418 0.0038330.005620.0081590.0117280.0166920.023520.0328140.045327 00000000 00000000 78.4018278.4045578.4072778.4178.4127378.4154578.4181878.42091 0.0004110.0006650.0010650.0016870
38、.002640.0040860.0062540.009463 00000000 00000000 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
39、 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 110.9236110.9264110.9291110.9318110.9345110.9373110.94110.9427 0.6098210.7674590.9573691.1837921.4509181.7627152.122722.533816 00000000 00000000 108.9236108.9264108.9291108.9318108.9345108.9373108.94108.9427 0.4532930.5862150.7506460.9517291.194791.48
40、51491.8278832.227548 00000000 00000000 104.4236104.4264104.4291104.4318104.4345104.4373104.44104.4427 0.4112820.523180.6598350.8250731.0228721.2572541.5321351.851158 00000000 00000000 103.3473103.3527103.3582103.3636103.3691103.3745103.38103.3855 0.0619910.0839420.1125390.1493850.196330.2554720.3291
41、370.419842 00000000 00000000 78.4236478.4263678.4290978.4318278.4345578.4372778.4478.44273 0.014160.0209490.0306470.0443320.0634070.0896730.1253990.17339 00000000 00000000 110.9455110.9482110.9509110.9536110.9564110.9591110.9618110.9645 2.9979833.5160474.0874454.7099985.3797396.0907866.8352917.60347
42、9 00000000 00000000 108.9455108.9482108.9509108.9536108.9564108.9591108.9618108.9645 2.6878553.2113283.798954.4498215.1608555.9265356.7387627.586815 00000000 00000000 104.4455104.4482104.4509104.4536104.4564104.4591104.4618104.4645 2.2174952.6336263.1011173.6203834.1904774.8088895.4714026.171986 000
43、00000 00000000 103.3909103.3964103.4018103.4073103.4127103.4182103.4236103.4291 0.530240.6630350.8208741.0062211.2212011.4674311.7458432.056503 00000000 00000000 78.4454578.4481878.4509178.4536478.4563678.4590978.4618278.46455 0.2370610.3204770.4283870.566210.7399840.9562451.2218521.543728 00000000
44、00000000 110.9673110.97110.9727110.9755110.9782110.9809110.9836110.9864 8.3837699.1630049.92677210.6598211.3465411.9714912.5200212.97876 00000000 00000000 108.9673108.97108.9727108.9755108.9782108.9809108.9836108.9864 8.4574419.33509210.202311.0402311.8292712.5498313.1831113.71192 00000000 00000000
45、104.4673104.47104.4727104.4755104.4782104.4809104.4836104.4864 6.9027747.6541138.4146999.1718049.91159110.6195111.2807511.88075 00000000 00000000 103.4345103.44103.4455103.4509103.4564103.4618103.4673103.4727 2.3984472.7695423.1663753.5842124.0169994.457454.8972035.327047 00000000 00000000 78.467277
46、8.4778.4727378.4754578.4781878.4809178.4836478.48636 1.9285252.3822232.9096583.5140194.1963214.954915.7850286.67848 00000000 00000000 110.9891110.9918110.9945110.9973111111.0027111.0055111.0082 13.3362413.5832813.7134913.7234313.6128513.3846513.0447812.60196 00000000 00000000 108.9891108.9918108.994
47、5108.9973109109.0027109.0055109.0082 14.1214214.3998814.5391614.5351614.38814.1020213.6855413.15052 00000000 00000000 104.4891104.4918104.4945104.4973104.5104.5027104.5055104.5082 12.4057412.8432113.1824713.4150713.5350913.5394813.4281213.20386 00000000 00000000 103.4782103.4836103.4891103.4945103.5
48、103.5055103.5109103.5164 5.7372236.1177776.4589576.7516196.9876357.1602697.2644917.297227 00000000 00000000 78.4890978.4918278.4945578.4972778.578.5027378.5054578.50818 7.6234638.6045769.6030510.5972111.5631512.4756613.3092414.0393 00000000 00000000 111.0109111.0136111.0164111.0191111.0218111.024511
49、1.0273111.03 12.0673211.4539510.7763510.049849.2900638.5123537.7312956.960276 00000000 00000000 109.0109109.0136109.0164109.0191109.0218109.0245109.0273109.03 12.5119211.7870510.9947810.154729.2864398.4087367.5389766.692588 00000000 00000000 104.5109104.5136104.5164104.5191104.5218104.5245104.5273104.53 12.8723912.4419911.9232111.328410.671299.9663769.2284828.472192 00000000 00000000 103.5218103.5273103.5327103.5382103.5436103.5491103.5545103.56 7.2575047.1465026.9674926.7256816.4279556.0825575.6987075.2