版權(quán)說明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請進行舉報或認領(lǐng)
文檔簡介
測量系統(tǒng)分析MSAGR&R---數(shù)據(jù)記錄表DataWorksheet,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,報告編號ReportNO.,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
"量具名稱
EquipmentName",,,,X-Ray測厚儀,,"產(chǎn)品類型
Description",,,,"測量人員
OperatorA",,,,"測試日期
TestTate",,
,,,,,,,,,,,,,,,,,
"量具編號
EquipmentNO.",,,,,,"基件編號
P/N",,,,"測量人員
OperatorB",,,,"平價人數(shù)
Appraisers",,3
,,,,,,,,,,,,,,,,,
"參數(shù)規(guī)格
Dimension",,,,15,,"規(guī)格上限
USL",,16,,"測量人員
OperatorC",,,,"試驗次數(shù)
Trials",,3
,,,,,,,,,,,,,,,,,
"單位
Unit",,,,um,,"規(guī)格下限
LSL",,14,"過程變差/過程能力
ProcessVariation(σ/PP)",,,,,"樣品數(shù)
Samples",,10
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
分析時機AnalyticalOccasion,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
零件編號PartsNO.,,,,1,2,3,4,5,6,7,8,9,10,Total,平均值A(chǔ)verage,
1.,A,,1,15.220,14.400,15.240,14.820,15.250,15.470,14.970,15.170,14.820,15.420,150.78,15.078000,
2.,,,2,15.310,14.370,15.230,14.730,15.240,15.460,14.870,15.240,14.770,15.330,150.55,15.055000,
3.,,,3,15.320,14.370,15.110,14.870,15.370,15.350,14.910,15.130,14.770,15.310,150.51,15.051000,
4.,,,均值Mean,15.28333,14.38000,15.19333,14.80667,15.28667,15.42667,14.91667,15.18000,14.78667,15.35333,,,15.061333
,,,SumA,45.85,43.14,45.58,44.42,45.86,46.28,44.75,45.54,44.36,46.06,451.8400,,
5.,,,極差Range,0.1,0.03,0.13,0.14,0.13,0.12,0.1,0.11,0.05,0.11,,,0.102000
6.,B,,1,15.440,14.920,15.320,14.820,15.450,15.220,14.870,15.340,14.820,15.440,151.64,15.164000,
7.,,,2,15.320,14.880,15.210,14.730,15.360,15.250,14.770,15.350,14.710,15.370,11.304,15.095000,
8.,,,3,15.470,14.910,15.240,14.710,15.470,15.320,14.730,15.280,14.730,15.420,151.28,15.128000,
9.,,,均值Mean,15.41000,14.90333,15.25667,14.75333,15.42667,15.26333,14.79000,15.32333,14.75333,15.41000,,,15.129000
,,,SumB,46.23,44.71,45.77,44.26,46.28,45.79,44.37,45.97,44.26,46.23,453.8700,,
10.,,,極差Range,0.15,0.04,0.11,0.11,0.11,0.1,0.14,0.07,0.11,0.07,,,0.101000
11.,C,,1,15.440,14.910,15.320,14.820,15.290,15.280,14.820,15.310,14.820,15.420,151.43,15.143000,
12.,,,2,15.420,14.870,15.410,14.780,15.310,15.280,14.780,15.270,14.770,15.510,151.4,15.140000,
13.,,,3,15.370,14.920,15.330,14.840,15.360,15.330,14.750,15.290,14.730,15.480,151.4,15.140000,
14.,,,均值Mean,15.41000,14.90000,15.35333,14.81333,15.32000,15.29667,14.78333,15.29000,14.77333,15.47000,,,15.141000
,,,SumC,46.23,44.7,46.06,44.44,45.96,45.89,44.35,45.87,44.32,46.41,454.23,,
15.,,,極差Range,0.07,0.05,0.09,0.06,0.07,0.05,0.07,0.04,0.09,0.09,,,0.068000
"零件均值
PartsMean",,,,15.367778,14.727778,15.267778,14.791111,15.344444,15.328889,14.830000,15.264444,14.771111,15.411111,,,15.110444
Total,,,,138.310000,132.550000,137.410000,133.120000,138.100000,137.960000,133.470000,137.380000,132.940000,138.700000,1359.94,,0.683333
,,,,,,,,0.090333,,,,試驗次數(shù)Trials,,,2,3
,,,,,,,,0.079667,,,,,,D4,3.267,2.575
,,,,,,15.202855,,,,,0.232608,,,D3,0,0
,,,,,,15.018033,,,,,0.000000,,,A2,1.88,1.023
"注:當分析結(jié)果超出要求后,利用均值極差圖分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。",,,,,,,,,,,,,,,,
"均值圖
meanchart",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,1,2,3,4,5,6,7,8,9,10,,,
,,,UCLx,15.2029,15.2029,15.2029,15.2029,15.2029,15.2029,15.2029,15.2029,15.2029,15.2029,,,
,,,LCLx,15.0180,15.0180,15.0180,15.0180,15.0180,15.0180,15.0180,15.0180,15.0180,15.0180,,,
,,,UCLR,0.2326,0.2326,0.2326,0.2326,0.2326,0.2326,0.2326,0.2326,0.2326,0.2326,,,
,,,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.214977,,,PV,0.214977,,0.214977,PV,0.214977,,,
,,,,TV,0.333333,,,TV,0.000000,,#DIV/0!,TV,0.225178,,,基于公差baseonpartsspec
,,%EV,,,16.01%,,,,#DIV/0!,,#DIV/0!,,23.70%,,,基于零件變差baseonpartsvariation
,,%AV,,,12.16%,,,,#DIV/0!,,#DIV/0!,,17.99%,,,基于過程變差baseonprocessvariation
,,%RR,,,20.10%,,,,#DIV/0!,,#DIV/0!,,29.76%,,,基于過程能力BaseonprocessPP
,,%PV,,,64.49%,,,,#DIV/0!,,#DIV/0!,,95.47%,,,公式AFormulaA
,,,,ndc,4.523635354,,,,,,,,,,,公式BFormulaB
,,,,X^2/nkr,20549.2978178,,sumSQ(sum(men))/nr,,,20549.4085133,SUMSQ(sum(1-10part))/kr,,,20556.0457333,,
"極差圖
Rangechart",,SUMSQ(sum(men-part))/r,,,,20556.8340667,,sumSQ(all),,20556.9886000,,,,n=partk=menr=time,,
,,,ANOVATableWithOperator*PartInteraction,,,,,,,ANOVATableWithoutOperator*PartInteraction,,,,,,
,,,Source,,DF,SS,MS,F,P,Source,,DF,SS,MS,F,P
,,,Parts,,9,6.74792,0.74977,19.91600,0.00000,Parts,,9,6.74792,0.74977,70.27633,0.00000
,,,Operators,,2,0.11070,0.05535,1.47020,0.25621,Operators,,2,0.11070,0.05535,5.18779,0.00739
,,,Operators*Part,,18,0.67764,0.03765,14.61686,0.00000,,,,,,,
,,,Repeatability,,60,0.15453,0.00258,,,Repeatability,,78,0.83217,0.01067,,
,,,Total,,89,7.69078,,,,Total,,89,7.69078,,,
,,,GaugeR&RWithOperator*PartInteraction,,,,,,,GaugeR&RWithoutOperator*PartInteraction,,,,,,
,,,Source,,VarComp,Stdev,%Contribution,%TV,%Tolerance,Source,,VarComp,Stdev,%Contribution,%TV,%Tolerance
,,,TotalGaugeR&R,,0.01486,0.12188,15.81%,39.76%,36.57%,TotalGaugeR&R,,0.01216,0.11026,12.90%,35.91%,33.08%
,,,Repeatability,,0.00258,0.05075,2.74%,16.55%,15.22%,Repeatability,,0.01067,0.10329,11.32%,33.64%,30.99%
,,,Reproducibility,,0.01228,0.11082,13.07%,36.15%,33.25%,Reproducibility,,0.00149,0.03859,1.58%,12.57%,11.58%
,,,Operator,,0.00059,0.02429,0.63%,7.92%,7.29%,Operator,,0.00149,0.03859,1.58%,12.57%,11.58%
,,,Operators*Part,,0.01169,0.10812,12.44%,35.27%,32.44%,,,,,,,
,,,Part-To-Part,,0.07912,0.28129,84.19%,91.76%,84.39%,Part-To-Part,,0.08212,0.28657,87.10%,93.33%,85.97%
,,,TotalVariation,,0.09398,0.30656,100.00%,100.00%,91.97%,TotalVariation,,0.09428,0.30705,100.00%,100.00%,92.12%
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
測量系統(tǒng)分析MSAGR&R---均值極差法Averageandmethod,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,報告編號ReportNO.,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
"量具名稱
Equipment",,,,X-Ray測厚儀,,"產(chǎn)品類型
Description",,,,"測量人員
OperatorA",,,,,"測試日期
TestTate",
,,,,,,,,,,,,,,,,,
"量具編號
EquipmentNO.",,,,,,"基件編號
PartNO.",,,,"測量人員
OperatorB",,,,,"平價人數(shù)
Appraisers",3
,,,,,,,,,,,,,,,,,
"參數(shù)規(guī)格
Specification",,,,15,,"規(guī)格上限
Upperlimit",,16,,"測量人員
OperatorC",,,,,"試驗次數(shù)
Trials",3
,,,,,,,,,,,,,,,,,
"測量單位
Unit",,,,um,,"規(guī)格下限
LowerLimit",,14,"過程變差/過程能力
ProcessVariation(σ/PP)",,,,,,"樣品數(shù)
Samples",10
,,,,,,,,,,,,,,,,,
Datasheet:,,,,,0.090333,,,0.079667,,,0.683333,,,,,
,,,,,,,,,,,分析方式Analysismode,基于零件變差baseonpartsvariation,,,,
,測量系統(tǒng)分析MSA,,,,,,,,,,%總變差Totalvariation(TV),,,,,
,重復(fù)性Repeatability-設(shè)備變差EquipmentVariation(EV),,,,,,,,,,,,,,,
,,,,,,,,,,,,=,23.70%,,,
,=,0.053369,,,,,,,"試驗次數(shù)
Trials",K1,,,,,,
,,,,,,,,,2,0.8862,,,,,,
,,,,,,,,,3,0.5908,,,,,,
,再現(xiàn)性Reproducibility-評價人變差A(yù)ppraiserVariation(AV),,,,,,,,,,,,,,,
,,,,,,,,,,,,=,17.99%,,,
,=,0.040519,#DIV/0!,#DIV/0!,,,,,"評價人數(shù)
Appraisers",K2,,,,,,
,,,,,,,,,2,0.7071,,,,,,
,,,,,,,,,3,0.5231,,,,,,
,重復(fù)性和再現(xiàn)性RepeatabilityandReproducibility(R&R),,,,,,,,,,,,,,,
,,,,,,,,,"零件數(shù)量
PartQTY",K3,,=,29.76%,,,
,=,0.067007,,,,,,,3,0.5231,,,,,,
,,,,,,,,,4,0.4467,,,,,,
,,,,,,,,,5,0.4043,,,,,,
,零件變差PartsVariation(PV),,,,,,,,6,0.3742,,,,,,
,,,,,,公式AFormulaA,,,7,0.3534,,=,95.47%,,,
,=,0.214977,,,,,,,8,0.3375,,,,,,
,,,,,,,,,9,0.3249,,,,,,
,,,,,,,,,10,0.3146,,,,,,
,總變差TotalVariation(TV),,,,,,,,,,有效分辨率AvailabilityResolution(NDC)=1.41*(PV/R&R),,,,,
,,,,,,,基于零件變差Baseonpartsvariation,,,,,=,5,,,
,=,0.225178,,,,,基于過程變差Baseonprocessvariation,,,,,,,,,
,,,,,,,基于零件公差Baseonpartsspec,,,,,,,,,
,,,,,,,基于過程能力BaseonprocessPP,,,,,,,,,
,判定標準DecideCriterion,,,,,,,,,,,,,,,
1)
0%<%R&R<10%:量測系統(tǒng)狀況良好Excellent;,,,,,,,,,,,判定Decide,,可接收Accepted,,,
10%≤%R&R≤30%:量測系統(tǒng)狀況可以接收,但需改進Acceptedbutneedimprovement;,,,,,,,,,,,,,,,,
30%<%R&R<100%:量測系統(tǒng)必須改進Rejectedandmustbeimproved。,,,,,,,,,,,,,,,,
2)數(shù)據(jù)分級數(shù)NDC經(jīng)四舍五入取整后,必須大于或等于5TheNDCistruncatedtotheintegerandoughttobegreaterthanorequalto5。,,,,,,,,,,,,,,,,
"分析評價措施
Analysisandaction",,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,分析人Analyst,,Lake_dong,,,日期Date,2011/11/1,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,,,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",,,,X-Ray測厚儀,,"產(chǎn)品類型
Description",,,,"測量人員
OperatorA",,,,,"測試日期
TestTate",1899/12/31
,,,,,,,,,,,,,,,,,
"量具編號
EquipmentNO.",,,,,,"基件編號
PartNO.",,,,"測量人員
OperatorB",,,,,"平價人數(shù)
Appraisers",3
,,,,,,,,,,,,,,,,,
"參數(shù)規(guī)格
Specification",,,,15,,"規(guī)格上限
Upperlimit",,16,,"測量人員
OperatorC",,,,,"試驗次數(shù)
Trials",3
,,,,,,,,,,,,,,,,,
"測量單位
Unit",,,,um,,"規(guī)格下限
LowerLimit",,14,"過程變差
ProcessVariation(6σ)",,,,,,"樣品數(shù)
Samples",10
,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,
,"方差分析表格
ANOVATable",,,包含With,操作員和零件的相互作用Operator*PartInteraction,,,,,,,,,,,
,"變差來源
Source",,,,"自由DF
Degreeoffreedom",,"平方的總和SS
Sumofsquares",,"平均平方MS
Meansquare",,"F-比率
F-ratio",,有效分辨率AvailabilityResolution(NDC),,,
,零件Parts,,,,9,,6.7479,,0.7498,,19.9160,,,,,
,評價者Operators,,,,2,,0.1107,,0.0553,,1.4702,,,,,
,評價者和零件Operators*Part,,,,18,,0.6776,,0.0376,,14.6169,,,,,
,設(shè)備Equipment,,,,60,,0.1545,,0.0026,,,,3.25406,≈3,,
,匯總Total,,,,89,,7.6908,,,,,,,,,
,,,,,,,,,,,,,,,,,
,"變差來源
Source",,,,"變差估計值
Estimateofvaiance",,"標準偏差
Stdev",,%貢獻率Contribution,,%總變差TV,,%公差Tolerance,,,
,系統(tǒng)TotalGaugeR&R,,,,0.0149,,0.1219,,15.81%,,39.76%,,36.57%,,,
,重復(fù)性Repeatability,,,,0.0026,,0.0507,,2.74%,,16.55%,,15.22%,,,
,再現(xiàn)性Reproducibility,,,,0.0123,,0.1108,,13.07%,,36.15%,,33.25%,,,
,評價者Operator,,,,0.0006,,0.0243,,0.63%,,7.92%,,7.29%,,,
,相互作用InteractionINT=0,,,,0,,0,,
溫馨提示
- 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
- 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. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。
最新文檔
- 桂平市九年級上學期語文期中考試卷
- 八年級上學期語文11月期中考試試卷
- 風電專業(yè)考試題庫帶答案
- 四年級數(shù)學(三位數(shù)乘兩位數(shù))計算題專項練習及答案
- 自建房安裝水電合同范本(2篇)
- 激勵作業(yè)課件教學課件
- 南京航空航天大學《電視節(jié)目攝像與編輯實踐》2022-2023學年第一學期期末試卷
- 南京工業(yè)大學浦江學院《數(shù)據(jù)結(jié)構(gòu)課程設(shè)計》2021-2022學年期末試卷
- 電機集團鋼結(jié)構(gòu)廠房三期施工組織設(shè)計
- 法律為我們護航說課稿
- 2023年天津公務(wù)員已出天津公務(wù)員考試真題
- 2025年高考數(shù)學專項題型點撥訓練之初等數(shù)論
- 教科版三年級科學上冊《第1單元第1課時 水到哪里去了》教學課件
- 國際貿(mào)易術(shù)語2020
- 國網(wǎng)新安規(guī)培訓考試題及答案
- 黑龍江省哈爾濱市師大附中2024-2025學年高一上學期10月階段性考試英語試題含答案
- 第六單元測試卷-2024-2025學年統(tǒng)編版語文三年級上冊
- 【課件】Unit4+Section+B+(Project)課件人教版(2024)七年級英語上冊
- 青少年法治教育實踐基地建設(shè)活動實施方案
- 綠化養(yǎng)護續(xù)簽合同申請書范文
- 教科(2024秋)版科學三年級上冊2.6 我們來做“熱氣球”教學設(shè)計
評論
0/150
提交評論