熵值法的EXCEL实现过程的副本

1、20012002200320042005200620072008X110.2888820.2752110.2088530.1831490.1993440.2295860.2764410.294964X120.0392340.0245850.0161570.0168570.0324250.083410.103860.085386X210.6835021.5993040.7940991.1113341.1483182.1461532.0146480.663515X220.0965540.0433770.0959780.0450480.0813410.0784290.0337890.07382X23

2、1.0041511.01620.8450550.6980740.6637150.8597441.0941350.967156X310.1469160.1274610.0951860.0873020.1071270.1619520.3427210.175967X321.2501191.164741.1118320.8213210.8272950.8559050.7017710.577139X330.3269110.2590850.2069160.2089020.1926150.0597440.2637990.22971620092010201120122013200120020.2892560.

3、3140320.3454690.6076220.6098840.60990.47370.45120.1813580.1448590.1934610.6372440.788210.78820.04980.03120.6261770.3831110.6264210.8123761.071092.14620.31850.74520.1902720.1434340.1880.3047080.2605770.30470.31690.14240.9787971.1073271.0621011.1644691.098111.16450.86230.87260.1504670.2923710.1311740.

4、1806050.1516860.34270.42870.37190.5658020.5569550.544230.5520380.5131261.25011.00000.93170.2470640.2623110.5419871.774890.3471141.77490.18420.14602003200420052006200720082009201020110.34240.30030.32680.37640.45330.48360.47430.51490.56640.02050.02140.04110.10580.13180.10830.23010.18380.24540.37000.51

5、780.53501.00000.93870.30920.29180.17850.29190.31500.14780.26700.25740.11090.24230.62450.47070.61700.72570.59950.57000.73830.93960.83050.84050.95090.91210.27780.25470.31260.47261.00010.51350.43910.85310.38280.88940.65700.66180.68470.56140.46170.45260.44550.43530.11660.11770.10850.03370.14860.12940.13

6、920.14780.3054201220132001200220030.99631.00006.75960.3899-10.0700710.0667550.0506590.80851.00002.97770.3899-10.0167170.0104750.0068840.37850.49916.37410.3899-10.0499630.1169070.0580481.00000.85525.36700.3899-10.0590430.0265250.058691.00000.943010.78490.3899-10.0799550.0809140.0672870.52700.44266.27

7、640.3899-10.0683040.0592590.0442540.44160.41058.03320.3899-10.1244850.1159830.1107151.00000.19562.77260.3899-10.0664310.0526480.042047规范化矩阵2004200520062007200820092010201120120.0444250.0483530.0556880.0670540.0715470.0701620.0761720.0837970.1473850.0071820.0138150.0355390.0442520.0363810.0772710.061

8、720.0824280.2715120.0812370.0839410.1568810.1472690.0485020.0457730.0280050.0457910.0593840.0275470.049740.0479590.0206620.0451410.1163510.087710.1149620.1863290.0555840.0528480.0684560.0871190.0770090.0779360.088170.0845690.092720.0405880.0498050.0752940.1593370.081810.0699550.1359280.0609850.08396

9、60.0817860.0823810.085230.0698810.0574710.0563420.0554610.0541940.0549710.042450.0391410.012140.0536060.046680.0502050.0533040.1101360.36067201320012002200320042005200620070.147934-2.65824-2.70672-2.98263-3.11396-3.02923-2.88798-2.702260.335834-4.09135-4.55878-4.97855-4.93615-4.28197-3.33713-3.11786

10、0.078295-2.99647-2.14637-2.84649-2.51038-2.47764-1.85226-1.91550.159343-2.8295-3.62967-2.83548-3.59186-3.00095-3.0374-3.879460.087436-2.5263-2.51437-2.69879-2.88987-2.94034-2.68156-2.440470.070521-2.68379-2.82584-3.11782-3.20427-2.99963-2.58635-1.836730.051096-2.08357-2.15431-2.2008-2.50365-2.4964-2

11、.4624-2.660960.070536-2.7116-2.94413-3.16897-3.15942-3.24059-4.41122-2.9261200820092010201120122013200120022.63741-2.65695-2.57476-2.47936-1.91471-1.91099-0.18627-0.180693.31372-2.56043-2.78514-2.49583-1.30375-1.09114-0.06839-0.047753.02615-3.08406-3.57537-3.08367-2.82373-2.54727-0.14971-0.250933.09

12、796-2.15114-2.43372-2.16315-1.68024-1.8367-0.16706-0.096282.56383-2.55187-2.42849-2.47019-2.37817-2.43685-0.20199-0.203452.50335-2.65991-1.99563-2.79713-2.47734-2.65184-0.18331-0.167462.85648-2.87632-2.89208-2.91519-2.90095-2.97404-0.25937-0.249863.06444-2.99164-2.93175-2.20604-1.01979-2.65163-0.180

13、13-0.155200320042005200620072008200920102011-0.1511-0.13834-0.14647-0.16083-0.1812-0.1887-0.18642-0.19612-0.20776-0.03427-0.03545-0.05916-0.1186-0.13797-0.12056-0.19785-0.1719-0.20573-0.16523-0.20394-0.20798-0.29059-0.28209-0.14677-0.14117-0.10013-0.1412-0.16642-0.09894-0.14927-0.14567-0.08016-0.139

14、85-0.25029-0.21346-0.24868-0.18159-0.16063-0.15539-0.18357-0.21261-0.19744-0.19888-0.21412-0.2089-0.13797-0.13006-0.1494-0.19474-0.29266-0.2048-0.18607-0.27126-0.17058-0.24366-0.20476-0.20566-0.20987-0.18595-0.16416-0.16206-0.1604-0.15799-0.13325-0.13412-0.12684-0.05355-0.15686-0.14305-0.1502-0.15627-0.2429620122013Hj-0.2822-0.2827-12.564949-2.488790.97030610.0296940.35398-0.36644-12.564949-1.918050.74779310.2522070.16768-0.19944-12.564949-2.446860.9539610.046040.31308-0.29266-12.564949-2.361810.92080210.079198-0.2205-0.21307-12.564949-2.55