熵值法的EXCEL实现过程.xls

20012002200320042005200620072008X110.288882 0.275211 0.208853 0.183149 0.199344 0.229586 0.276441 0.294964X120.039234 0.024585 0.016157 0.016857 0.0324250.083410.10386 0.085386X210.683502 1.599304 0.794099 1.111334 1.148318 2.146153 2.014648 0.663515X220.096554 0.043377 0.095978 0.045048 0.081341 0.078429 0.0337890.07382X231.0041511.0162 0.845055 0.698074 0.663715 0.859744 1.094135 0.967156X310.146916 0.127461 0.095186 0.087302 0.107127 0.161952 0.342721 0.175967X321.2501191.16474 1.111832 0.821321 0.827295 0.855905 0.701771 0.577139X330.326911 0.259085 0.206916 0.208902 0.192615 0.059744 0.263799 0.22971620092010201120122013200120020.289256 0.314032 0.345469 0.607622 0.6098840.60990.47370.45120.181358 0.144859 0.193461 0.6372440.788210.78820.04980.03120.626177 0.383111 0.626421 0.8123761.071092.14620.31850.74520.190272 0.1434340.188 0.304708 0.2605770.30470.31690.14240.978797 1.107327 1.062101 1.1644691.098111.16450.86230.87260.150467 0.292371 0.131174 0.180605 0.1516860.34270.42870.37190.565802 0.5569550.54423 0.552038 0.5131261.25011.00000.93170.247064 0.262311 0.5419871.77489 0.3471141.77490.18420.14602003200420052006200720082009201020110.34240.30030.32680.37640.45330.48360.47430.51490.56640.02050.02140.04110.10580.13180.10830.23010.18380.24540.37000.51780.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.13920.14780.3054规范化矩阵201220132001200220030.99631.00006.75960.3899-1 0.070071 0.066755 0.0506590.80851.00002.97770.3899-1 0.016717 0.010475 0.0068840.37850.49916.37410.3899-1 0.049963 0.116907 0.0580481.00000.85525.36700.3899-1 0.059043 0.0265250.058691.00000.943010.78490.3899-1 0.079955 0.080914 0.0672870.52700.44266.27640.3899-1 0.068304 0.059259 0.0442540.44160.41058.03320.3899-1 0.124485 0.115983 0.1107151.00000.19562.77260.3899-1 0.066431 0.052648 0.0420472004200520062007200820092010201120120.044425 0.048353 0.055688 0.067054 0.071547 0.070162 0.076172 0.083797 0.1473850.007182 0.013815 0.035539 0.044252 0.036381 0.0772710.06172 0.082428 0.2715120.081237 0.083941 0.156881 0.147269 0.048502 0.045773 0.028005 0.045791 0.0593840.0275470.04974 0.047959 0.020662 0.045141 0.1163510.08771 0.114962 0.1863290.055584 0.052848 0.068456 0.087119 0.077009 0.0779360.08817 0.0845690.092720.040588 0.049805 0.075294 0.1593370.08181 0.069955 0.135928 0.060985 0.0839660.081786 0.0823810.08523 0.069881 0.057471 0.056342 0.055461 0.054194 0.0549710.04245 0.0391410.01214 0.0536060.04668 0.050205 0.053304 0.1101360.36067规范化矩阵201320012002200320042005200620070.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.117860.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.4624-2.660960.070536-2.7116-2.94413-3.16897-3.15942-3.24059-4.41122-2.926120082009201020112012201320012002-2.63741-2.65695-2.57476-2.47936-1.91471-1.91099-0.18627-0.18069-3.31372-2.56043-2.78514-2.49583-1.30375-1.09114-0.06839-0.04775-3.02615-3.08406-3.57537-3.08367-2.82373-2.54727-0.14971-0.25093-3.09796-2.15114-2.43372-2.16315-1.68024-1.8367-0.16706-0.09628-2.56383-2.55187-2.42849-2.47019-2.37817-2.43685-0.20199-0.20345-2.50335-2.65991-1.99563-2.79713-2.47734-2.65184-0.18331-0.16746-2.85648-2.87632-2.89208-2.91519-2.90095-2.97404-0.25937-0.24986-3.06444-2.99164-2.93175-2.20604-1.01979-2.65163-0.18013-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.13985-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-1 2.564949-2.48879 0.9703061 0.029694-0.35398-0.36644-1 2.564949-1.91805 0.7477931 0.252207-0.16768-0.19944-1 2.564949-2.446860.9539610.04604-0.31308-0.29266-1 2.564949-2.36181 0.9208021 0.079198-0.2205-0.21307-1 2.564949-2.55214 0.9950081 0.004992-0.20801-0.18701-1 2.564949-2.48334 0.9681811 0.031819-0.15947-0.15196-1 2.564949-2.51517 0.9805941 0.019406-0.36781-0.18704-1 2.564949-2.18707 0.8526771 0.1473230.610678Wj0.04860.41300.07540.12970.00820.05210.03180.24121.0000