层次分析法确定评价指标权重及Excel计算

February20122Excel。Excel。■ExcelAnalytichierarchyprocessAHPT.L.Saaty2070、。AHP[1]、[2]、[3]、[4]。AHP。AHP。1.n。“7±2”AHP1。Aaijij。Aaij＞0aii＝1aij＝1/ajiij=1,2,…n。A1。n(n-1)/2。27Excel。2.A。Aλmax,W,AW=λmaxW。AHP1λmaxw。①Mi=nj=1仪bij,i=1,2,...,n。②MinW軘i=Min姨。③w=W軘1,W軘2,...,W軘n姨姨Twi=W軘ini=1ΣW軘iw。④λmax=1nni=1Σ(AW)iwi。2。AHP。。975311/31/51/71/98,6,4,2,1/2,1/4,1/6,1/81EIE1E2E3E4E5E6E7E111131/31/41/2E211131/31/31/2E311131/31/31/4E41/31/31/311/61/61/4E53336132E643361/312E722441/21/2139February20121Excel3RI。CI=λmax-nn-1。RI。1～15RI3RI[5]。2CR=CI/RI0.10。3.AHPExcelExcelB3:H92。1。J3“=B3*C3*D3*E3*F3*G3*H3”J9Mi。2MinW軘i。K3“=J3^(1/7)”K9。K11“=SUM(K3:K9)”W軘i。3wi。L3“=K3/$K$11”L9。4λmax。B11:B17“=MMULT(B3:H9,L3:L9)”“F2”“Ctrl+Shift+Enter”。C11“=B11/L3/7”C17。E11“=SUM(C11:C17)”λmax。5。E12“=(E11-7)/(7-1)”CI=0.0458。3n=7RI=1.36CR=0.0458/1.36=0.0337＜0.101。4.AHP、、、。AHP[6]。ExcelExcel。ExcelWord、SPSS。ExcelAHP。“SUM”“MMULT”Excel。[1].[J].20095:2418-2425.[2].[J].2011189-94.[3].[J].20082:74-79.[4]QianYuHuangZhixianYanZhiguo.IntegratedAssessmentofEnvironmentalandEconomicPerformanceofChemicalProductsUsingAnalyticHi-erarchyProcessApproach[J].ChineseJournalofChemicalEngineering20071:81-87.[5].(RI)[J].200212:45-47.[6].[J].200720:5204-5207.n123456789101112131415RI000.520.891.121.261.361.411.461.491.521.541.561.581.5940