SPC(Cpk、Ppk等)工程能力计算公式和Excel制图

均值Ｘ图均值Ｘ图n A2d2D3D4A3c4B3B42 1.880 1.128- 3.267 2.6590.7979- 3.2763 1.023 1.693- 2.571 1.9540.8862- 2.56840.729 2.059- 2.282 1.6280.9213- 2.26650.577 2.326- 2.114 1.4270.9400- 2.08960.483 2.543- 2.004 1.2870.95150.030 1.97070.419 2.7040.076 1.924 1.1820.95940.118 1.88280.373 2.8470.136 1.864 1.0990.96500.185 1.81590.337 2.9700.184 1.816 1.0320.96930.239 1.761100.308 3.0780.223 1.7770.9750.97270.284 1.716110.285 3.1730.256 1.7440.9270.97540.321 1.679120.266 3.2580.283 1.7170.8860.97760.354 1.640130.249 3.3360.307 1.6930.8500.97940.382 1.618140.235 3.4070.328 1.6720.8170.98100.406 1.594150.223 3.4720.347 1.6530.7890.98230.428 1.572160.212 3.5320.363 1.6370.7630.98350.448 1.552170.203 3.5880.378 1.6220.7390.98450.446 1.534180.194 3.6400.391 1.6080.7180.98540.482 1.518190.187 3.6890.403 1.5970.6980.98620.497 1.503200.180 3.7350.415 1.5850.6800.98690.510 1.490210.173 3.7780.425 1.5750.6630.98760.523 1.477220.167 3.8190.434 1.5660.6470.98820.534 1.466230.162 3.8580.443 1.5570.6330.98870.545 1.455240.157 3.8950.451 1.5480.6190.98920.555 1.445250.153 3.9310.459 1.5410.6060.98960.565 1.435X±A 2R X±A 2R

中位数Ｘ图单值Ｘ图n A 2d 2D 3D 4E 2d 2D 3D 42 1.880 1.128- 3.267 2.660 1.128- 3.2673 1.187 1.693- 2.574 1.772 1.693- 2.57440.796 2.059- 2.282 1.457 2.059- 2.282标准差估

计值的除数UCL X ,LCL X = 全距Ｒ图 全距Ｒ图 中位数图计算控制限用的系数单值图

LCL S = B 3s

标准差估

计值的除数计算控制限用的系

数

全距Ｒ图 子组容量计算控制限用的系数标准差估计值的除数计算控制限用的系数 Ｘ-Ｒ图 标准差Ｓ图 Ｘ-s图

计算控制限用的系数计算控制限用的系

数

UCL S = B 4s

控制图的常数和公式表

δ=R/D 2δ= s/c 4

子组容量计算控制限用的系数标准差

估计值的除数计算控制限用的系数UCL X ,LCL X =UCL R = D 4R LCL R = D 3R

50.691 2.326- 2.114 1.290 2.326- 2.11460.548 2.534- 2.004 1.184 2.534- 2.00470.508 2.7040.076 1.924 1.109 2.7040.076 1.92480.433 2.8470.136 1.864 1.054 2.8470.136 1.86490.412 2.9700.184 1.816 1.010 2.9700.184 1.816100.362 3.0780.223 1.7770.975 3.0780.223 1.777X±A 2R X±E 2R δ=R/d 2δ= R/d 2UCL R = D 4R

UCL MR = D 4R LCL R = D 3R

LCL MR = D 3R UCL ,LCL =UCL X ,LCL X =

UCL P ,LCL P ==UCL np ,LCL np =UCL C ,LCL C =UCL U ,LCL U =Cpk＝( 1 － k ) ｘ Cp 或 MIN {CPU,CPL}Ppk＝( 1 － k ) ｘ Pp 或 MIN {PPU,PPL}

单边规格(设计规格)因没有规格上限或下限,没有规格下限 Cp ＝ CPU ＝ Cpk,没有规格上限 Cp ＝ ()

n P P P /13-±=()n P P P -±=13

()P P n P n -±=13n

U

U 3±=C

C 3±=