AHP层次分析法Excel计算表格

判断矩阵

A C1C2C3C4C5C6 C1111111

C2111111

C3111111

C4111111

C5111111

C6111111

C7111111

C8111111

列和8.0008.0008.0008.0008.0008.000

判断矩阵按列归一化

B C1C2C3C4C5C6 C10.1250.1250.1250.1250.1250.125 C20.1250.1250.1250.1250.1250.125 C30.1250.1250.1250.1250.1250.125 C40.1250.1250.1250.1250.1250.125 C50.1250.1250.1250.1250.1250.125 C60.1250.1250.1250.1250.1250.125 C70.1250.1250.1250.1250.1250.125 C80.1250.1250.1250.1250.1250.125列和 1.000 1.000 1.000 1.000 1.000 1.000验证

RI取值

1234567 000.520.89 1.12 1.26 1.36 CI0

CR0

判断可以接受

C7C8

11

11

11

11

11

11

11

11

8.0008.000

C7C7行和归一化权重W AW 0.1250.1250.7500.1251 0.1250.1250.7500.1251 0.1250.1250.7500.1251 0.1250.1250.7500.1251 0.1250.1250.7500.1251 0.1250.1250.7500.1251 0.1250.1250.7500.1251

0.1250.1250.7500.1251

1.000 1.000 6.000

求和64

最大特征值8 89101112 1.41 1.46 1.49 1.52 1.54

8 8 8 8 8 8 8 8