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

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 控控 制制 图图控制图编号：产品名称部 门上 限 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不良率%#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%10.0%20.0%30.0%40.0%50.0%60.0%70.0%80.0%90.0%100.0%nP 控控 制制 图图控制图编号：产品名称部 门上 限 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不良率%#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中心限 CL0.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!#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合计备注检查数量87979810797981099791098107108108221不良內容及数量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控制图备注及原因跟踪:12345678910111213141516171819202122232425260.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.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.716110.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.534180.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.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中中位位数数图图单单值值图图中中位位数数图图 全全距距图图 单单值值图图 全全距距图图 子子组组容容量量计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数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.0592.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.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 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,没没有有规规格格上上限限 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.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.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.00079 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.00590.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.02810.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.09680.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.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.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.00190.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过程输出超过特殊规定值（如工程规范限）的比例，這個特殊规定值与过程均值相差为z个标准查单位（针对处于统计控制状态并呈现正态分布的过程）。如-2.17，则z0.0150或1.5，在任何实际情况下，zSLPzX0.28100.27760.31560.31210.35200.34830.38970.38590.42860.42470.46810.4641控控制制图图选选用用指指南南程程序序否否是是是否是是否否是是否是否是使用-图使用-图确定要制定控制图的特性是计量型数据吗？关心的是不合格品-即坏零件百分比吗？样品容量是否恒定？关心的是不合格数-即单位零件不合格数吗？样品容量是否恒定？使用图使用n或图使用中位数图性质子组取样-例如化学批量油漆等子组均值是否能方便地计算？使用单值图-子组容量大于或等于吗？是否能方便地计算组的值？使用或图使用-图否使用图使用-图使用-图关心的是不合格数-即单位零件不合格数吗？样品容量是否恒定？使用中位数图使用或图