层次分析法Excel演算实验_精品文档表格文件下载.xls

层次分析法Excel演算实验_精品文档表格文件下载.xls

《层次分析法Excel演算实验_精品文档表格文件下载.xls》由会员分享，可在线阅读，更多相关《层次分析法Excel演算实验_精品文档表格文件下载.xls（24页珍藏版）》请在冰豆网上搜索。

28*1/31*1A,D对于A：

20*1/410*1/3A,E对于A：

25*13*1/2A,F对于A：

17*511*3A,G对于A：

29*1/21*1质量A与其他5个因素比较A,B对于A：

30*3A,C对于A：

15*18*1/2A,D对于A：

23*67*5A,E对于A：

30*9A,F对于A：

24*63*5服务水平A与其他4个因素比较20122010200820062004200220000%5%10%15%20%25%30%35%40%45%人员成本食材成本物流成本A,B对于A：

10*110*1/3A,C对于A：

24*43*3A,D对于A：

17*95*5A,E对于A：

19*34*1可追溯性A与其他3个因素比较A,B对于A：

28*61*1A,C对于A：

30*9A,D对于A：

10*610*4总资产A收益率与其他2个因素比较A,B对于A：

15*515*3A,C对于A：

10*1/310*1创新性A与剩下1个因素比较A,B对于A：

5*1/36*1/7外观售后服务按行相乘开5次方权重Wi934053.322699030.50248424721/20.10.6309573440.095418253121.1486983550.1737150511/30.006172840.361490590.0546674033121.1486983550.173715056.6125436751按行相乘开3次方权重WiAwiAwi/Wi0.070.405480.10945230.333.0036951.51.1447140.30899560.933.003695102.1544350.58155211.753.0036953.70462913.003695按行相乘开3次方权重WiAwiAwi/Wi152.4662120740.6483290141.94738243.0036945980.6666666670.8735804650.2296507940.68980083.0036945980.10.4641588830.1220201920.36651143.0036945983.80395142213.003694598按行相乘开3次方权重WiAwiAwi/Wi0.0666666670.4054801330.109452290.328763.0036945981.51.1447142430.3089956440.928133.003694598102.154434690.5815520671.746803.0036945983.70462906613.003694598按行相乘开3次方权重WiAwiAwi/Wi152.4662120740.6483290141.947383.0036945980.10.4641588830.1220201920.366513.0036945980.6666666670.8735804650.2296507940.689803.0036945983.80395142213.003694598按行相乘开3次方权重WiAwiAwi/Wi92.0800838230.60001.80003.00000.3333333330.6933612740.20000.60003.00000.3333333330.6933612740.20000.60003.00003.46680637213.0000选择的目标质量外观售后服务0.0546674030.17371505Ai*bi0.6483290140.60000.0549980510.061862420.019013510.1220201920.20000.1552654430.0219128770.0536771940.2296507940.20000.2922207520.0116429530.1010243460.0018472990C.I.=AiCIR.I.=AiRI0.51490.51490.0015263950.51490.0031849980可追溯性总资产收益率创新关联按行相乘1/4141/20.027777778169658321/247228169521601/6141/20.0138888891/91/411/50.0000220461/52510.333333333按行相乘开3次方权重WiAwiAwi/Wi0.0666666670.4054801330.1047294340.3182223.038511091110.2582849940.7848023.038511091152.4662120740.6369855721.9354883.0385110913.87169220713.038511091按行相乘开3次方权重WiAwiAwi/Wi0.0666666670.4054801330.1047294340.31822153.038511091110.2582849940.78480183.038511091152.4662120740.6369855721.93548773.0385110913.87169220713.038511091按行相乘开3次方权重WiAwiAwi/Wi0.50.7937005260.250.7500003.00000000.50.7937005260.250.7500003.000000041.5874010520.51.5000003.00000003.17480210413.0000000层次总排序一致性检验冷链物流模式选择按行相乘开3次方权重WiAwiAwi/Wi152.4662120740.6369855721.93548773.0385110910.0666666670.4054801330.1047294340.31822153.038511091110.2582849940.78480183.0385110913.87169220713.038511091按行相乘开3次方权重WiAwiAwi/Wi0.0666666670.4054801330.1047294340.3182223.038511091110.2582849940.7848023.038511091152.4662120740.6369855721.9354883.0385110913.87169220713.038511091按行相乘开3次方权重WiAwiAwi/Wi0.1111111110.4807498570.1428571430.428571