ppk分析表表格文件下载.xls
《ppk分析表表格文件下载.xls》由会员分享,可在线阅读,更多相关《ppk分析表表格文件下载.xls(3页珍藏版)》请在冰豆网上搜索。
3010:
0010:
3011:
0011:
3012:
0012:
3013:
0013:
3014:
0014:
3015:
0015:
3016:
3017:
0018:
3019:
0019:
3020:
0021:
30样本13.393.353.393.393.393.393.393.393.393.393.333.393.393.393.393.353.393.353.393.393.393.393.393.39样本23.393.393.393.393.393.393.393.393.393.393.393.373.363.393.393.393.393.393.393.393.353.393.353.39样本33.363.303.393.393.393.393.393.393.393.393.393.393.393.393.393.393.353.323.393.393.393.363.363.39样本43.393.363.393.393.403.393.393.333.393.393.393.363.393.393.393.393.353.393.353.303.303.363.393.39样本53.393.393.393.393.363.393.403.393.393.393.393.353.393.353.353.353.353.393.393.353.353.353.353.35均值3.383.363.393.393.393.393.393.383.393.393.383.373.383.383.383.373.373.373.383.363.363.373.373.38极差R0.030.090.000.000.040.000.010.060.000.000.060.040.030.040.040.040.040.070.040.090.090.040.040.04计算公式及结果:
控制上限UCL=3.378样本标准差:
=(X1+X2+X3Xi-nXbar/n-1)=0.010744732控制下限LCL=#上限PPK值:
PPK1=(USL-Xbar)/3=6.881925149下限PPK值:
PPK2=(XbarLSL)/3=2.424960853PPK=制程能力判定:
合格率不合格注:
PPK值取PPK1与PPK2中的最小值,PPK1.67,表示制程能力足够,判定为合格,否则判定为不合格。
制程能力不足原因分析及对策均值X图0:
000:
0000.40.81.21.622.42.83.23.64极极差差RR图图0:
000.000.100.200.300.400.50系列1UCL极极差差RR图图0:
000.000.100.200.300.400.50系列1