好文档就是一把金锄头!
欢迎来到金锄头文库![会员中心]
电子文档交易市场
安卓APP | ios版本
电子文档交易市场
安卓APP | ios版本

MSA方差分析模板.xls

2页
  • 卖家[上传人]:慢***
  • 文档编号:229472578
  • 上传时间:2021-12-25
  • 文档格式:XLS
  • 文档大小:269KB
  • / 2 举报 版权申诉 马上下载
  • 文本预览
  • 下载提示
  • 常见问题
    • Page:1/2河河南南省省西西峡峡汽汽车车水水泵泵股股份份有有限限公公司司 测测量量系系统统分分析析MSA GR&R-数数据据记记录录表表 Data Worksheet报报告告编编号号Report NO.量具名称Equipment Name产品类型Description测量人员Operator测试日期Test Tate量具编号Equipment NO.基件编号P/N测量人员Operator平价人数Appraisers3参数规格Dimension规格上限USL0.13测量人员Operator试验次数Trials3单位UnitMM规格下限LSL0过程变差/过程能力Process Variation(/PP)样 品 数Samples10分析时机Analytical Occasion零件编号Parts NO.12345678910Total平均值Average 1.A10.07500.08000.10000.05500.08000.07000.03000.08500.06000.11500.750.0750002.20.07000.08000.10000.06000.08000.06500.03000.08000.06000.11500.740.0740003.30.07000.08000.10000.06000.08000.06500.03000.08000.06000.11500.740.0740004.均值Mean 0.071670.080000.100000.058330.080000.066670.030000.081670.060000.115000.074333Sum A0.2150.240.30.1750.240.20.090.2450.180.3452.23005. 极差Range0.005000.00500.00500.005000.0020006.B10.07000.08000.10000.06000.08000.06500.03500.08500.06000.11500.750.0750007.20.07000.08000.09500.06000.07500.06500.03500.08000.06000.11500.7350.0735008.30.07000.08000.10000.06000.07500.07000.03500.08500.06000.11500.750.0750009.均值Mean 0.070000.080000.098330.060000.076670.066670.035000.083330.060000.115000.074500Sum B0.210.240.2950.180.230.20.1050.250.180.3452.235010. 极差Range000.00500.0050.00500.005000.00200011. C10.07500.08500.09500.06500.07500.06500.03000.08500.06000.11000.7450.07450012.20.07500.08000.09500.06000.07500.06500.03000.08500.05500.11000.730.07300013.30.07500.08000.09500.06000.07500.06500.03000.08500.06000.11000.7350.07350014.均值Mean 0.075000.081670.095000.061670.075000.065000.030000.085000.058330.110000.073667Sum C0.2250.2450.2850.1850.2250.1950.090.2550.1750.332.2115. 极差Range0.00000.00500.00000.00500.00000.00000.00000.00000.00500.00000.001500零件均值Parts Mean0.072222 0.080556 0.097778 0.060000 0.077222 0.066111 0.031667 0.083333 0.059444 0.1133330.074167Total 0.650000 0.725000 0.880000 0.540000 0.695000 0.595000 0.285000 0.750000 0.535000 1.0200006.6750.0816670.001833试验次数Trials230.000833D43.2672.5750.0760420.004721D3000.0722910.000000A21.881.023 注:当分析结果超出要求后,利用均值极差图分析原因When analysis result is out of spec,need analyse the root cause by mean and range chart 。

      均值图meanchart12345678910UCLx0.07600.07600.07600.07600.07600.07600.07600.07600.07600.0760LCLx0.07230.07230.07230.07230.07230.07230.07230.07230.07230.0723UCLR0.00470.00470.00470.00470.00470.00470.00470.00470.00470.0047LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差:6pp变差PV0.025692PV0.0256920.025692PV0.025692TV0.021667TV0.000000#DIV/0!TV0.025718基于公差base on parts spec%EV5.00%#DIV/0!#DIV/0!4.21%基于零件变差base on parts variation%AV1.79%#DIV/0!#DIV/0!1.51%基于过程变差base on process variation%RR5.31%#DIV/0!#DIV/0!4.47%基于过程能力Base on process PP%PV118.58%#DIV/0!#DIV/0!99.90%公式A Formula Andc31.48205331公式B Formula BX2/nkr0.4950625sumSQ(sum(men)/nr0.4950742SUMSQ(sum(1-10part)/kr0.5357250极差图RangechartSUMSQ(sum(men-part)/r0.5359917sumSQ(all)0.5361750n=part k=men r=timeANOVA Table With Operator*Part InteractionANOVA Table Without Operator*Part InteractionSourceDFSSMSFPSourceDFSSMSFPParts90.040660.00452318.921570.00000Parts90.040660.00452803.973380.00000Operators20.000010.000010.411760.66856Operators20.000010.000011.038020.35840Operators*Part180.000250.000014.636360.00000Repeatability600.000180.00000Repeatability780.000440.00001Total890.04111Total890.04111Gauge R&R With Operator*Part InteractionGauge R&R Without Operator*Part InteractionSourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%ToleranceTotal Gauge R&R0.000010.002601.33%11.54%12.00%Total Gauge R&R0.000010.002371.11%10.53%10.95% Repeatability0.000000.001750.60%7.76%8.07% Repeatability0.000010.002371.11%10.53%10.94% Reproducibility0.000000.001920.73%8.55%8.88% Reproducibility0.000000.000080.00%0.37%0.39% Operator0.000000.000000.00%0.00%0.00% Operator0.000000.000080.00%0.37%0.39%Operators*Part0.000000.001920.73%8.55%8.88%Part - To - Part0.000500.0223798.67%99.33%103.25%Part - To - Part0.000500.0223998.89%99.44%103.35%AX=AR=BX=BR=CX=佃R礽=PPX=-=X楍nX慍xXRLX2=-=RAXLX2=RDL屒4吳0.00000 0.02000 0.04000 0.06000 0.08000 0.10000 0.12000 0.14000 AUCLxLCLxBC0.0000 0.0010 0.0020 0.0030 0.0040 0.0050 0.0060 CUCLRLCLRBARegularNew QCPPPAPOther=+=A p p r a is e r sR cRRbA/)(RPage:2/2Total Variation0.000510.02252100.00%100.00%103.94%Total Variation0.000510.02252100.00%100.00%103.92%河河南南省省西西峡峡汽汽车车水水泵泵股股份份有有限限公公司司 测测量量系系统统分分析析MSA GR&R-变变差差数数分分析析法法ANOVAANOVA methodmethod报报告告编编号号ReportReport NO.NO.量具名称Equipment产品类型Description测量人员Operator测试日期TestTate1899/12/31量具编号Equipment NO.基件编号Part NO.测量人员Operator平价人数Appraisers3参数规格Specification规格上限Upper limit0.13测量人员Operator试验次数Trials3测量单位UnitMM规格下限Lower Limit 0过程变差Process Variation(6)样 品数Samples10方差分析表格ANOVATable 包含With操作员和零件的相互作用Operator*Part Interaction变差来源Source自由DFDegree of freedom平方的总和SSSum of squares平均平方MSMean squareF-比率F-ratio有效分辨率AvailabilityResolution(NDC)零件Parts90.04070.0045318.9216评价者Operators20.00000.00000.4118评价者和零件Operators*Part180.00030.00004.6364设备Equipment600.00020.000012.132271212汇总Total890.0411变差来源Source变差估计值Estimate of vaiance标准偏差Stdev%贡献率Contribution%总变差TV%公差T。

      点击阅读更多内容
      关于金锄头网 - 版权申诉 - 免责声明 - 诚邀英才 - 联系我们
      手机版 | 川公网安备 51140202000112号 | 经营许可证(蜀ICP备13022795号)
      ©2008-2016 by Sichuan Goldhoe Inc. All Rights Reserved.