SPC公式全集Excel最全版

控制图编号：X 图0.820.720.611516H104PC沟槽宽度123456规 格上限 USL中心限CL下限 LSL78标 准群组数大小管 制上限 UCL中心限CL下限 LCL0.900.700.509105总组数251112R图0.380.180.001718制 造部 门机 别测 定 者192021ＣＮＣＴＰ０５222324时间抽样方法日 期25随机2015-7-9合　　　计ΣＸ＝ΣＲ＝.50批样本测定值号1234513140.650.750.750.600.700.600.750.600.650.600.800.850.700.650.900.750.750.750.650.600.500.600.800.650.650.700.850.800.700.750.750.800.700.800.700.750.750.700.700.800.800.700.700.650.600.550.800.650.600.700.650.750.800.700.650.750.650.800.850.600.900.850.750.850.800.750.850.600.850.650.650.650.750.650.700.650.850.700.750.850.850.750.750.850.800.500.650.750.750.750.800.700.700.650.600.800.650.650.600.600.850.650.750.650.800.700.700.750.750.650.800.700.700.600.850.650.800.600.700.650.800.750.650.700.654.45量测数值的判定条件> USL 蓝色< LSL 红色 Ｎ＝125ΣＸＸR3.503.853.803.403.753.653.653.603.903.353.753.803.603.554.103.753.803.353.503.103.303.453.503.203.300.700.770.760.680.750.730.730.720.780.670.750.760.720.710.820.750.760.670.700.620.660.690.700.0.660.200.200.100.150.200.250.150.200.200.200.400.200.050.250.150.150.150.150.200.050.300.200.150.100.10 平 　均Ｘ＝0.72R=0.18预估不良率 (PPM)xＸ管制图1.00 0.90 0.80 0.70 0.60 0.50 0.40 12345671011121314151617181920212223242510355制程能力分析 Std.Dev.=0.09R管制图0.50 0.40 0.30 0.20 0.10 0.00 123456710111213141516171819202122232425 Sigma =0.08ＰＰＫ=0.72 PP =0.78 Ca =8.00%ＣＰＫ=0.80 CP =0.87Grade =D备注及原因追查:nd2D3D4A220304050671001.131.692.062.332.533.272.572.282.112.002.72.852.973.082.331.921.861.821.782.1100.080.140.180.221.881.020.730.580.480.420.370.340.310.58XUCL0.820.820.82CL0.720.720.72LCL0.610.610.610.420.560.560.490.720.0.420.560.0.420.720.490.720.420.560.000.000.00RUCL0.380.380.38CL0.180.180.18LCL0.000.000.000.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.61####0.360.490.490.560.420.000.490.560.420.720.0.000.360.560.560.720.490.000.560.0.420.560.490.000.360.490.0.560.560.000.420.0.720.720.560.000.360.490.360.0.420.000.0.560.810.250.0.000.720.560.720.420.490.000.490.490.560.560.490.000.420.490.720.560.360.000.810.0.0.560.720.000.560.0.560.0.420.000.560.490.720.490.0.000.560.490.360.490.360.000.420.420.720.420.490.000.360.360.420.360.420.000.250.300.420.0.0.000.360.0.420.420.560.000.0.420.560.420.420.000.420.360.420.360.490.000.420.490.490.360.420.000.000.000.000.000.000.00####################0.000.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00USL0.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.90LSL0.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.50