GR&R自动生成Excel表格(MSA第四版).pdf
上传人:文库****品店 上传时间:2024-09-11 格式:PDF 页数:3 大小:218KB 金币:10 举报 版权申诉
预览加载中,请您耐心等待几秒...

GR&R自动生成Excel表格(MSA第四版).pdf

GR&R自动生成Excel表格(MSA第四版).pdf

预览

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

10 金币

下载此文档

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

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

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

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

测量系统分析MSAGR&R---数据记录表DataWorksheet报告编号ReportNO.量具名称产品类型测量人员测试日期EquipmentNameDescriptionOperatorATestTate量具编号基件编号测量人员平价人数3EquipmentNO.P/NOperatorBAppraisers参数规格规格上限测量人员试验次数3DimensionUSLOperatorCTrials单位规格下限过程变差/过程能力样品数MM10UnitLSLProcessVariation(σ/PP)Samples分析时机AnalyticalOccasionRegularNewQCPPPAPOther零件编号PartsNO.12345678910Total平均值Average1.A10.29-0.561.340.47-0.80.020.59-0.312.26-1.361.940.1940002.20.41-0.681.170.5-0.92-0.110.75-0.21.99-1.251.660.1660003.30.64-0.581.270.64-0.84-0.210.66-0.172.01-1.312.110.2110004.均值Mean0.44667-0.606671.260000.53667-0.85333-0.100000.66667-0.226672.08667-1.30667X=0.190333ASumA1.34-1.823.781.61-2.56-0.32-0.686.26-3.925.71005.极差Range0.350.120.170.170.120.230.160.140.270.11R=0.184000A6.B10.08-0.471.190.01-0.56-0.20.47-0.631.8-1.680.010.0010007.20.25-1.220.941.03-1.20.220.550.082.12-1.6211.3040.1150008.30.07-0.681.340.2-1.280.060.83-0.342.19-1.50.890.0890009.均值Mean0.13333-0.790001.156670.41333-1.013330.026670.61667-0.296672.03667-1.60000X=0.068333BSumB0.4-2.373.471.24-3.040.081.85-0.896.11-4.82.050010.极差Range0.180.750.41.020.720.420.360.710.390.18R=0.513000B11.C10.04-1.380.880.14-1.46-0.290.02-0.461.77-1.49-2.23-0.22300012.2-0.11-1.131.090.2-1.07-0.670.01-0.561.45-1.77-2.56-0.25600013.3-0.15-0.960.670.11-1.45-0.490.21-0.491.87-2.16-2.84-0.28400014.均值Mean-0.07333-1.156670.880000.15000-1.32667-0.483330.08000-0.503331.69667-1.80667X=-0.254333CSumC-0.22-3.472.640.45-3.98-1.450.24-1.515.09-5.42-7.6315.极差Range0.19000.42000.42000.09000.39000.38000.20000.10000.42000.6700R=0.328000C零件均值X0.168889-0.8511111.0988890.366667-1.064444-0.1855560.454444-0.3422221.940000-1.571111X=0.001444PartsMeanPTotal1.520000-7.6600009.8900003.300000-9.580000-1.6700004.090000-3.08000017.460000-14.1400000.13R=3.511111P试验次数Trials23R=(R+R+Rc)/Appraisers=0.341667AbX=MaxX-MinX=0.444667D43.272.575DIFFUCL=X+AR=0.350969UCL=DR=0.879792D300X2R4LCL=X-AR=-0.348081LCL=DR=0.000000A21.881.023X2R3注:当分析结果超出要求后,利用均值极差图