搜索
请将数据登入在白色方格内，若显红色则超上差，显蓝色则超下差。中心限CL下限值LSL实际测量值子组编号→样品编号↓通往初始面板X-R、X-S、中位数图数据登入表生成X-R图规范标准值上限值USL生成控制图数据清零X-R、X-S、中位数图数据登入表清除输入数据生成X-S图生成中位数图上限值USL中心限CL下限值LSL批次号12345678910111213样本测量值112.00151.00312.00321.00123.0012.0012.00321.00123.00155.00131.00412.00121.00批次号26272829303132333435363738样本测量值112.00151.00312.00321.00112.00151.00312.00321.00123.0012.00412.00132.00111.00批次号51525354555657585960616263样本测量值112.00151.00312.00321.00123.0012.00144.00412.00132.00111.00121.00114.00161.00批次号76777879808182838485868788样本测量值112.00151.00312.00321.00123.0012.00112.00151.00312.00321.00123.0012.00121.00规范标准值通往初始面板单值和移动全距X-MR图数据登入表生成控制图生成X-MR图(批次在50以内)请将数据登入在白色方格内，若显红色则超上差，显蓝色则超下差。200150100141516171819202122232425144.00412.00132.00111.00121.00114.00161.00166.00162.00162.00123.00123.00394041424344454647484950121.00114.00161.00166.00162.00112.00151.00312.00321.00123.0012.0012.00646566676869707172737475166.00162.00162.00123.00123.00112.00151.00312.00321.00123.0012.0021.008990919293949596979899100144.00412.00132.00111.00121.00114.00161.00166.00162.00162.00123.00123.00单值和移动全距X-MR图数据登入表清除输入数据数据清零生成控制图生成X-MR图(批次大于50)子组编号123456789101112子组容量5060708090100901023123223不良品数量/缺陷数量123251112244子组编号262728293031323334353637子组容量435424435452263442121135不良品数量/缺陷数量341242124125子组编号515253545556575859606162子组容量354667658976655262362662不良品数量/缺陷数量322332171312子组编号767778798081828384858687子组容量242312325443235235235345不良品数量/缺陷数量332317223441通往初始面板P图、U图数据登入表生成控制图请将数据登入在白色方格内生成P图(子组数大于50)生成U图(子组数大于50)生成P图(子组数在50以内)生成U图(子组数在50以内)131415161718192021222324254354232423432343123243123221212341214123839404142434445464748495034541211324433544433222839311572155232263646566676869707172737475345332245322342423432234531223342113155888990919293949596979899100646434643454446645646390903721323212755P图、U图数据登入表数据清零生成U图(子组数大于50)清除输入数据生成U图(子组数在50以内)固定子组容量↓150子组编号123456789101112不良品数量/缺陷数量121520122215141717172012子组编号262728293031323334353637不良品数量/缺陷数量111213142118202123151110子组编号515253545556575859606162不良品数量/缺陷数量1341213212123422321子组编号767778798081828384858687不良品数量/缺陷数量456862356364生成nP图(子组数大于50)请将数据登入在白色方格内通往初始面板nP图、C图数据登入表生成控制图生成nP图(子组数在50以内)1314151617181920212223242522152012221514141313121211383940414243444546474849502441516118296712115636465666768697071727374751112112976867238889909192939495969798991002346235324634生成C图(子组数在50以内)生成C图(子组数大于50)数据清零清除输入数据nP图、C图数据登入表生成控制图=Grade=Grade=X平方矩阵批次号CPU=CPL=Cpk=Ppk=Ca=Cp=Std.Dev.=Sigma=Pp=中心限CL(R)下限值LCL(R)预估不良率(PPM)中心限CL(X)上限值UCL(R)X和R的中位数图R=下限值LCL(X)ΣR=上限值UCL(X)上限值UCL(R)中心限CL(R)下限值LCL(R)子组容量n中心限CL预估不良率(PPM)R=中心限CL(X)下限值LCL(X)ΣR=平均中位数MidX规范上限USL规范下限LSL最小值MinXStd.Dev.=Pp=批次号样品测量值的平方ΣX峰度Kurtosis偏度Skewness运算符号Ppk=总组数Count总样本数N平均值X最大值MaxXΣXXRSΣX2X-RCa=Cpk=Cp=ΣX2CPU=CPL=Sigma=X-R、X-S、中位数图数据运算表返回子组内计算总样本合计上限值UCL(X)DeltaX-R乘数系数画线长度标记越界左边柱状图坐标组界频率LSL/USL7SigmaX-RMinMax计算组界起点XLCL/UCL(X)样品测量值的平方越界画线长度标记乘数系数Delta中位数7SigmaLSL/USLLCL/UCL(X)X计算组界起点左边中位数MinMax柱状图坐标组界频率画线长度标记乘数系数DeltaX-S7SigmaLSL/USLLCL/UCL(X)X计算组界起点X-SMinMax柱状图坐标组界频率左边越界X-SS=ΣS=Grade=上限值UCL(S)中心限CL(S)CPU=CPL=Cpk=Ppk=Ca=Cp=Std.Dev.=Sigma=Pp=预估不良率(PPM)上限值UCL(X)中心限CL(X)下限值LCL(X)下限值LCL(S)X-R、X-S、中位数图数据运算表n*SigmaLengthXUSLLSLNormal正态线坐标X右边标记线坐标n*SigmaLengthX右边正态线坐标XNormal标记线坐标USLLSLn*SigmaLength右边正态线坐标XNormal标记线坐标XUSLLSL横向计算批次号1234567891011121314样本测量值112.00151.00312.00321.00123.0012.0012.00321.00123.00155.00131.00412.00121.00144.00MR39.00161.009.00198.00111.000.00309.00198.0032.0024.00281.00291.0023.00X2125442280197344103041151291441441030411512924025171611697441464120736总样本合计总批次数N平均值X最大值MaxX最小值MinX中位数MidX规范上限USL中心限CL规范下限LSL偏度Skewness峰度KurtosisΣXΣX20.00528958.58101.3777.500.16预估不良率(PPM)Std.Dev.=Pp=Sigma=16714.00Cpk=CPL=上限值UCL(MR)中心限CL(MR)下限值LCL(MR)3810964.000.20Ppk=Cp=Grade=87.428655.00399.69167.14-65.41285.6287.42Ca=CPU=X-MRR=ΣR=上限值UCL(X)中心限CL(X)下限值LCL(X)100132.00200.00150.00100.000.88167.14412.0012.00返回X-MR图数据运算表E0.1134.28%0.220.140.290.14中位数Min计算组界起点-375.386X12.000中位数Delta36.168LCL/UCL(X)-65.408LSL/USL100.000乘数系数3616.842画线长度标记39.6007Sigma-375.386运算符号批次数大于50的运算总样本合计总批次数N平均值X最大值MaxX最小值MinX中位数MidX规范上限USL中心限CL规范下限LSL偏度Skewness峰度KurtosisΣXΣX2X-MR中位数Min50R=94.82计算组界起点-416.679171.72ΣR=4646.00X12.000412.00上限值UCL(X)423.93LCL/UCL(X)-80.49112.00中心限CL(X)171.72LSL/USL100.000138.00下限值LCL(X)-80.497Sigma-416.679200.00上限值UCL(MR)309.76150.00中心限CL(MR)94.82中位数100.00下限值LCL(MR)0.00Delta39.2270.82预估不良率(PPM)565036.01乘数系数1961.3310.01Std.Dev.=105.88画线长度标记18.7008586.00Sigma=84.062023700.00Pp=0.16运算符号Ppk=0.09Ca=43.44%Cp=0.20CPU=0.11批次数在50以内的运算CPL=0.28Cpk=0.11Grade=E151617181920212223242526272829303132412.00132.00111.00121.00114.00161.00166.00162.00162.00123.00123.00112.00151.00312.00321.00112.00151.00312.00268.00280.0021.0010.007.0047.005.004.000.0039.000.0011.0039.00161.009.00209.0039.00161.0016974417424123211464112996259212755626244262441512915129125442280197344103041125442280197344X-MR图数据运算表Max709.666412.000709.666399.688200.000柱状图坐标组界频率左边右边正态线坐标X1-414.1380-414.1382076079951-414.1382-377.9700=-377.969785801275=-414.1382076079952-406.9053-341.8010=-341.801363994556=-377.9697858012753-399.6714-305.6330=-305.63294