《熵权法(例子带步骤).xls》由会员分享，可在线阅读，更多相关《熵权法(例子带步骤).xls（6页珍藏版）》请在三一文库上搜索。
1、原始数据 科科室室X X1 1X X2 2X X3 3X X4 4X X5 5X X6 6X X7 7X X8 8 A A100901008490100100100 B B10010078.610090100100100 C C7510085.710090100100100 D D10010078.61009010094.4100 E E1009010010010090100100 F F1001001001009010010085.7 G G10010078.61009010055.6100 H H87.510085.7100100100100100 I I10010092.91008010
2、0100100 J J10090100100100100100100 K K10010092.910090100100100 数据标准化 Y YX X1 1X X2 2X X3 3X X4 4X X5 5X X6 6X X7 7X X8 8 A A1.000.001.000.000.501.001.001.00 B B1.001.000.001.000.501.001.001.00 C C0.001.000.331.000.501.001.001.00 D D1.001.000.001.000.501.000.871.00 E E1.000.001.001.001.000.001.001.00
3、 F F1.001.001.001.000.501.001.000.00 G G1.001.000.001.000.501.000.001.00 H H0.501.000.331.001.001.001.001.00 I I1.001.000.671.000.001.001.001.00 J J1.000.001.001.001.001.001.001.00 K K1.001.000.671.000.501.001.001.00 求求和和：9.508.006.0010.006.5010.009.8710.00 P PxjxjX X1 1X X2 2X X3 3X X4 4X X5 5X X6
4、6X X7 7X X8 8 A A0.110.000.170.000.080.100.100.10 B B0.110.130.000.100.080.100.100.10 C C0.000.130.060.100.080.100.100.10 D D0.110.130.000.100.080.100.090.10 E E0.110.000.170.100.150.000.100.10 F F0.110.130.170.100.080.100.100.00 G G0.110.130.000.100.080.100.000.10 H H0.050.130.060.100.150.100.100.1
5、0 I I0.110.130.110.100.000.100.100.10 J J0.110.000.170.100.150.100.100.10 K K0.110.130.110.100.080.100.100.10 LnPLnPxjxjX X1 1X X2 2X X3 3X X4 4X X5 5X X6 6X X7 7X X8 8 A A-2.250.00-1.790.00-2.56-2.30-2.29-2.30 B B-2.25-2.080.00-2.30-2.56-2.30-2.29-2.30 C C0.00-2.08-2.90-2.30-2.56-2.30-2.29-2.30 D D
6、-2.25-2.080.00-2.30-2.56-2.30-2.42-2.30 E E-2.250.00-1.79-2.30-1.870.00-2.29-2.30 F F-2.25-2.08-1.79-2.30-2.56-2.30-2.290.00 G G-2.25-2.080.00-2.30-2.56-2.300.00-2.30 H H-2.94-2.08-2.90-2.30-1.87-2.30-2.29-2.30 I I-2.25-2.08-2.19-2.300.00-2.30-2.29-2.30 J J-2.250.00-1.79-2.30-1.87-2.30-2.29-2.30 K K
7、-2.25-2.08-2.19-2.30-2.56-2.30-2.29-2.30 P Pxjxj*LnP*LnPxjxjX X1 1X X2 2X X3 3X X4 4X X5 5X X6 6X X7 7X X8 8 A A-0.240.00-0.300.00-0.20-0.23-0.23-0.23 B B-0.24-0.260.00-0.23-0.20-0.23-0.23-0.23 C C0.00-0.26-0.16-0.23-0.20-0.23-0.23-0.23 D D-0.24-0.260.00-0.23-0.20-0.23-0.21-0.23 E E-0.240.00-0.30-0.
8、23-0.290.00-0.23-0.23 F F-0.24-0.26-0.30-0.23-0.20-0.23-0.230.00 G G-0.24-0.260.00-0.23-0.20-0.230.00-0.23 H H-0.15-0.26-0.16-0.23-0.29-0.23-0.23-0.23 I I-0.24-0.26-0.24-0.230.00-0.23-0.23-0.23 J J-0.240.00-0.30-0.23-0.29-0.23-0.23-0.23 K K-0.24-0.26-0.24-0.23-0.20-0.23-0.23-0.23 -2.29-2.08-2.00-2.3
9、0-2.25-2.30-2.30-2.30 -0.417030.95 各指标的信息熵 E Ej jX X1 1X X2 2X X3 3X X4 4X X5 5X X6 6X X7 7X X8 8 信息熵0.950.870.840.960.940.960.960.96 权重 W Wj jW W1 1W W2 2W W3 3W W4 4W W5 5W W6 6W W7 7W W8 8 权重0.080.220.270.070.110.070.070.07 X Xli*WiX X1 1X X2 2X X3 3X X4 4X X5 5X X6 6X X7 7X X8 8 A A7.578559 19.7
10、2428 27.13738 5.509738 9.467793 6.559212 6.611572 6.559212 B B7.578559 21.91587 21.32998 6.559212 9.467793 6.559212 6.611572 6.559212 C C5.683919 21.91587 23.25674 6.559212 9.467793 6.559212 6.611572 6.559212 D D7.578559 21.91587 21.32998 6.559212 9.467793 6.559212 6.241324 6.559212 E E7.578559 19.7
11、2428 27.13738 6.559212 10.51977 5.903291 6.611572 6.559212 F F7.578559 21.91587 27.13738 6.559212 9.467793 6.559212 6.611572 5.621245 G G7.578559 21.91587 21.32998 6.559212 9.467793 6.559212 3.676034 6.559212 H H6.631239 21.91587 23.25674 6.559212 10.51977 6.559212 6.611572 6.559212 I I7.578559 21.9
12、1587 25.21063 6.559212 8.415816 6.559212 6.611572 6.559212 J J7.578559 19.72428 27.13738 6.559212 10.51977 6.559212 6.611572 6.559212 K K7.578559 21.91587 25.21063 6.559212 9.467793 6.559212 6.611572 6.559212 科科室室得得分分 A A95.71 B B93.14 C C93.17 D D92.77 E E95.84 F F98.01 G G90.21 H H95.17 I I95.97 J
13、 J97.81 K K97.02 X X9 9 100 100 100 100 80 100 100 100 100 100 100 X X9 9 1.00 1.00 1.00 1.00 0.00 1.00 1.00 1.00 1.00 1.00 1.00 10.00 原始数据 数据标准化 X X9 9 0.10 0.10 0.10 0.10 0.00 0.10 0.10 0.10 0.10 0.10 0.10 X X9 9 -2.30 -2.30 -2.30 -2.30 0.00 -2.30 -2.30 -2.30 -2.30 -2.30 -2.30 X X9 9 -0.23 -0.23 -0.23 -0.23 0.00 -0.23 -0.23 -0.23 -0.23 -0.23 -0.23 -2.30 X X9 9求求和和 0.968.39 W W9 9 0.07 各指标的信息熵 权重 X X9 9 6.559212 6.559212 6.559212 6.559212 5.24737 6.559212 6.559212 6.559212 6.559212 6.559212 6.559212