图解：用EXCEL制作 控制图(QC工具)

《图解：用EXCEL制作 控制图(QC工具)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、绘制控制图一、准备参数表：常用计量值控制图系数总汇均值图极差R图均值图标准差S图标准差估计的除控制限计算标准差估子组容量控制限计算系数控制限计算系数控制限计算系数数系数计的除数nA2d2D3D4A3C4B3B421.88001.12800.00003.26702.65900.79790.00003.267031.02301.69300.00002.57401.95400.88620.00002.568040.72902.05900.00002.28201.62800.92130.00002.266050.57702.32600.00

2、002.11401.42700.94000.00002.089060.48302.53400.00002.00401.28700.95150.03001.970070.14902.70400.07601.92401.18200.95940.11801.882080.37302.84700.13601.86401.09900.96500.18501.815090.33702.97000.18401.81601.03200.96930.23901.7610100.30803.07800.22301.77700.97500.97270.2

3、8401.7160110.28503.17300.25601.74400.92700.97540.32101.6790120.26603.25800.28301.71700.88600.97760.35401.6460130.24903.33600.30701.69300.85000.97940.38201.6180140.23503.40700.32801.67200.81700.98100.40601.5940150.22303.47200.34701.65300.78900.98230.42801.5720160.21203.

4、53200.36301.63700.76300.98300.44001.5520170.20303.58800.73801.62200.73900.98450.46601.5340180.19403.64000.39101.60800.71800.98540.48201.5180190.18703.68900.40301.59700.69800.98620.49701.5030200.18003.73500.41501.58500.68000.98690.51001.4900210.17303.77800.42501.57500.6

5、6300.98760.52301.4770220.16703.81900.43401.56600.64700.98820.53401.4660230.16203.85800.44301.55700.63300.98870.54501.4550240.15703.89500.45101.54800.61900.98920.55501.4450250.15303.93100.45901.54100.60600.98960.56501.4350UCLXA2RUCLD4RUCLUCL=X+A3SXA3SUCLB4SCLXR

6、/d2CLRCLCL=XXS/C4CLSLCLXA2RLCLD3RLCLLCLLCLXA3S=XX-A3A3SSLCLB3S中位数图极差R图单值X图极差R图标准差估计的除控制限计算标准差估子组容量控制限计算系数控制限计算系数控制限计算系数数系数计的除数nA2d2D3D4E2d2D3D421.88001.12800.00003.26702.66001.12800.00003.267031.18701.69300.00002.57401.77201.69600.00002.574040.79602.05900.000

7、02.28201.45702.05900.00002.282050.69102.32600.00002.11401.29002.32600.00002.114060.54802.53400.00002.00401.18402.53400.00002.004070.50802.70400.07601.92401.10902.70400.07601.924080.43302.84700.13601.86401.05402.84700.13601.864090.41202.97000.18401.81601.01002.97000.184

8、01.8160100.36203.07800.22301.77700.97503.07800.22301.7770~UCLXA2RUCLD4RUCLXE2RUCLD4RCLX~R/d2CLXS/C4CLRCL