MSA测量系统分析表格表格推荐下载.xlsx
《MSA测量系统分析表格表格推荐下载.xlsx》由会员分享,可在线阅读,更多相关《MSA测量系统分析表格表格推荐下载.xlsx(3页珍藏版)》请在冰豆网上搜索。
![MSA测量系统分析表格表格推荐下载.xlsx](https://file1.bdocx.com/fileroot1/2022-10/9/ac2270e1-0015-45ec-a4c0-e5c458d43c47/ac2270e1-0015-45ec-a4c0-e5c458d43c471.gif)
均值图meanchart12345678910UCLx349.9399349.9399349.9399349.9399349.9399349.9399349.9399349.9399349.9399349.9399LCLx349.8799349.8799349.8799349.8799349.8799349.8799349.8799349.8799349.8799349.8799UCLR0.07550.07550.07550.07550.07550.07550.07550.07550.07550.0755LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差:
6pp变差PV0.192256PV0.1922560.192256PV0.192256TV0.000000TV0.000000#DIV/0!
TV0.193155基于公差baseonpartsspec%EV#DIV/0!
#DIV/0!
8.97%基于零件变差baseonpartsvariation%AV#DIV/0!
3.52%基于过程变差baseonprocessvariation%RR#DIV/0!
9.64%基于过程能力BaseonprocessPP%PV#DIV/0!
99.53%公式AFormulaAndc14.56203294公式BFormulaBX2/nkr11019323.7308011sumSQ(sum(men)/nr11019323.7345633SUMSQ(sum(1-10part)/kr11019326.5500111极差图RangechartSUMSQ(sum(men-part)/r11019326.5673000sumSQ(all)11019326.5857000n=partk=menr=timeANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteractionSourceDFSSMSFPSourceDFSSMSFPParts92.819210.31325416.837410.00000Parts92.819210.31325765.289990.00000Operators20.003760.001882.503200.10985Operators20.003760.001884.595740.01261Operators*Part180.013530.000752.450480.00499Repeatability600.018400.00031Repeatability780.031930.00041Total892.85490Total892.85490GaugeR&
RWithOperator*PartInteractionGaugeR&
RWithoutOperator*PartInteractionSourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%ToleranceTotalGaugeR&
R0.000490.022191.40%11.83%#DIV/0!
TotalGaugeR&
R0.000460.021411.30%11.41%#DIV/0!
Repeatability0.000310.017510.87%9.33%#DIV/0!
Repeatability0.000410.020231.16%10.78%#DIV/0!
Reproducibility0.000190.013640.53%7.27%#DIV/0!
Reproducibility0.000050.007000.14%3.73%#DIV/0!
Operator0.000040.006140.11%3.27%#DIV/0!
Operator0.000050.007000.14%3.73%#DIV/0!
Operators*Part0.000150.012180.42%6.49%#DIV/0!
Part-To-Part0.034720.1863498.60%99.30%#DIV/0!
Part-To-Part0.034760.1864498.70%99.35%#DIV/0!
TotalVariation0.035210.18765100.00%100.00%#DIV/0!
TotalVariation0.035220.18766100.00%100.00%#DIV/0!
AXARBXBRCX佃RPPXXnXxXRLX2RAXLX2RDL屒4吳349.40000349.60000349.80000350.00000350.20000350.40000350.60000AUCLxLCLxBC0.00000.01000.02000.03000.04000.05000.06000.07000.0800CUCLRLCLRBARegularNewQCPPPAPOtherAppraisersRcRRbA/)(RPage:
1/3测测量量系系统统分分析析MSAGR&
R-均均值值极极差差法法AverageAverageandandmethodmethod报报告告编编号号ReportReportNO.NO.QAC-001/20150127量具名称Equipment电阻测量工装产品类型Description电阻应变计测量人员Operator李永江测试日期TestTate2015.1.27量具编号EquipmentNO.D6123679CD251/001-085基件编号PartNO.测量人员Operator程静娅平价人数Appraisers3参数规格Specification规格上限Upperlimit测量人员Operator冯博试验次数Trials3测量单位Unit规格下限LowerLimit过程变差/过程能力ProcessVariation(/PP)样品数Samples10Datasheet:
0.0293330.0143330.611111分析方式Analysismode基基于于零零件件变