层次分析法模板方根法.xls

1、准则层对于目标层的判断矩阵及单排序和一致性检验树种选择=A12=A13=A14=A15按行相乘开n次方权重WiAwi经济效益1 3 4 2 24.00002.21340.48210.48212.0705社会效益 1/31 1/2 1/20.08330.53730.11700.11700.4782生态效益 1/42 1 2 1.00001.00000.21780.21780.9386技术要求 1/22 1/21 0.50000.84090.18310.18310.76714.5915准则层对于目标层的判断矩阵及单排序和一致性检验经济效益=A12=A13=A14按行相乘开n次方权重WiAwiAwi

2、/Wi松树1 2 1/70.28570.65860.15700.15700.49883.1769杉树 1/21 1/40.12500.50000.11920.11920.37863.1769桉树7 4 1 28.00003.03660.72380.72382.29953.17694.19523.1769准则层对于目标层的判断矩阵及单排序和一致性检验社会效益=A12=A13=A14按行相乘开n次方权重WiAwiAwi/Wi松树1 1/2 1/50.10000.46420.12200.12200.36653.0037杉树2 1 1/30.66670.87360.22970.22970.68983.

3、0037桉树5 3 1 15.00002.46620.64830.64831.94743.00373.80403.0037准则层对于目标层的判断矩阵及单排序和一致性检验生态效益=A12=A13=A14按行相乘开n次方权重WiAwiAwi/Wi松树1 2 3 6.00001.81710.52780.52781.61183.0536杉树 1/21 3 1.50001.14470.33250.33251.01543.0536桉树 1/3 1/31 0.11110.48070.13960.13960.42643.05363.44263.0536准则层对于目标层的判断矩阵及单排序和一致性检验技术要求=A

4、12=A13=A14按行相乘开n次方权重WiAwiAwi/Wi松树1 1/26 3.00001.44220.38060.38061.19363.1356杉树2 1 4 8.00002.00000.52790.52791.65513.1356桉树 1/6 1/41 0.04170.34670.09150.09150.28693.13563.78893.1356层次总排序计算四准则ai经济效益社会效益 生态效益 技术要求三方案bin0.48210.11700.21780.1831aibin松树0.15700.12200.52780.38060.075680.014278334 0.1149583

5、0.069712杉树0.11920.22970.33250.52790.057452 0.026872853 0.0724192 0.096671桉树0.72380.64830.13960.09150.348919 0.075864968 0.0304141 0.016757层次总排序一致性检验CIi0.0884641 0.001847 0.026811 0.067805CI=aiCIi RI=aiRIi CR=CI/RIRIi0.514910.514910.514910.514910.06110.514910.118696CRi0.1718050.003588 0.052069 0.1316

6、840.118696Awi/WiCI=(-n)/(n-1)CR=CI/RI4.29534.08634.30974.18860.0733225080.082098884.2200CI=(-n)/(n-1)CR=CI/RI0.0884641210.171805016CI=(-n)/(n-1)CR=CI/RI0.0018472990.003587615CI=(-n)/(n-1)CR=CI/RI准则层对于目标层的判断矩阵及单排序和一致性检验0.0268107880.052068882CI=(-n)/(n-1)CR=CI/RI0.0678054220.131684027总排序aibin0.2746289

7、08总权重0.2534157110.471955382准则层对于目标层的判断矩阵及单排序和一致性检验树种选择=A12=A13=A14=A15按行相乘开n次方权重WiAwi经济效益1 3 4 2 24.00002.21340.48210.48212.0705社会效益 1/31 1/2 1/20.08330.53730.11700.11700.4782生态效益 1/42 1 2 1.00001.00000.21780.21780.9386技术要求 1/22 1/21 0.50000.84090.18310.18310.76714.5915准则层对于目标层的判断矩阵及单排序和一致性检验经济效益=A1

8、2=A13=A14按行相乘开n次方权重WiAwiAwi/Wi松树1 2 1/60.33330.69340.14280.14280.42983.0092杉树 1/21 1/90.05560.38160.07860.07860.23653.0092桉树6 9 1 54.00003.77980.77860.77862.34293.00924.85473.0092准则层对于目标层的判断矩阵及单排序和一致性检验社会效益=A12=A13=A14按行相乘开n次方权重WiAwiAwi/Wi松树1 1/2 1/50.10000.46420.12200.12200.36653.0037杉树2 1 1/30.666

9、70.87360.22970.22970.68983.0037桉树5 3 1 15.00002.46620.64830.64831.94743.00373.80403.0037准则层对于目标层的判断矩阵及单排序和一致性检验生态效益=A12=A13=A14按行相乘开n次方权重WiAwiAwi/Wi松树1 2 3 6.00001.81710.52780.52781.61183.0536杉树 1/21 3 1.50001.14470.33250.33251.01543.0536桉树 1/3 1/31 0.11110.48070.13960.13960.42643.05363.44263.0536准则

10、层对于目标层的判断矩阵及单排序和一致性检验技术要求=A12=A13=A14按行相乘开n次方权重WiAwiAwi/Wi松树1 1/26 3.00001.44220.38060.38061.19363.1356杉树2 1 4 8.00002.00000.52790.52791.65513.1356桉树 1/6 1/41 0.04170.34670.09150.09150.28693.13563.78893.1356层次总排序计算四准则ai经济效益社会效益 生态效益 技术要求三方案bin0.48210.11700.21780.1831aibin松树0.14280.12200.52780.38060.

11、068848 0.014278334 0.1149583 0.069712杉树0.07860.22970.33250.52790.037889 0.026872853 0.0724192 0.096671桉树0.77860.64830.13960.09150.375316 0.075864968 0.0304141 0.016757层次总排序一致性检验CIi0.0046014 0.001847 0.026811 0.067805CI=aiCIi RI=aiRIi CR=CI/RIRIi0.514910.514910.514910.514910.02070.514910.040184CRi0.0

12、089362 0.003588 0.052069 0.1316840.040184Awi/WiCI=(-n)/(n-1)CR=CI/RI4.29534.08634.30974.18860.0733225080.082098884.2200CI=(-n)/(n-1)CR=CI/RI0.0046013560.008936234CI=(-n)/(n-1)CR=CI/RI0.0018472990.003587615CI=(-n)/(n-1)CR=CI/RI准则层对于目标层的判断矩阵及单排序和一致性检验0.0268107880.052068882CI=(-n)/(n-1)CR=CI/RI0.067805

13、4220.131684027总排序aibin0.267796624总权重0.2338517410.498351635准则层对于目标层的判断矩阵及单排序和一致性检验树种选择=A12=A13=A14=A15按行相乘开n次方权重WiAwi经济效益1 3 4 2 24.00002.21340.48210.48212.0705社会效益 1/31 1/2 1/20.08330.53730.11700.11700.4782生态效益 1/42 1 2 1.00001.00000.21780.21780.9386技术要求 1/22 1/21 0.50000.84090.18310.18310.76714.591

14、5准则层对于目标层的判断矩阵及单排序和一致性检验经济效益=A12=A13=A14按行相乘开n次方权重WiAwiAwi/Wi松树1 2 1/60.33330.69340.14280.14280.42983.0092杉树 1/21 1/90.05560.38160.07860.07860.23653.0092桉树6 9 1 54.00003.77980.77860.77862.34293.00924.85473.0092准则层对于目标层的判断矩阵及单排序和一致性检验社会效益=A12=A13=A14按行相乘开n次方权重WiAwiAwi/Wi松树1 1/2 1/50.10000.46420.12200

15、.12200.36653.0037杉树2 1 1/30.66670.87360.22970.22970.68983.0037桉树5 3 1 15.00002.46620.64830.64831.94743.00373.80403.0037准则层对于目标层的判断矩阵及单排序和一致性检验生态效益=A12=A13=A14按行相乘开n次方权重WiAwiAwi/Wi松树1 2 3 6.00001.81710.52780.52781.61183.0536杉树 1/21 3 1.50001.14470.33250.33251.01543.0536桉树 1/3 1/31 0.11110.48070.13960

16、.13960.42643.05363.44263.0536准则层对于目标层的判断矩阵及单排序和一致性检验技术要求=A12=A13=A14按行相乘开n次方权重WiAwiAwi/Wi松树1 1/23 1.50001.14470.31960.31960.96473.0183杉树2 1 4 8.00002.00000.55840.55841.68553.0183桉树 1/3 1/41 0.08330.43680.12200.12200.36813.01833.58153.0183层次总排序计算四准则ai经济效益社会效益 生态效益 技术要求三方案bin0.48210.11700.21780.1831aibin松树0.14280.12200.52780.31960.068848 0.014278334 0.1149583 0.058535杉树0.07860.22970.33250.55840.037889 0.026872853 0.07241920.10227桉树0.77860.64830.13960.12200.375316 0.075864968 0.0304141 0.022335层次总排