一汽大众集团SPC控制图表.xls

上传人：仙人指路1688

文档编号：2981778

上传时间：2023-03-07

格式：XLS

页数：26

大小：883KB

《一汽大众集团SPC控制图表.xls》由会员分享，可在线阅读，更多相关《一汽大众集团SPC控制图表.xls（26页珍藏版）》请在三一办公上搜索。

1、 X R 控控制制图图控制图编号：产品件号规格标准每组大小控制 X 图R图制造部门期间产品名称上限 USL上限 UCL0.00控制项目中心限CL总组数中心限CL0.00机组抽样方法随机测量单位下限 LSL下限 LCL0.00测量者日期4月20日日期/时间合计批号12345678910111213141516171819202122232425样本测计量数值的判定条件定 USL 蓝色值 USL 蓝色 USL 蓝色值 USL 蓝色值 USL 蓝色值 USL 蓝色 LSL 红色平均0.00預估不良率(PPM)#VALUE!製程能力分析P 控控制制图图控制图编号：产品名称部

2、门上限 UCL#VALUE!中心限 CL下限 LCL#VALUE!子組数26样本上限704过程名称机组纪录者日期P0.00%样本容量 n563样本下限423日期1234567891011121314151617181920212223242526合计备注检查数量500 450 500 650 500 550 500 650 500 500 700 500 500 650 500 700 500 650 500 600 500 700 500 700 500 65014650不良內容及数量00000000总不良数000000000000000000000000000不良率%#VALU

3、E!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!P控制图备注及原因跟踪:12345678910111213141516171819202122232425260.0%10.0%20.0%30.0%40.0%50.0%60.0%70.0%80.0%90.0%100.0%nP 控控制制图图控制

4、图编号：产品名称部门上限 UCL0.00中心限 CL0.00下限 LCL0.00子組数26样本上限188过程名称机组纪录者日期nP0.00本容量 n150样本下限113日期1234567891011121314151617181920212223242526合計备注检查数量150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 1503900不良內容及数量00000000总不良数000000000000000000000000000不良率

5、%#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!P控制图备注及原因跟踪:12345678910111213141516171819202122232425260 0 0 0 0 1 1 1 1 1 1 C 控控制制图图控制图编号：产品名称部门上限 UCL0.00中心限 CL

6、0.00下限 LCL0.00子組数26样本上限3过程名称机组纪录者日期C0.00样本容量 n2样本下限2日期1234567891011121314151617181920212223242526合计备注检查数量2222222222222222222222222252不良內容及数量00000000总不良数000000000000000000000000000不良率%#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!

7、#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!P控制图备注及原因跟踪:12345678910111213141516171819202122232425260 0 0 0 0 1 1 1 1 1 1 U 控控制制图图控制图编号：产品名称部门上限 UCL0.00中心限 CL0.00下限 LCL0.00子組数26样本上限11过程名称机组记录者日期U0.00样本容量 n9样本下限6日期1234567891011121314151617181920212223242526合计备注检查数量879

8、79810797981099791098107108108221不良內容及数量00000000总不良数000000000000000000000000000不良率%#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!P控制图备注及原因跟踪:123456789101112131415161

9、71819202122232425260.0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 控控制制图图的的常常数数和和公公式式表表 -图图 -s-s图图均均值值图图全全距距图图均均值值图图标标准准差差图图子子组组容容量量计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数nA2d2D3D4A3c4B3B421.8801.128-3.2672.6590.7979-3.27631.0231.

10、693-2.5711.9540.8862-2.56840.7292.059-2.2821.6280.9213-2.26650.5772.326-2.1141.4270.9400-2.08960.4832.543-2.0041.2870.95150.0301.97070.4192.7040.0761.9241.1820.95940.1181.88280.3732.8470.1361.8641.0990.96500.1851.81590.3372.9700.1841.8161.0320.96930.2391.761100.3083.0780.2231.7770.9750.97270.2841.71

11、6110.2853.1730.2561.7440.9270.97540.3211.679120.2663.2580.2831.7170.8860.97760.3541.640130.2493.3360.3071.6930.8500.97940.3821.618140.2353.4070.3281.6720.8170.98100.4061.594150.2233.4720.3471.6530.7890.98230.4281.572160.2123.5320.3631.6370.7630.98350.4481.552170.2033.5880.3781.6220.7390.98450.4461.5

12、34180.1943.6400.3911.6080.7180.98540.4821.518190.1873.6890.4031.5970.6980.98620.4971.503200.1803.7350.4151.5850.6800.98690.5101.490210.1733.7780.4251.5750.6630.98760.5231.477220.1673.8190.4341.5660.6470.98820.5341.466230.1623.8580.4431.5570.6330.98870.5451.455240.1573.8950.4511.5480.6190.98920.5551.

13、445250.1533.9310.4591.5410.6060.98960.5651.435UCLUCLX X,LCL,LCLX X =XAXA2 2R RUCLUCLX X,LCL,LCLX X =XAXA2 2R RUCLUCLR R =D D4 4R RUCLUCLS S =B B4 4s sLCLLCLR R =D D3 3R RLCLLCLS S =B B3 3s s=R/D=R/D2 2=s/cs/c4 4中中位位数数图图单单值值图图中中位位数数图图全全距距图图单单值值图图全全距距图图子子组组容容量量计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计

14、计算算控控制制限限用用的的系系数数计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数n nA A2 2d d2 2D D3 3D D4 4E E2 2d d2 2D D3 3D D4 42 21.8801.8801.1281.128-3.2673.2672.6602.6601.1281.128-3.2673.2673 31.1871.1871.6931.693-2.5742.5741.7721.7721.6931.693-2.5742.5744 40.7960.7962.0592.059-2.2822.2821.4571.4572.05

15、92.059-2.2822.2825 50.6910.6912.3262.326-2.1142.1141.2901.2902.3262.326-2.1142.1146 60.5480.5482.5342.534-2.0042.0041.1841.1842.5342.534-2.0042.0047 70.5080.5082.7042.7040.0760.0761.9241.9241.1091.1092.7042.7040.0760.0761.9241.9248 80.4330.4332.8472.8470.1360.1361.8641.8641.0541.0542.8472.8470.1360.

16、1361.8641.8649 90.4120.4122.9702.9700.1840.1841.8161.8161.0101.0102.9702.9700.1840.1841.8161.81610100.3620.3623.0783.0780.2230.2231.7771.7770.9750.9753.0783.0780.2230.2231.7771.777UCLUCLX X,LCL,LCLX X =XAXA2 2R RUCLUCLX X,LCL,LCLX X =XEXE2 2R RUCLUCLR R =D D4 4R RUCLUCLMRMR =D D4 4R RLCLLCLR R =D D3

17、 3R RLCLLCLMRMR =D D3 3R R=R/d=R/d2 2=R/dR/d2 2UCLUCLP P,LCL,LCLP P =UCLUCLnpnp,LCL,LCLnpnp =UCLUCLC C,LCL,LCLC C =UCLUCLU U,LCL,LCLU U =CpkCpk(1 1 k k )CpCp 或或 MINMIN CPU,CPLCPU,CPLPpkPpk(1 1 k k )PpPp 或或 MINMIN PPU,PPLPPU,PPL单单边边规规格格(设设计计规规格格)因因没没有有规规格格上上限限或或下下限限,没没有有规规格格下下限限 CpCp CPUCPU Cpk,Cpk,没

18、没有有规规格格上上限限 CpCp CPLCPL CpkCpknPPP/13nPPP13PPnPn13nUU3CC3单单边边规规格格(设设计计规规格格)因因没没有有规规格格上上限限或或下下限限,没没有有规规格格下下限限 CpCp CPUCPU Cpk,Cpk,没没有有规规格格上上限限 CpCp CPLCPL CpkCpk标准正态分布z过程输出超过特殊规定值（如工程规范限）的比例，這個特殊规定值与过程均值相差为z个标准查单位（针对处于统计控制状态并呈现正态分布的过程）。如-2.17，则z0.0150或1.5，在任何实际情况下，该比例为近似值。或x.x0 x.x1x.x2x.x3x.x4x.x5x.

19、x6x.x74.00.000033.90.00005 0.00005 0.00004 0.00004 0.00004 0.00004 0.00004 0.000043.80.00007 0.00007 0.00007 0.00006 0.00006 0.00006 0.00006 0.000053.70.00011 0.00010 0.00010 0.00010 0.00009 0.00009 0.00008 0.000083.60.00016 0.00015 0.00015 0.00014 0.00014 0.00013 0.00013 0.000123.50.00023 0.00022 0

20、.00022 0.00021 0.00020 0.00019 0.00019 0.000183.40.00034 0.00032 0.00031 0.00030 0.00029 0.00028 0.00027 0.000263.30.00048 0.00047 0.00045 0.00043 0.00042 0.00040 0.00039 0.000383.20.00069 0.00066 0.00064 0.00062 0.00060 0.00058 0.00056 0.000543.10.00097 0.00094 0.00090 0.00087 0.00084 0.00082 0.000

21、79 0.000763.00.00135 0.00131 0.00126 0.00122 0.00118 0.00114 0.00111 0.001072.90.00190.00180.00180.00170.00160.00160.00150.00152.80.00260.00250.00240.00230.00230.00220.00210.00212.70.00350.00340.00330.00320.00310.00300.00290.00282.60.00470.00450.00440.00430.00410.00400.00390.00382.50.00620.00600.005

22、90.00570.00550.00540.00520.00512.40.00820.00800.00780.00750.00730.00710.00690.00682.30.01070.01040.01020.00990.00960.00940.00910.00892.20.01390.01360.01320.01290.01250.01220.01190.01162.10.01790.01740.01700.01660.01620.01580.01540.01502.00.02280.02220.02170.02120.02070.02020.01970.01921.90.02870.028

23、10.02740.02680.02620.02560.02500.02441.80.03590.03510.03440.03360.03290.03220.03140.03071.70.04460.04360.04270.04180.04090.04010.03920.03841.60.05480.05370.05260.05160.05050.04950.04850.04751.50.06680.06550.06430.06300.06180.06060.05940.05821.40.08080.07930.07780.07640.07490.07350.07210.07081.30.096

24、80.09510.09340.09180.09010.08850.08690.08531.20.11510.11310.11120.10930.10750.10560.10380.10201.10.13570.13350.13140.12920.12710.12510.12300.12101.00.15870.15620.15390.15150.14920.14690.14460.14230.90.18410.18140.17880.17620.17360.17110.16850.16600.80.21190.20900.20610.20330.20050.19770.19490.19220.

25、70.24200.23890.23580.23270.22970.22660.22360.22060.60.27430.27090.26760.26430.26110.25780.25460.2514zSLPzXzSLPzX0.50.30850.30500.30150.29810.29460.29120.28770.28430.40.34460.34090.33720.33360.33000.32640.32280.31920.30.38210.37830.37450.37070.36690.36320.35940.35570.20.42070.41680.41290.40900.40520.

26、40130.39740.39360.10.46020.45620.45220.44830.44430.44040.43640.43250.00.50000.49600.49200.48800.48400.48010.47610.4721x.x8x.x90.00003 0.000030.00005 0.000050.00008 0.000080.00012 0.000110.00017 0.000170.00025 0.000240.00036 0.000350.00052 0.000500.00074 0.000710.00104 0.001000.00140.00140.00200.0019

27、0.00270.00260.00370.00360.00490.00480.00660.00640.00870.00840.01130.01100.01460.01430.01880.01830.02390.02330.03010.02940.03750.03670.04650.04550.05710.05590.06940.06810.08380.08230.10030.09850.11900.11700.14010.13790.16350.16110.18940.18670.21770.21480.24830.2451z过程输出超过特殊规定值（如工程规范限）的比例，這個特殊规定值与过程均值

28、相差为z个标准查单位（针对处于统计控制状态并呈现正态分布的过程）。如-2.17，则z0.0150或1.5，在任何实际情况下，zSLPzX0.28100.27760.31560.31210.35200.34830.38970.38590.42860.42470.46810.4641控控制制图图选选用用指指南南程程序序否否是是是否是是否否是是否是否是使用-图使用-图确定要制定控制图的特性是计量型数据吗？关心的是不合格品-即坏零件百分比吗？样品容量是否恒定？关心的是不合格数-即单位零件不合格数吗？样品容量是否恒定？使用图使用n或图使用中位数图性质子组取样-例如化学批量油漆等子组均值是否能方便地计算？使用单值图-子组容量大于或等于吗？是否能方便地计算组的值？使用或图使用-图否使用图使用-图使用-图关心的是不合格数-即单位零件不合格数吗？样品容量是否恒定？使用中位数图使用或图