下載本文檔
版權(quán)說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請進行舉報或認領(lǐng)
文檔簡介
,,,,,,,,,,,,,,,,,
測量系統(tǒng)分析MSAGR&R---數(shù)據(jù)記錄表DataWorksheet,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,報告編號ReportNO.,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
"量具名稱
EquipmentName",,,,,,"產(chǎn)品類型
Description",,,,"測量人員
OperatorＡ",,A,,"測試日期
TestTate",,
,,,,,,,,,,,,,,,,,
"量具編號
EquipmentNO.",,,,,,"基件編號
P/N",,,,"測量人員
OperatorＢ",,B,,"平價人數(shù)
Appraisers",,3
,,,,,,,,,,,,,,,,,
"參數(shù)規(guī)格
Dimension",,,,,,"規(guī)格上限
USL",,72,,"測量人員
OperatorＣ",,C,,"試驗次數(shù)
Trials",,3
,,,,,,,,,,,,,,,,,
"單位
Unit",,,,MM,,"規(guī)格下限
LSL",,71.4,"過程變差/過程能力
ProcessVariation(σ/PP)",,,,,"樣品數(shù)
Samples",,10
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
分析時機AnalyticalOccasion,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
零件編號PartsNO.,,,,1,2,3,4,5,6,7,8,9,10,Total,平均值A(chǔ)verage,
1.,A,,1,71.7244,71.6857,71.7058,71.703,71.682,71.7244,71.6857,71.7058,71.703,71.682,717.0018,71.700180,
2.,,,2,71.7247,71.6863,71.7035,71.6989,71.6821,71.7247,71.6863,71.7035,71.6989,71.6821,716.991,71.699100,
3.,,,3,71.7230,71.6857,71.7029,71.7029,71.6834,71.7230,71.6857,71.7029,71.7029,71.6834,716.9958,71.699580,
4.,,,均值Mean,71.72403,71.68590,71.70407,71.70160,71.68250,71.72403,71.68590,71.70407,71.70160,71.68250,,,71.699620
,,,SumA,215.1721,215.0577,215.1122,215.1048,215.0475,215.1721,215.0577,215.1122,215.1048,215.0475,2150.9886,,
5.,,,極差Range,0.0017,0.0006,0.0029,0.0041,0.0014,0.0017,0.0006,0.0029,0.0041,0.0014,,,0.002140
6.,B,,1,71.7233,71.6891,71.7046,71.7033,71.683,71.7233,71.6891,71.7046,71.7033,71.683,717.0066,71.700660,
7.,,,2,71.7256,71.6885,71.7043,71.7034,71.6845,71.7256,71.6885,71.7043,71.7034,71.6845,11.304,71.701260,
8.,,,3,71.7251,71.6917,71.7046,71.7039,71.6829,71.7251,71.6917,71.7046,71.7039,71.6829,717.0164,71.701640,
9.,,,均值Mean,71.72467,71.68977,71.70450,71.70353,71.68347,71.72467,71.68977,71.70450,71.70353,71.68347,,,71.701187
,,,SumB,215.174,215.0693,215.1135,215.1106,215.0504,215.174,215.0693,215.1135,215.1106,215.0504,2151.0356,,
10.,,,極差Range,,0.0032,0.0003,0.0006,0.0016,0.0023,0.0032,0.0003,0.0006,0.0016,,,0.001522
11.,C,,1,71.7257,71.6901,71.7018,71.7044,71.6824,71.7257,71.6901,71.7018,71.7044,71.6824,717.0088,71.700880,
12.,,,2,71.7237,71.6896,71.7019,71.7045,71.6834,71.7237,71.6896,71.7019,71.7045,71.6834,717.0062,71.700620,
13.,,,3,71.7247,71.6904,71.7025,71.704,71.6842,71.7247,71.6904,71.7025,71.704,71.6842,717.0116,71.701160,
14.,,,均值Mean,71.72470,71.69003,71.70207,71.70430,71.68333,71.72470,71.69003,71.70207,71.70430,71.68333,,,71.700887
,,,SumC,215.1741,215.0701,215.1062,215.1129,215.05,215.1741,215.0701,215.1062,215.1129,215.05,2151.0266,,
15.,,,極差Range,0.0020,0.0008,0.0007,0.0005,0.0018,0.0020,0.0008,0.0007,0.0005,0.0018,,,0.001160
"零件均值
PartsMean",,,,71.724467,71.688567,71.703544,71.703144,71.683100,71.724467,71.688567,71.703544,71.703144,71.683100,,,71.700564
Total,,,,645.520200,645.197100,645.331900,645.328300,645.147900,645.520200,645.197100,645.331900,645.328300,645.147900,6453.0508,,0.041367
,,,,,,,,0.001607,,,,試驗次數(shù)Trials,,,2,3
,,,,,,,,0.001567,,,,,,D4,3.267,2.575
,,,,,,71.702209,,,,,0.004139,,,D3,0,0
,,,,,,71.698920,,,,,0.000000,,,A2,1.88,1.023
"注:當分析結(jié)果超出要求后，利用均值極差圖分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。",,,,,,,,,,,,,,,,
"均值圖
meanchart",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,1,2,3,4,5,6,7,8,9,10,,,
,,,UCLx,71.7022,71.7022,71.7022,71.7022,71.7022,71.7022,71.7022,71.7022,71.7022,71.7022,,,
,,,LCLx,71.6989,71.6989,71.6989,71.6989,71.6989,71.6989,71.6989,71.6989,71.6989,71.6989,,,
,,,UCLR,0.0041,0.0041,0.0041,0.0041,0.0041,0.0041,0.0041,0.0041,0.0041,0.0041,,,
,,,LCLR,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,公差：,,,,6σ,,,pp,變差,,,,
,,,,PV,0.013014,,,PV,0.013014,,0.013014,PV,0.013014,,,
,,,,TV,0.100000,,,TV,0.000000,,#DIV/0!,TV,0.013073,,,基于公差baseonpartsspec
,,%EV,,,0.95%,,,,#DIV/0!,,#DIV/0!,,7.26%,,,基于零件變差baseonpartsvariation
,,%AV,,,0.80%,,,,#DIV/0!,,#DIV/0!,,6.13%,,,基于過程變差baseonprocessvariation
,,%RR,,,1.24%,,,,#DIV/0!,,#DIV/0!,,9.50%,,,基于過程能力BaseonprocessPP
,,%PV,,,13.01%,,,,#DIV/0!,,#DIV/0!,,99.55%,,,公式AFormulaA
,,,,ndc,14.77027381,,,,,,,,,,,公式BFormulaB
,,,,X^2/nkr,462687.3847487,,sumSQ(sum(men))/nr,,,462687.3847902,SUMSQ(sum(1-10part))/kr,,,462687.4033932,,
"極差圖
Rangechart",,SUMSQ(sum(men-part))/r,,,,462687.4035058,,sumSQ(all),,462687.4035732,,,,n=partk=menr=time,,
,,,ANOVATableWithOperator*PartInteraction,,,,,,,ANOVATableWithoutOperator*PartInteraction,,,,,,
,,,Source,,DF,SS,MS,F,P,Source,,DF,SS,MS,F,P
,,,Parts,,9,0.01864,0.00207,524.01657,0.00000,Parts,,9,0.01864,0.00207,1166.18021,0.00000
,,,Operators,,2,0.00004,0.00002,5.24734,0.01602,Operators,,2,0.00004,0.00002,11.67776,0.00003
,,,Operators*Part,,18,0.00007,0.00000,3.51930,0.00013,,,,,,,
,,,Repeatability,,60,0.00007,0.00000,,,Repeatability,,78,0.00014,0.00000,,
,,,Total,,89,0.01882,,,,Total,,89,0.01882,,,
,,,GaugeR&RWithOperator*PartInteraction,,,,,,,GaugeR&RWithoutOperator*PartInteraction,,,,,,
,,,Source,,VarComp,Stdev,%Contribution,%TV,%Tolerance,Source,,VarComp,Stdev,%Contribution,%TV,%Tolerance
,,,TotalGaugeR&R,,0.00000,0.00162,1.13%,10.63%,1.62%,TotalGaugeR&R,,0.00000,0.00155,1.04%,10.18%,1.55%
,,,Repeatability,,0.00000,0.00106,0.48%,6.95%,1.06%,Repeatability,,0.00000,0.00133,0.76%,8.74%,1.33%
,,,Reproducibility,,0.00000,0.00123,0.65%,8.04%,1.23%,Reproducibility,,0.00000,0.00080,0.27%,5.22%,0.80%
,,,Operator,,0.00000,0.00075,0.24%,4.91%,0.75%,Operator,,0.00000,0.00080,0.27%,5.22%,0.80%
,,,Operators*Part,,0.00000,0.00097,0.41%,6.37%,0.97%,,,,,,,
,,,Part-To-Part,,0.00023,0.01516,98.87%,99.43%,15.16%,Part-To-Part,,0.00023,0.01517,98.96%,99.48%,15.17%
,,,TotalVariation,,0.00023,0.01524,100.00%,100.00%,15.24%,TotalVariation,,0.00023,0.01524,100.00%,100.00%,15.24%
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
測量系統(tǒng)分析MSAGR&R---均值極差法Averageandmethod,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,報告編號ReportNO.,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
"量具名稱
Equipment",,,,,,"產(chǎn)品類型
Description",,,,"測量人員
OperatorＡ",,A,,,"測試日期
TestTate",1899/12/31
,,,,,,,,,,,,,,,,,
"量具編號
EquipmentNO.",,,,,,"基件編號
PartNO.",,,,"測量人員
OperatorＢ",,B,,,"平價人數(shù)
Appraisers",3
,,,,,,,,,,,,,,,,,
"參數(shù)規(guī)格
Specification",,,,,,"規(guī)格上限
Upperlimit",,72,,"測量人員
OperatorＣ",,C,,,"試驗次數(shù)
Trials",3
,,,,,,,,,,,,,,,,,
"測量單位
Unit",,,,MM,,"規(guī)格下限
LowerLimit",,71.4,"過程變差/過程能力
ProcessVariation(σ/PP)",,,,,,"樣品數(shù)
Samples",10
,,,,,,,,,,,,,,,,,
Datasheet：,,,,,0.001607,,,0.001567,,,0.041367,,,,,
,,,,,,,,,,,分析方式Analysismode,基于零件變差baseonpartsvariation,,,,
,測量系統(tǒng)分析MSA,,,,,,,,,,%總變差Totalvariation（TV）,,,,,
,重復性Repeatability－設(shè)備變差EquipmentVariation(EV),,,,,,,,,,,,,,,
,,,,,,,,,,,,=,7.26%,,,
,=,0.000950,,,,,,,"試驗次數(shù)
Trials",K1,,,,,,
,,,,,,,,,2,0.8862,,,,,,
,,,,,,,,,3,0.5908,,,,,,
,再現(xiàn)性Reproducibility－評價人變差AppraiserVariation(AV),,,,,,,,,,,,,,,
,,,,,,,,,,,,=,6.13%,,,
,=,0.000801,#DIV/0!,#DIV/0!,,,,,"評價人數(shù)
Appraisers",K2,,,,,,
,,,,,,,,,2,0.7071,,,,,,
,,,,,,,,,3,0.5231,,,,,,
,重復性和再現(xiàn)性RepeatabilityandReproducibility(R&R),,,,,,,,,,,,,,,
,,,,,,,,,"零件數(shù)量
PartQTY",K3,,=,9.50%,,,
,=,0.001242,,,,,,,3,0.5231,,,,,,
,,,,,,,,,4,0.4467,,,,,,
,,,,,,,,,5,0.4043,,,,,,
,零件變差PartsVariation(PV),,,,,,,,6,0.3742,,,,,,
,,,,,,公式AFormulaA,,,7,0.3534,,=,99.55%,,,
,=,0.013014,,,,,,,8,0.3375,,,,,,
,,,,,,,,,9,0.3249,,,,,,
,,,,,,,,,10,0.3146,,,,,,
,總變差TotalVariation(TV),,,,,,,,,,有效分辨率AvailabilityResolution(NDC)=1.41*（PV/R&R）,,,,,
,,,,,,,基于零件變差Baseonpartsvariation,,,,,=,15,,,
,=,0.013073,,,,,基于過程變差Baseonprocessvariation,,,,,,,,,
,,,,,,,基于零件公差Baseonpartsspec,,,,,,,,,
,,,,,,,基于過程能力BaseonprocessPP,,,,,,,,,
,判定標準DecideCriterion,,,,,,,,,,,,,,,
1)
0%<%R&R<10%：量測系統(tǒng)狀況良好Excellent；,,,,,,,,,,,判定Decide,,良好Excellent,,,
10%≤%R&R≤30%：量測系統(tǒng)狀況可以接收，但需改進Acceptedbutneedimprovement；,,,,,,,,,,,,,,,,
30%<%R&R<100%：量測系統(tǒng)必須改進Rejectedandmustbeimproved。,,,,,,,,,,,,,,,,
2)數(shù)據(jù)分級數(shù)NDC經(jīng)四舍五入取整后，必須大于或等于5TheNDCistruncatedtotheintegerandoughttobegreaterthanorequalto5。,,,,,,,,,,,,,,,,
"分析評價措施
Analysisandaction",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,分析人Analyst,,,,,日期Date,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,Operator,,#REF!,#REF!,#REF!,,#REF!,,,,,,,
,,,,,,,,,,,,,,,,,
,,,Part-To-Part,,#REF!,#REF!,#REF!,,#REF!,,,,,,,
,,,TotalVariation,,#REF!,#REF!,#REF!,,#REF!,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
測量系統(tǒng)分析MSAGR&R---變差數(shù)分析法ANOVAmethod,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,報告編號ReportNO.,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
"量具名稱
Equipment",,,,,,"產(chǎn)品類型
Description",,,,"測量人員
OperatorＡ",,A,,,"測試日期
TestTate",1899/12/31
,,,,,,,,,,,,,,,,,
"量具編號
EquipmentNO.",,,,,,"基件編號
PartNO.",,,,"測量人員
OperatorＢ",,B,,,"平價人數(shù)
Appraisers",3
,,,,,,,,,,,,,,,,,
"參數(shù)規(guī)格
Specification",,,,,,"規(guī)格上限
Upperlimit",,72,,"測量人員
OperatorＣ",,C,,,"試驗次數(shù)
Trials",3
,,,,,,,,,,,,,,,,,
"測量單位
Unit",,,,MM,,"規(guī)格下限
LowerLimit",,71.4,"過程變差
ProcessVariation(6σ)",,,,,,"樣品數(shù)
Samples",10
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,"方差分析表格
ANOVATable",,,包含With,操作員和零件的相互作用Operator*PartInteraction,,,,,,,,,,,
,"變差來源
Source",,,,"自由DF
Degreeoffreedom",,"平方的總和SS
Sumofsquares",,"平均平方MS
Meansquare",,"F-比率
F-ratio",,有效分辨率AvailabilityResolution(NDC),,,
,零件Parts,,,,9,,0.0186,,0.0021,,524.0166,,,,,
,評價者Operators,,,,2,,0.0000,,0.0000,,5.2473,,,,,
,評價者和零件Operators*Part,,,,18,,0.0001,,0.0000,,3.5193,,,,,
,設(shè)備Equipment,,,,60,,0.0001,,0.0000,,,,13.18741,≈13,,
,匯總Total,,,,89,,0.0188,,,,,,,,,
,,,,,,,,,,,,,,,,,
,"變差來源
Source",,,,"變差估計值
Estimateofvaiance",,"標準偏差
Stdev",,%貢獻率Contribution,,%總變差TV,,%公差Tolerance,,,
,系統(tǒng)TotalGaugeR&R,,,,0.0000,,0.0016,,1.13%,,10.63%,,1.62%,,,
,重復性Repeatability,,,,0.0000,,0.0011,,0.48%,,6.95%,,1.06%,,,
,再現(xiàn)性Reproducibility,,,,0.0000,,0.0012,,0.65%,,8.04%,,1.23%,,,
,評價者Operator,,,,0.0000,,0.0007,,0.24%,,4.91%,,0.
溫馨提示
- 1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會有圖紙預覽，若沒有圖紙預覽就沒有圖紙。
- 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
- 5. 人人文庫網(wǎng)僅提供信息存儲空間，僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護處理，對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對任何下載內(nèi)容負責。
- 6. 下載文件中如有侵權(quán)或不適當內(nèi)容，請與我們聯(lián)系，我們立即糾正。
- 7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。
最新文檔
- 2024年科研機構(gòu)復印紙訂購合同
- 2024年道路照明設(shè)施招投標代理服務(wù)合同3篇
- 2024年駕校場地租賃合同模板
- 2024版常年咨詢財務(wù)顧問合同房地產(chǎn)
- 勞務(wù)派遣項目計劃協(xié)議書
- 勞務(wù)派遣崗位薪資協(xié)議書
- 勞動合同模板（2篇）
- 2024深圳租房合同房屋維修責任
- 2024水電設(shè)施運維勞務(wù)承包合同模板3篇
- 2025年度辦公室改造與智能照明系統(tǒng)安裝合同3篇
- 有關(guān)基建的工作總結(jié)
- 無人機技術(shù)在電信領(lǐng)域的應用
- 2023-2024學年四川省南充市七年級（上）期末數(shù)學試卷（含解析）
- 氮化硅的制備性質(zhì)及應用課件
- 物業(yè)多種經(jīng)營問題分析報告
- 浙江省寧波市鎮(zhèn)海區(qū)2023-2024學年九年級上學期期末數(shù)學試題（含答案）
- 員工健康狀況篩查方案
- 執(zhí)行 如何完成任務(wù)的學問
- 6.2《青紗帳-甘蔗林》【中職專用】（高教版2023基礎(chǔ)模塊下冊）
- 二年級上每日一練(豎式+口算+應用題)已排版直接打印
- 臀部惡性黑色素瘤的個案護理
評論
0/150
提交評論