层次分析法模板例题.xls

准则层对于目标层的判断矩阵及单排序和一致性检验树种选择=A12=A13=A14=A15按行相乘开n次方权重Wi经济效益1 3 4 2 24.00002.21340.48210.4821社会效益 1/31 1/2 1/20.08330.53730.11700.1170生态效益 1/42 1 2 1.00001.00000.21780.2178技术要求 1/22 1/21 0.50000.84090.18310.18314.5915准则层对于目标层的判断矩阵及单排序和一致性检验经济效益=A12=A13=A14按行相乘开n次方权重WiAwi松树1 2 1/70.28570.65860.15700.15700.4988杉树 1/21 1/40.12500.50000.11920.11920.3786桉树7 4 1 28.00003.03660.72380.72382.29954.1952准则层对于目标层的判断矩阵及单排序和一致性检验社会效益=A12=A13=A14按行相乘开n次方权重WiAwi松树1 1/2 1/50.10000.46420.12200.12200.3665杉树2 1 1/30.66670.87360.22970.22970.6898桉树5 3 1 15.00002.46620.64830.64831.94743.8040准则层对于目标层的判断矩阵及单排序和一致性检验生态效益=A12=A13=A14按行相乘开n次方权重WiAwi松树1 2 3 6.00001.81710.52780.52781.6118杉树 1/21 3 1.50001.14470.33250.33251.0154桉树 1/3 1/31 0.11110.48070.13960.13960.42643.4426准则层对于目标层的判断矩阵及单排序和一致性检验技术要求=A12=A13=A14按行相乘开n次方权重WiAwi松树1 1/26 3.00001.44220.38060.38061.1936杉树2 1 4 8.00002.00000.52790.52791.6551桉树 1/6 1/41 0.04170.34670.09150.09150.28693.7889层次总排序计算四准则ai经济效益社会效益 生态效益 技术要求三方案bin0.48210.11700.21780.1831aibin松树0.15700.12200.52780.38060.075680.014278334 0.1149583杉树0.11920.22970.33250.52790.057452 0.026872853 0.0724192桉树0.72380.64830.13960.09150.348919 0.075864968 0.0304141层次总排序一致性检验CIi0.0884641 0.001847 0.026811 0.067805CI=aiCIi RI=aiRIiRii(与n有关的常数）0.514910.514910.514910.514910.06110.51491CRi0.1718050.003588 0.052069 0.131684AwiAwi/WiCI=(-n)/(n-1)CR=CI/RI2.07054.29530.47824.08630.93864.30970.76714.18860.0733225080.082098884.2200Awi/WiCI=(-n)/(n-1)CR=CI/RI3.17693.17693.17693.17690.0884641210.171805016Awi/WiCI=(-n)/(n-1)CR=CI/RI3.00373.00373.00373.00370.0018472990.003587615Awi/WiCI=(-n)/(n-1)CR=CI/RI3.05363.05363.0536准则层对于目标层的判断矩阵及单排序和一致性检验3.05360.0268107880.052068882Awi/WiCI=(-n)/(n-1)CR=CI/RI3.13563.13563.13563.13560.0678054220.131684027总排序aibin0.0697120.274628908总权重0.0966710.2534157110.0167570.471955382CR=CI/RI0.1186960.118696准则层对于目标层的判断矩阵及单排序和一致性检验树种选择=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/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.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.13960.42643.05363.44263.0536准则层对于目标层的判断矩阵及单排序和一致性检验技术要求=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.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.0089362 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.0678054220.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.5915准则层对于目标层的判断矩阵及单排序和一致性检验经济效益=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.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.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层次总排序一致性检验CIi0.0046014 0.001847 0.026811 0.009147CI=aiCIi RI=aiRIi CR=CI/RIRIi0.514910.514910.514910.514910.00990.514910.019321CRi0.0089362 0.003588 0.052069 0.0177650.019321Awi/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.0091473540.017764956总排序aibin0.256619586总权重0.2394505310.503929884