用电子表格(Excel)实现层次分析法(AHP)的简捷计算

2019-04-02 11:05

AB1B2B3B1C1C2C1D1D2C4D1D2B11B21/31B31/311C31C431D2131D211/51C11C2B21C31C4C25D11D2C57D11D2D11D2D1D11D2D1计算

判断矩阵B1B211/33131权重向量Wi∏aij开N次方0.110.48073.001.44223.001.44223.3652AB1B2B3B31/311B1C1C2判断矩阵C111C211权重向量Wi∏aij开N次方权重Wi1.001.00000.50001.001.00000.50002.0000权重向量Wi∏aij开N次方权重Wi3.001.73210.75000.330.57740.25002.3094权重向量Wi∏aij开N次方权重Wi3.001.73210.75000.330.57740.25002.3094B2C3C4判断矩阵C311/3C431B3C5C6判断矩阵C511/3C631C1D1D2判断矩阵D111/5D251权重向量Wi∏aij开N次方权重Wi5.002.23610.83330.200.44720.16672.6833权重向量Wi∏aij开N次方权重Wi3.001.73210.75000.330.57740.25002.3094权重向量Wi∏aij开N次方权重Wi0.200.44720.16675.002.23610.83332.6833权重向量Wi∏aij开N次方权重Wi7.002.64580.87500.140.37800.12503.0237权重向量Wi∏aij开N次方权重Wi0.200.44720.16675.002.23610.83332.6833权重向量Wi∏aij开N次方权重Wi0.330.57740.25003.001.73210.75002.3094单排序

C2D1D2判断矩阵D111/3D231C3D1D2判断矩阵D115D21/51C4D1D2判断矩阵D111/7D271C5D1D2判断矩阵D115D21/51C6D1D2判断矩阵D113D21/31AB1B2B3CRC1

Wi0.14290.42860.42860

B1C1C2CRWi0.50000.50000.0000WiC2

WiD1D2CR0.83330.16670D1D2CR0.75000.25000.0000C5D1D2CR

Wi0.16670.83330

C6D1D2CR总排序

Wi0.25000.75000.0000

B层次总排序(CR = 0.0000)

B1B2B30.14290.42860.4286 C层次总排序(CR = 0.0000)

C10.0714

C20.0714

C30.3214

C40.1071

C50.3214

C60.1071

D层次总排序(CR = 0.0000)

D1D20.34080.6592

B3C5C6C3D1D2C6D1D2C51C631D211/51D211/31D1D1量Wi权重Wi0.14290.42860.4286λmax一致性检验(AW)i(AW)i/WiC.I.R.I.C.R.0.42863.00000.00000.51490.00001.28573.00001.28573.0000λmax=3.0000λmax一致性检验(AW)i(AW)i/WiC.I.R.I.C.R.1.00002.0000-0.83330.00000.00001.00002.0000λmax=1.3333λmax一致性检验(AW)i(AW)i/WiC.I.R.I.C.R.1.50002.0000-0.83330.00000.00000.50002.0000λmax=1.3333λmax一致性检验(AW)i(AW)i/WiC.I.R.I.C.R.1.50002.0000-0.83330.00000.00000.50002.0000λmax=1.3333λmax一致性检验(AW)i(AW)i/WiC.I.R.I.C.R.1.66672.0000-0.83330.00000.00000.33332.0000λmax=1.3333λmax一致性检验(AW)i(AW)i/WiC.I.R.I.C.R.1.50002.0000-0.83330.00000.00000.50002.0000λmax=1.3333λmax一致性检验(AW)i(AW)i/WiC.I.R.I.C.R.0.33332.0000-0.83330.00000.00001.66672.0000λmax=1.3333λmax一致性检验(AW)i(AW)i/WiC.I.R.I.C.R.1.75002.0000-0.83330.00000.00000.25002.0000λmax=1.3333λmax一致性检验(AW)i(AW)i/WiC.I.R.I.C.R.0.33332.0000-0.83330.00000.00001.66672.0000λmax=1.3333λmax一致性检验(AW)i(AW)i/WiC.I.R.I.C.R.0.50002.0000-0.83330.00000.00001.50002.0000λmax=1.3333B2C3C4CRWi0.75000.25000.0000B3C5C6CRWi0.750.250C3

WiC4

Wi


用电子表格(Excel)实现层次分析法(AHP)的简捷计算.doc 将本文的Word文档下载到电脑 下载失败或者文档不完整,请联系客服人员解决!

下一篇:基于流通企业职能的创新型人才需求及其管理

相关阅读
本类排行
× 注册会员免费下载(下载后可以自由复制和排版)

马上注册会员

注:下载文档有可能“只有目录或者内容不全”等情况,请下载之前注意辨别,如果您已付费且无法下载或内容有问题,请联系我们协助你处理。
微信: QQ: