CPK自动生成计算表格(中文版)

格式：xls
大小：121.50 KB
文档页数：1

下载文档原格式

全尺寸CPK自动计算表(30数值)

不不不不78.47778.519707 08 09 10 11k> 1.33 1.00 cp k<0.17429110.9090.2108.9140.2104.4130.2103.3520.178.44270.2 0.0058096110.91480.4108.9190.4104.4190.4103.3630.278.44780.4 #########110.92060.6108.9250.6104.4250.6103.3740.378.4530.72.9%110.92641108.931104.4311103.3850.578.4581 1.1110.9322 1.5108.936 1.6104.437 1.5103.3960.878.4632 1.7 #########110.938 2.3108.941 2.4104.443 2.2103.407 1.278.4684 2.6 0.0054818110.9438 3.2108.946 3.4104.448 3.2103.418 1.778.4735 3.7 108.9931110.9497 4.5108.952 4.7104.454 4.4103.429 2.478.478652.7%110.9555 5.9108.957 6.3104.46 5.8103.44 3.178.4838 6.7110.96137.5108.9637.9104.4667.4103.45478.48898.5 #########110.96719.2108.9689.7104.4729103.461 4.978.494110 0.0058876110.972911108.97411104.47811103.472 5.778.499212 104.4985110.978712108.97913104.48412103.483 6.478.5043142.9%110.984513108.98514104.4913103.494778.509515110.990314108.9914104.49613103.5057.378.514615 #########110.996114108.99614104.50113103.5167.378.519715 0.010934111.001913109.00114104.50713103.527778.524915 103.5106111.007812109.00713104.51312103.538 6.478.53145.5%111.013611109.01211104.51911103.549 5.778.535112111.01949.2109.0189.7104.5259103.56 4.978.540310 #########111.02527.5109.0237.9104.5317.4103.571478.54548.5 0.0051365111.031 5.9109.029 6.3104.537 5.8103.582 3.178.5506 6.778.5172111.0368 4.5109.034 4.7104.543 4.4103.593 2.478.555752.6%111.04263.2109.04 3.4104.549 3.2103.604 1.778.5608 3.7111.0484 2.3109.045 2.4104.554 2.2103.615 1.278.566 2.6111.0542 1.5109.051 1.6104.56 1.5103.6250.878.5711 1.7 111.061109.0561104.5661103.6360.578.5762 1.1 111.06580.6109.0620.6104.5720.6103.6470.378.58140.7111.07170.4109.0670.4104.5780.4103.6580.278.58650.4111.07750.2109.0730.2104.5840.2103.6690.178.59160.2R10.3窜困埃拜0.002727273110.85110.852*******.8554545 y蔼 4.38585E-057.00282E-050.000110832 y蔼213.7234313300 y蔼3000R20.3窜困埃拜0.002727273108.85108.852*******.8554545 y蔼 1.03683E-05 1.7518E-05 2.93062E-05 y蔼214.5391570600 y蔼3000R30.3窜困埃拜0.002727273104.35104.3527273104.3554545 y蔼 2.41721E-05 3.87676E-05 6.16448E-05 y蔼213.5394790600 y蔼3000R40.6窜困埃拜0.005454545103.2103.2054545103.2109091 y蔼 4.01444E-077.11216E-07 1.24754E-06 y蔼27.29722674900 y蔼3000R50.3窜困埃拜0.00272727378.3578.3527272778.35545455 y蔼 5.08924E-09 1.02094E-08 2.02513E-08 y蔼215.5288725300 y蔼300000#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!#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#REF!#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.297016095-5.03078825110.8581818110.8609091110.8636364110.8663636110.8690909110.8718182 0.000173870.0002703710.000416740.000636710.0009642510.001447473000000000000108.8581818108.8609091108.8636364108.8663636108.8690909108.8718182 4.8544E-057.9618E-050.0001292970.0002079040.0003310080.000521813000000000000104.3581818104.3609091104.3636364104.3663636104.3690909104.3718182 9.71844E-050.0001519040.0002354040.0003616860.0005509620.000832117000000000000103.2163636103.2218182103.2272727103.2327273103.2381818103.2436364 2.16663E-06 3.72555E-06 6.34269E-06 1.06914E-05 1.78431E-05 2.94838E-0500000000000078.3581818278.3609090978.3636363678.3663636478.3690909178.37181818 3.97198E-087.70306E-08 1.47714E-07 2.80081E-07 5.25107E-079.73451E-07000000000000#REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!00#REF!#REF!0#REF!00#REF!#REF!0 #REF!00#REF!#REF!0 #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!00#REF!#REF!0 #REF!00#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!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!00005.624696201-5.320658568110.8745455110.8772727110.88110.8827273110.8854545110.8881818 0.0021537850.0031766240.0046440930.0067298840.0096668710.013763721000000000000108.8745455108.8772727108.88108.8827273108.8854545108.88818180.00081450.0012588310.0019263880.0029189060.0043792190.00650539000000000000104.3745455104.3772727104.38104.3827273104.3854545104.3881818 0.0012460030.0018498080.0027227420.0039733680.0057488840.008246712000000000000103.2490909103.2545455103.26103.2654545103.2709091103.2763636 4.82363E-057.81342E-050.000125310.0001989780.0003128260.00048694200000000000078.3745454578.3772727378.3878.3827272778.3854545578.38818182 1.78436E-06 3.23411E-06 5.796E-06 1.02708E-05 1.79963E-05 3.11792E-050000000000000#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!0#REF!#REF!#REF!0#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!0#REF!#REF!00#REF!0#REF!#REF!00#REF!0#REF!#REF!00#REF!0#REF!#REF!00#REF!0#REF!#REF!00#REF!0#REF!#REF!00#REF!0#REF!#REF!00#REF!0#REF!#REF!00#REF!0#REF!#REF!00#REF!0#REF!#REF!00#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!0#REF!#REF!00#REF!0#REF!#REF!00#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!0000 5.045613838-5.145257917 5.192998748-5.7819898110.8909091110.8936364110.8963636110.8990909110.9018182110.9045455 0.0194248380.027*******.0376803910.0517907060.0705602130.095288294000000000000108.8909091108.8936364108.8963636108.8990909108.9018182108.9045455 0.0095686380.0139356420.020*******.028*******.0405656230.056785231000000000000104.3909091104.3936364104.3963636104.3990909104.4018182104.4045455 0.0117287180.016538370.023121040.0320475230.0440406830.060004813000000000000103.2818182103.2872727103.2927273103.2981818103.3036364103.3090909 0.0007504610.0011451330.0017300580.0025878670.0038326590.00561998400000000000078.3909090978.3936363678.3963636478.3990909178.4018181878.40454545 5.34133E-059.04766E-050.0001515390.0002509670.0004109710.000665438000000000000#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF!#REF!00#REF!#REF! #REF!00#REF!#REF! #REF!#REF!#REF!#REF!#REF! #REF!#REF!#REF!#REF!#REF! #REF!00#REF!#REF! #REF!00#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!00005.072231086-6.608956164110.9072727110.91110.9127273110.9154545110.9181818110.9209091 0.1275530480.1692441840.2225913510.2901846520.3749835470.480309976000000000000108.9072727108.91108.9127273108.9154545108.9181818108.9209091 0.0787068890.1080165220.1467802870.1974901190.2631013690.347057106000000000000104.4072727104.41104.4127273104.4154545104.4181818104.4209091 0.0810570130.1085594340.1441507840.1897749630.2477041530.320553207000000000000103.3145455103.32103.3254545103.3309091103.3363636103.3418182 0.0081591850.0117283050.0166916980.023*******.0328141690.04532700500000000000078.4072727378.4178.4127272778.4154545578.4181818278.42090909 0.0010653860.0016865860.0026400540.0040861990.006253580.009463253000000000000110.9236364110.9263636110.9290909110.9318182110.9345455110.9372727 0.6098213470.7674591340.957369343 1.183791982 1.450918082 1.762714644000000000000108.9236364108.9263636108.9290909108.9318182108.9345455108.9372727 0.4532928530.5862149630.7506457410.951728879 1.194789968 1.485148855000000000000104.4236364104.4263636104.4290909104.4318182104.4345455104.4372727 0.4112817410.523180080.6598351320.825072548 1.022872036 1.25725375000000000000103.3472727103.3527273103.3581818103.3636364103.3690909103.3745455 0.0619911110.0839418620.1125393920.1493851090.1963300760.25547190500000000000078.4236363678.4263636478.4290909178.4318181878.4345454578.43727273 0.0141597220.020*******.0306472010.0443315210.0634069660.089673438000000000000110.94110.9427273110.9454545110.9481818110.9509091110.9536364 2.122720202 2.533816234 2.99798252 3.516047223 4.087445011 4.709998487000000000000108.94108.9427273108.9454545108.9481818108.9509091108.9536364 1.827883444 2.227548206 2.687854902 3.211327712 3.798949592 4.449820907000000000000104.44104.4427273104.4454545104.4481818104.4509091104.4536364 1.53213502 1.8511585 2.21749494 2.633626209 3.101116626 3.620383104000000000000103.38103.3854545103.3909091103.3963636103.4018182103.4072727 0.3291366450.4198422230.5302403470.6630346280.820873872 1.0062211400000000000078.4478.4427272778.4454545578.4481818278.4509090978.45363636 0.1253987450.1733904120.2370606560.3204766590.4283865660.566210343000000000000110.9563636110.9590909110.9618182110.9645455110.9672727110.97 5.379739332 6.090785698 6.8352912797.603479068.3837689889.163003923000000000000108.9563636108.9590909108.9618182108.9645455108.9672727108.97 5.160854684 5.926534631 6.7387620227.5868152788.457441419.335091582000000000000104.4563636104.4590909104.4618182104.4645455104.4672727104.47 4.190476653 4.808889384 5.47140188 6.171985674 6.9027742337.654113453000000000000103.4127273103.4181818103.4236364103.4290909103.4345455103.44 1.221201206 1.467431354 1.74584284 2.056502683 2.398447394 2.76954162400000000000078.4563636478.4590909178.4618181878.4645454578.4672727378.47 0.7399839020.956245187 1.221852468 1.543728049 1.928525286 2.382222912000000000000110.9727273110.9754545110.9781818110.9809091110.9836364110.9863636 9.92677236210.6598200711.3465362811.9714941912.5200202912.97876375000000000000108.9727273108.9754545108.9781818108.9809091108.9836364108.9863636 10.2023041211.0402280711.8292693912.5498315513.183112813.71191578000000000000104.4727273104.4754545104.4781818104.4809091104.4836364104.4863636 8.4146990329.1718035749.9115909210.6195095311.2807510511.88075492000000000000103.4454545103.4509091103.4563636103.4618182103.4672727103.4727273 3.166375222 3.584211612 4.01699868 4.457450387 4.897203255 5.32704693600000000000078.4727272778.4754545578.4781818278.4809090978.4836363678.48636364 2.909658194 3.5140187 4.196320782 4.954910434 5.785027856 6.678479817000000000000。

中文CPK计算模板格式

下单边容差能力指数 (CPL)
19
20 能力指数 (Cp)
过程能力(Cpk)
能力比值 (CR)
均方差 (n-1)
均方差 (n)
方差 (n-1)
方差 (n)
性能指数 (PP)
性能比值 (PR)
性能指数 (Ppk)
子组数
直方图
15
16
17
18
19
20
30
27
25
日期
数值 80 45.000 0.000 55.000 4,112.600 51.408
51.125 1.300
T
3
51.8 51
50.9 51
51.175 0.900
E
4
50.8 50.2 51.8 50.7
50.875 1.600
S
5
6
7
8
9
10
11
12
5
50.3 50.9 51.1 50.7
50.750 0.800
6
50.5 51.5 52.7 50.5
51.300 2.200
7
15
频数
18 14
极差
2.225
3.000 2.000
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 20
1.000
0.000
1
2
3
4
UCLr
AveR
LCLr
Data Values
n 1 2 3 4 5 平均值极差

CPK控制图-自动生成原始数据计算CPK

0.000 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.000 0.000 0.000 0.000
0.000 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.000 0.000 0.000 0.000
0.000 0.000 0.000 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
组容7时没有极差下控制限樣本序列totalaveragex133cpkmin采取措施的说明不要对过程做不必要改变注明对过程因素人机料法环或ms所做的调整raver0000uclrd4r0000lclrd3rnote對特殊原因說明
MFG 零件名称
Work Station 机器编号
品質特性規格值
公差上限公差下限
0.000 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.000 0.000 0.000 0.000
0.000 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.000 0.000 0.000 0.000
0.000 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.000 0.000 0.000 0.000
0.000 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.000 0.000 0.000 0.000
0.000 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.000 0.000 0.000 0.000

CPK计算表格EXCEL(1)

数据收集区公式区1002110010034100251002510040输入上限值1004输入上限值100输入下限值10021002610034100281002810000输入下限值100210028100271001710017usllsl210021001910018100321002310023usllsl041002610021100191003210015na100231001910022100271002210022stdev00610014100271003110031003最大值max100341002310027100331002610026最小值min100101001910024100291002810016ppku0911002410031100341003210032ppkl12810015100211002110021002ppkmincpkucpkl09110021003100211002510025average10023average100231001810023100291003210032usllsl110stdev006stdev006100131002100181002210022xut2017最大值max10034最小值min100001002110028100291003210019ppkcpca091ppkuslx091ppk12810014100171003100251002510015100231003210031100311001110015100251002210022100211003100311003110031100110015100210018100181001810024100210028100281001100171002410019100191002110021002710025100251002100210032100241002410021002100321002410024ppk自动计算表公差上限usl公差上限usl公差下限usl公差下限lsl规格中心平均值标准差平均值cp离散趋势精确度标准差ca集中趋势精确度cpk计算表格左则为数据区域可以根据需要任意增减

CPK值计算表格201810A

Prepared By作成/日期：The Temperatur e of Upper Plate Left running at240VAC 50HzBuzzel NoiseLevel Power Consumptio n Motor SpeedUnder No-loading,High Setting °CdB WattR.P.MAglient34970ADataAcquisition /Switch UnitTES Noise Level Meter YOKOGAWA WT310Interlligent Electrical Parameter TesterSHIMPO PH-200LCSpeedTester17575300180001903151980016075270172003230303020000169.68888.967290.73318143.333181913051820023862871760015851860028.50860.7184 4.4484147.81940.240.00 1.82 3.740.000.000.000.000.000.000.000.000.000.000.11 6.48 1.55 2.130.000.000.000.000.000.000.000.000.000.000.180.00 1.69 2.930.000.000.000.000.000.000.000.000.000.00CA -0.350.00-0.410.110.000.000.000.000.000.000.000.000.000.000.11 6.48 1.55 2.130.000.000.000.000.000.000.000.000.000.00No.1176.0089.00289.0018100.00No.2175.0089.00289.0018200.00No.3180.0089.00289.0018200.00No.4179.0089.00289.0017900.00No.5176.0089.00289.0018200.00No.6180.0091.00293.0018200.00No.7177.0089.00301.0018200.00No.8170.0089.00289.0017600.00No.9178.0089.00305.0017700.00No.10173.0089.00289.0018200.00No.11178.0090.00289.0018200.00No.12172.0089.00289.0018100.00No.13172.0086.00289.0018100.00No.14174.0088.00289.0018200.00No.15176.0089.00289.0018200.00No.16176.0089.00289.0018200.00No.17171.0089.00289.0018200.00The actuial value of product features 實測值記錄binghwaloo Product Name 產品名稱Rating of product產品規格240VAC,50Hz 120VAC,60HzCustomer客戶Checked By审核/日期：Approved By批准/日期：Sigma X-BarCPKCP Product features 產品特性/項目The unit of features 特性單位Auto Bread MakerModel產品型號807Remark 備註資訊Pls refer to test reportPls refer to test reportTest or Measurementmethod and condition 測試方法&環境參數Test or measurement instrument測試儀器品牌&型號SL規格值USL規格上限CPU CPL LSL規格下限Samples size 量測樣品數量Nonconformingquantity NG品數量X-Max X-min Range PROM CHN LLC CPK 統計表備註：A++級 Cpk≥2.0 特優可考慮成本的降低；A+ 級 2.0 ＞ Cpk ≥ 1.67 優應當保持之；A 級 1.67 ＞ Cpk ≥ 1.33 良能力良好，狀態穩定，但應盡力提升為A ＋級；B 級 1.33 ＞ Cpk ≥ 1.0 一般狀態一般，制程因素稍有變異即有產生不良的危險，應利用各種資源及方法將其提升為 A 級；C 級 1.0 ＞ Cpk ≥ 0.67 差制程不良較多，必須提升其能力；D 級 0.67 ＞ Cpk 不可接受其能力太差，應考慮重新整改設計制程。

cpk表格模板

CPK（过程能力指数）表格模板1. 背景介绍CPK（过程能力指数）是一种常用的统计工具，用来评估一个过程的稳定性和能力。

它可以帮助人们判断一个过程是否达到了规定的要求，并提供相应的数值指标。

CPK值越高，说明过程的稳定性和能力越强。

2. CPK指数的计算CPK指数主要通过计算过程的标准差和规格限制来得出。

它可以将过程的数据分布情况和规格限制进行对比，从而评估过程的能力。

CPK的计算公式如下：CPK = min((USL - μ) / (3 * σ), (μ - LSL) / (3 * σ))其中： - USL为上限规格限制 - LSL为下限规格限制 - μ为过程的平均值 - σ为过程的标准差3. CPK表格模板下面是一个简单的CPK表格模板，供您参考和使用。

序号数据点规格限制均值标准差CPK1 32 30-35 33 1.2 0.832 30 30-35 33 1.2 0.833 35 30-35 33 1.2 0.834 35 30-35 33 1.2 0.835 33 30-35 33 1.2 0.836 31 30-35 33 1.2 0.837 32 30-35 33 1.2 0.838 32 30-35 33 1.2 0.839 34 30-35 33 1.2 0.8310 31 30-35 33 1.2 0.83在表格中，每一行代表一个数据点，包括数据点的序号、实际数据、规格限制范围、过程的平均值、过程的标准差以及计算得到的CPK值。

4. 如何使用CPK表格模板使用CPK表格模板需要按照以下步骤进行：步骤一：收集数据首先，收集您需要评估的过程的数据。

具体数据的收集方式会根据不同的过程而有所不同。

步骤二：计算均值和标准差使用收集到的数据，计算过程的平均值和标准差。

步骤三：确定规格限制确定过程的规格限制，即上限规格限制（USL）和下限规格限制（LSL）。

步骤四：填写表格根据收集到的数据和计算结果，填写CPK表格中的相应栏目。

Cpk-Ppk-Cmk自动分析表

PPM
批准：
14.00 12.00
10.00
8.00 6.00 4.00 2.00 0.00 18
极差图
0.024 0.022 0.02 0.018 0.016 0.014 0.012 0.01 0.008 0.006 0.004 0.002 0 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
18.0046
90.044
18.0088
18.005 18.011 18.0118 18.0052 18.0064
90.05 18.01
90.044 90.039
90.04
90.039
18.0078
90.027 90.037
90.04 90.036 90.039 90.034
90.043
18.0086
0.022 18.0138 0.0051
UCLX=X+A2*R= σ =R/D2=
σ s=(∑(Xi-X)^2/(n-1))1/2=
0
18.015 18.014 18.013 18.012 18.011 18.01 18.009 18.008 18.007 18.006 18.005 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
2 3 3.27 2.57 * * 1.88 1.02 1.13 1.69
4 5 2.28 2.11 * * 0.73 0.58 2.06 2.33
PR= Pp= Ppk= Cm= Cmk= CR= Cp= Cpk= 估计失效分析：批准：

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

#DIV/0! #DIV/0! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #DIV/0!
#DIV/0! #VALUE! #DIV/0!
0.000 0.000 #DIV/0! #DIV/0!
#DIV/0! #REF! #REF! #DIV/0! #VALUE! #DIV/0!
#DIV/0! #DIV/0! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #DIV/0!
#DIV/0! #VALUE! #DIV/0!
A 0.0000% 0.0000% 0.0000%
4.520 4.530 4.540 4.520 4.520 4.530 4.520 4.540 4.530 4.520 4.530 4.530 4.520 4.530 4.520 4.550 4.520 4.530 4.540 4.530 4.520 4.530 4.520 4.530 4.520 4.530 4.520 4.530 4.530 4.520 4.530 4.520
工序能力评估报告
零件编号:
数据来源:
测量日期:
1
2
3
4
5
6
20.4±0.1 20.500 20.40 20.300 20.500 20.300 20.380 0.0462 -0.20 0.72 0.58
D 4.2195% 0.4586% 4.6781%
20.320 20.330 20.310 20.300 20.350 20.340 20.350 20.330 20.380 20.400 20.350 20.340 20.330 20.400 20.500 20.420 20.410 20.430 20.440 20.400 20.410 20.430 20.380 20.350 20.410 20.420 20.390 20.350 20.390 20.340 20.420 20.430
恒涌电子规格值 USL µ LSL MAX MIN AVG STD Ca Cp Cpk Grade DRL%
DRR% DR%
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 26 27 28 29 30 31 32 AVG STD GRAD A GRAD B1 GRAD B2 GRAD C1 GRAD C2 GRAD D Grade Z1 Z2 DRL% DRR% DR% 备注:
#DIV/0! #DIV/0! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #DIV/0!
#DIV/0! #VALUE! #DIV/0!
测量人:
8
0.000 0.000 #DIV/0! #DIV/0!
#DIV/0! #REF! #REF! #DIV/0! #VALUE! #DIV/0!
#DIV/0! #DIV/0! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #DIV/0!
#DIV/0! #VALUE! #DIV/0!
0.000 0.000 #DIV/0! #DIV/0!
#DIV/0! #REF! #REF! #DIV/0! #VALUE! #DIV/0!
4.5272 0.008
1.00 1.00 2.00 2.00 3.00 4.00 A 16.478 9.433 0.0000% 0.0000% 0.0000%
0.000 0.000 #DIV/0! #DIV/0!
#DIV/0! #REF! #REF! #DIV/0! #VALUE! #DIV/0!
#DIV/0! #DIV/0! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #DIV/0!
#DIV/0! #VALUE! #DIV/0!
制作人:
检查员:
确认人:
7
0.000 0.000 #DIV/0! #DIV/0!
#DIV/0! #REF! #REF! #DIV/0! #VALUE! #DIV/0!
#DIV/0! #DIV/0! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #DIV/0!
#DIV/0! #VALUE! #DIV/0!
0.000 0.000 #DIV/0! #DIV/0!
#DIV/0! #REF! #REF! #DIV/0! #VALUE! #DIV/0!
20.3797 0.046 2.000 2.000 3.000 3.000 4.000 3.000
D 1.726 2.606 4.2195% 0.4586% 4.6781%
4.5±0.1 4.600 4.50 4.400 4.550 4.520 4.527 0.0077 0.27 4.32 3.14