SPC控制图Excel计算模板(均值-标准差).pdf
上传人:文库****品店 上传时间:2024-09-11 格式:PDF 页数:4 大小:124KB 金币:10 举报 版权申诉
预览加载中,请您耐心等待几秒...

SPC控制图Excel计算模板(均值-标准差).pdf

SPC控制图Excel计算模板(均值-标准差).pdf

预览

在线预览结束,喜欢就下载吧,查找使用更方便

10 金币

下载此文档

如果您无法下载资料,请参考说明:

1、部分资料下载需要金币,请确保您的账户上有足够的金币

2、已购买过的文档,再次下载不重复扣费

3、资料包下载后请先用软件解压,在使用对应软件打开

`X-s控制图项目/合同技术规格控制标准样本数n管制XX编号上限USL1855上限UCL管制项目XX中心限CL165子组数m中心限CL测量单位XX下限LSL14525下限LCL抽样时间XXXXXX...子组123456789101112131411541661681681531641671581561741681481651642174170166164165158169160162162174160159166样本316416216017016216215916216416216616214716441661661621641651721751641521561601641531705162164160166167168165166164174166170151164SXi820.0828.0816.0832.0812.0824.0835.0810.0798.0828.0834.0804.0775.0828.0`X164165.6163.2166.4162.4164.8167162159.6165.6166.8160.8155165.6s7.2112.9663.6332.6085.5505.4045.8313.1625.3678.0505.0208.0757.0712.608182.00174.00166.00`C管制图158.00150.00142.00123456789101112131415.0010.00R管制图5.000.001234567891011121314异常及原因追查:n2345678910A2.6591.9541.6281.4271.2871.1821.0991.0320.97531.427B00000.030.1180.1850.2390.28430B3.2672.5682.2662.0891.971.8821.8151.7611.71642.089c40.7970.8860.9210.940.9510.9590.9650.9690.9720.94XUCLXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXCLXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXLCLXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX技术185185185185185185185185185185185185185185185技术规格145145145145145145145145145145145145145145145规格sUCLXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXCLXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXLCLXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX-s控制图`Xs生产部门XX控制图编XXXXXX工序XX号XXXX测定者XX抽样方法XXXXXX时间XX合计1516171819202122232425S`Ci=4081.4162158151166170168162166172174151SR=141.0984158162158166170160164160164164160N=125154156154172166162165170159166164168164181164160154169172165157158172152168162160160153158160162170平均814.0792.0812.0830.0826.0804.0813.0826.0820.0823.0803.0Xu=163.256162.8158.4162.4166165.2160.8162.6165.2164164.6160.6s5.6447.2944.775#####3.7425.0205.0205.9416.0995.1486.2297.057预估不良率ppm1327.2制程能力分析141516171819202122232425Std.Dev.=6.102Sigma=6.004PPK=0.997PP=1.092Ca=8.72%CPK=1.01441516171819202122232425CP=1.110Grade=CXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX185185185185185185185185185185145145145145145145145145145145XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX