(AHP)定量分析之层次分析excel公式表.xlsx

(AHP)定量分析之层次分析excel公式表.xlsx

《(AHP)定量分析之层次分析excel公式表.xlsx》由会员分享，可在线阅读，更多相关《(AHP)定量分析之层次分析excel公式表.xlsx（1页珍藏版）》请在冰豆网上搜索。

课课题题:

假假定定现现在在需需要要购购买买一一台台电电冰冰箱箱：

有有四四种种不不同同的的牌牌子子（任任选选）供供选选择择。

所所考考虑虑的的是是以以下下几几个个方方面面：

款款式式、价价格格、制制冷冷级级别别、耗耗电电量量等等。

C品牌选择款式制冷级别价格耗电按行相乘开n次方权重WiAwiAwi/WiCI=（-n）/（n-1）CR=CI/RI假定RI款式134224.002.210.482.074.30制冷级别1/311/21/20.080.540.120.484.09n123456789价格1/42121.001.000.220.944.31RI0.000.000.580.901.121.241.321.411.45耗电1/221/210.500.840.180.774.194.594.220.070.08C1款式海尔新飞容声雪花按行相乘开n次方权重WiAwiAwi/WiCI=（-n）/（n-1）CR=CI/RI海尔135460.002.780.612.654.38新飞1/31322.001.190.261.305.01容声1/51/311/20.030.430.090.444.78雪花1/41/21/310.040.450.100.434.424.854.650.22#DIV/0!

C2制冷级别海尔新飞容声雪花按行相乘开n次方权重WiAwiAwi/WiCI=（-n）/（n-1）CR=CI/RI海尔143336.002.450.532.154.04新飞1/411/21/30.040.450.100.414.14容声1/32110.670.900.200.804.04雪花1/33111.001.000.220.914.194.804.100.03#DIV/0!

C3价格海尔新飞容声雪花按行相乘开n次方权重WiAwiAwi/WiCI=（-n）/（n-1）CR=CI/RI海尔134224.002.210.482.074.30新飞1/311/21/20.080.540.120.484.09容声1/42121.001.000.220.944.31雪花1/221/210.500.840.180.774.194.594.220.07#DIV/0!

C4耗电海尔新飞容声雪花按行相乘开n次方权重WiAwiAwi/WiCI=（-n）/（n-1）CR=CI/RI海尔1735105.003.200.702.874.12新飞1/711/51/30.010.310.070.294.27容声1/35135.001.500.331.514.65雪花1/531/310.200.670.150.704.835.684.470.16#DIV/0!

层次总排序计算bin款式制冷级别价格耗电aibin0.480.120.220.18aibin海尔0.610.530.480.700.290.060.100.130.59新飞0.260.100.120.070.120.010.030.010.17容声0.090.200.220.330.040.020.050.060.17雪花0.100.220.180.150.050.030.040.030.14CI0.220.030.070.16CI=aiCIi0.12CR=CI/RIRI0.900.900.900.90RI=aiRIi0.900.13Cri#DIV/0!