AHP層次分析法-EXCEL表格自動(dòng)計(jì)算

1、 AHPAHP層層次次分分析析法法計(jì)計(jì)算算表表格格(3,5,6階算術(shù)平均法和平方根法)說(shuō)明：1.本表采用了算術(shù)平均法和平方根法的計(jì)算原理。2.分別進(jìn)行了，3、5、6階的計(jì)算表格，其余階數(shù)可理解計(jì)算公式后自行添加?？蛇M(jìn)行權(quán)重計(jì)算和一致性驗(yàn)算。3.在計(jì)算過(guò)程中，由于計(jì)算數(shù)度的關(guān)系與某些網(wǎng)絡(luò)文獻(xiàn)的計(jì)算數(shù)據(jù)有細(xì)微偏差，對(duì)不影響最終方案判斷。4.本表是作者本人在學(xué)習(xí)過(guò)程中，進(jìn)行整理和編輯的，供與需要者共享，但請(qǐng)注明本人對(duì)本文件的著作權(quán)，謝謝。5.本人聯(lián)系郵箱:，歡迎討論。AHPAHP層層次次分分析析法法- -算算術(shù)術(shù)平平均均法法計(jì)算步驟判斷矩陣備注初始矩陣AC1C2C3C11 1 7 9 C2 1/71

2、 1 3 C3 1/9 1/31 1 階數(shù)n=3此矩陣為3階1列和1.2548.33313.0002列歸一0.7970.8400.6920.1140.1200.2310.0890.0400.0771.00001.00001.0000作檢驗(yàn)，防止計(jì)算出錯(cuò)3行和2.32980.46470.20554行歸一0 0. .7 77 77 70 0. .1 15 55 50 0. .0 06 69 9權(quán)重向量近似解5A.W12.4770.4710.206求比值3.19023.04313.01316max3 3. .0 08 82 27C.I.0.04118R.I.0.580R.I.值可根據(jù)階數(shù)自動(dòng)查找9C

3、.R.0 0. .0 07 70 08 80.1具具有有滿滿意意的的一一致致性性CR0.1可視為滿足一致性，反之則應(yīng)調(diào)整計(jì)算矩陣說(shuō)明：1 表中涂黃部分需要手動(dòng)輸入，其余均有自動(dòng)公式計(jì)算。AHPAHP層層次次分分析析法法- -算算術(shù)術(shù)平平均均法法計(jì)算步驟計(jì)算矩陣備注初始表格AC1C2C3C4C5C11 1 2 7 5 5 C2 1/21 1 4 3 3 C3 1/7 1/41 1 1/2 1/3C4 1/5 1/32 1 1 1 C5 1/5 1/33 1 1 1 階數(shù)n=5此矩陣為5階1列和2.0433.91717.00010.50010.3332列歸一0.48950.51060.41180.

4、47620.48390.24480.25530.23530.28570.29030.06990.06380.05880.04760.03230.09790.08510.11760.09520.09680.09790.08510.17650.09520.09683行和2.37201.31140.27250.49270.55154行歸一0 0. .4 47 74 40 0. .2 26 62 20 0. .0 05 54 40 0. .0 09 99 90 0. .1 11 10 0權(quán)重向量近似解5A.W12.42461.34390.27390.50010.5546求比值5.11085.12415

5、.02585.07575.02836max5 5. .0 07 72 29 97C.I.0.01828R.I.1.120R.I.值可根據(jù)階數(shù)自動(dòng)查找9C.R.0 0. .0 01 16 60.1CR0.1可視為滿足一致性，反之則應(yīng)調(diào)整計(jì)算矩陣說(shuō)明：1 表中涂黃部分需要手動(dòng)輸入，其余均有自動(dòng)公式計(jì)算。AHPAHP層層次次分分析析法法- -算算術(shù)術(shù)平平均均法法計(jì)算步驟判斷矩陣備注初始矩陣AC1C2C3C4C5C6C11 1 1 1 1 1 1/2C21 1 1 2 4 1 1/2C31 1/21 1 5 3 1/2C41 1/4 1/51 1 1/3 1/3C51 1 1/33 1 1 1 C62

6、 2 2 3 1 1 1 階數(shù)n=6此矩陣為6階1列和7.0005.7506.53317.0617.3303.8302列歸一0.14290.17390.15310.05860.13640.13050.14290.17390.30610.23450.13640.13050.14290.08700.15310.29310.40930.13050.14290.04350.03060.05860.04500.08620.14290.17390.05100.17760.13640.26110.28570.34780.30610.17760.13640.26111.00001.00001.00001.00

7、001.00001.0000作檢驗(yàn)，防止計(jì)算出錯(cuò)3行和0.79541.12431.21580.40670.94291.51484行歸一0 0. .1 13 33 30 0. .1 18 87 70 0. .2 20 03 30 0. .0 06 68 80 0. .1 15 57 70 0. .2 25 52 2權(quán)重向量近似解5A.W10.8741.2801.3660.4231.0031.660求比值6.59106.82956.73926.23846.37946.57606max6 6. .5 55 59 97C.I.0.11188R.I.1.240R.I.值可根據(jù)階數(shù)自動(dòng)查找9C.R.0 0

8、. .0 09 90 00.1具具有有較較滿滿意意一一致致性性CR0.1可視為滿足一致性，反之則應(yīng)調(diào)整計(jì)算矩陣說(shuō)明：1 表中涂黃部分需要手動(dòng)輸入，其余均有自動(dòng)公式計(jì)算。目目標(biāo)標(biāo)層層排排序序計(jì)計(jì)算算計(jì)算步驟計(jì)算內(nèi)容1第二層權(quán)重矩陣BX1X2X3X4X5X60.1600.1900.1900.0500.1200.300C1C2C32P10.1370.6230.239P20.0980.3340.568P30.2590.1060.635P40.1560.6200.224P50.4670.4670.067P60.7900.1330.0772第三層權(quán)重矩陣轉(zhuǎn)置P1P2P3P4P5P60.1370.0980.

9、2590.1560.4670.7900.6230.3340.1060.6200.4670.1330.2390.5680.6350.2240.0670.0773綜合權(quán)重C1C2C30.3910.3100.3094最終優(yōu)選0 0. .3 39 91 1備注由AHP計(jì)算得到，手動(dòng)粘貼由AHP計(jì)算得到，手動(dòng)粘貼因使用函數(shù)，必須轉(zhuǎn)置=BP(矩陣左乘）得到最終排序目目標(biāo)標(biāo)層層排排序序計(jì)計(jì)算算AHPAHP層層次次分分析析法法- -方方根根法法（幾幾何何平平均均）計(jì)算步驟判斷矩陣備注初始矩陣AC1C2C31-按行相乘后，開(kāi)n次方C11 1 7 9 3.98C2 1/71 1 3 0.75C3 1/9 1/31

10、 1 0.33階數(shù)n=3此矩陣為6階3行和3.9790.7540.3334行歸一0 0. .7 78 85 50 0. .1 14 49 90 0. .0 06 66 6權(quán)重向量近似解5A.W12.4190.4580.203求比值3.08033.08033.08036max3 3. .0 08 80 07C.I.0.04018R.I.0.580R.I.值可根據(jù)階數(shù)自動(dòng)查找9C.R.0 0. .0 06 69 92 20.1具具有有滿滿意意一一致致性性CR0.1可視為滿足一致性，反之則應(yīng)調(diào)整計(jì)算矩陣說(shuō)明：1 表中涂黃部分需要手動(dòng)輸入，其余均有自動(dòng)公式計(jì)算。AHPAHP層層次次分分析析法法- -方

11、方根根法法（幾幾何何平平均均）計(jì)算步驟判斷矩陣備注初始矩陣AC1C2C3C4C51-按行相乘后，開(kāi)n次方C11 1 2 7 5 5 3.23C2 1/21 1 4 3 3 1.78C3 1/7 1/41 1 1/2 1/30.36C4 1/5 1/32 1 1 1 0.67C51 1/33 1 1 1 1.00階數(shù)n=5此矩陣為5階3行和3.2271.7830.3580.6681.0027.0384行歸一0 0. .4 45 59 90 0. .2 25 53 30 0. .0 05 51 10 0. .0 09 95 50 0. .1 14 42 2權(quán)重向量近似解5A.W12.5081.39

12、80.2740.5150.934求比值5.46965.51995.38785.42596.56376max5 5. .6 67 73 37C.I.0.16838R.I.1.120R.I.值可根據(jù)階數(shù)自動(dòng)查找9C.R.0 0. .1 15 50 00.1不不滿滿足足一一致致性性CR0.1可視為滿足一致性，反之則應(yīng)調(diào)整計(jì)算矩陣說(shuō)明：1 表中涂黃部分需要手動(dòng)輸入，其余均有自動(dòng)公式計(jì)算。AHPAHP層層次次分分析析法法- -方方根根法法（幾幾何何平平均均）計(jì)算步驟判斷矩陣備注初始矩陣AC1C2C3C4C5C61-按行相乘后，開(kāi)n次方C11 1 1 1 4 1 1/21.12C21 1 1 2 4 1

13、1/21.26C31 1/21 1 5 3 1/21.25C4 1/4 1/4 1/51 1 1/3 1/30.33C51 1 1/33 1 1 1 1.00C62 2 2 3 1 1 1 1.70階數(shù)n=6此矩陣為6階3行和1.1221.2601.2460.3331.0021.7016.6654行歸一0 0. .1 17 70 0. .1 19 90 0. .1 19 90 0. .0 05 50 0. .1 15 50 0. .2 26 6權(quán)重向量近似解5A.W11.0221.2091.2780.3110.9771.646求比值6.06956.39666.83476.21726.49876

14、.44796max6 6. .4 41 11 17C.I.0.08228R.I.1.240R.I.值可根據(jù)階數(shù)自動(dòng)查找9C.R.0 0. .0 06 66 60.1具具有有較較滿滿意意一一致致性性CR0.1可視為滿足一致性，反之則應(yīng)調(diào)整計(jì)算矩陣說(shuō)明：1 表中涂黃部分需要手動(dòng)輸入，其余均有自動(dòng)公式計(jì)算。目目標(biāo)標(biāo)層層排排序序計(jì)計(jì)算算計(jì)算步驟計(jì)算內(nèi)容1第二層權(quán)重矩陣BX1X2X3X4X5X60.1600.1900.1900.0500.1200.300C1C2C32P10.1360.6250.238P20.0970.3330.570P30.2570.1050.638P40.2780.6500.072P

15、50.4670.4670.067P60.7720.1730.0552第三層權(quán)重矩陣轉(zhuǎn)置P1P2P3P4P5P60.1360.0970.2570.2780.4670.7720.6250.3330.1050.6500.4670.1730.2380.5700.6380.0720.0670.0553綜合權(quán)重C1C2C30.3910.3240.2964最終優(yōu)選0 0. .3 39 91 1備注由AHP計(jì)算得到，手動(dòng)粘貼由AHP計(jì)算得到，手動(dòng)粘貼因使用函數(shù)，必須轉(zhuǎn)置=BP(矩陣左乘）得到最終排序目目標(biāo)標(biāo)層層排排序序計(jì)計(jì)算算一致性檢驗(yàn)表階數(shù)最大特征值C.I.R.I.C.R.一致性檢驗(yàn)nmax101,2階無(wú)需檢驗(yàn)2030.58040.90051.12061.24071.32081.41091.460101.490111.520121.540131.560141.580151.580說(shuō)明：1 此表用于簡(jiǎn)便一致性檢驗(yàn)。2 表中僅需對(duì)涂黃部分進(jìn)行填寫max即可。計(jì)算表格階數(shù)123456789101112131415RI000.580.91.121.241.321.411.461.491.521.5