熵值法的EXCEL实现过程

200120022003200420052006200720082009X110.288882 0.275211 0.208853 0.183149 0.199344 0.229586 0.276441 0.294964 0.289256X120.039234 0.024585 0.016157 0.016857 0.0324250.083410.10386 0.085386 0.181358X210.683502 1.599304 0.794099 1.111334 1.148318 2.146153 2.014648 0.663515 0.626177X220.096554 0.043377 0.095978 0.045048 0.081341 0.078429 0.0337890.07382 0.190272X231.0041511.0162 0.845055 0.698074 0.663715 0.859744 1.094135 0.967156 0.978797X310.146916 0.127461 0.095186 0.087302 0.107127 0.161952 0.342721 0.175967 0.150467X321.2501191.16474 1.111832 0.821321 0.827295 0.855905 0.701771 0.577139 0.565802X330.326911 0.259085 0.206916 0.208902 0.192615 0.059744 0.263799 0.229716 0.247064201020112012201320012002200320040.314032 0.345469 0.607622 0.6098840.60990.47370.45120.34240.30030.144859 0.193461 0.6372440.788210.78820.04980.03120.02050.02140.383111 0.626421 0.8123761.071092.14620.31850.74520.37000.51780.1434340.188 0.304708 0.2605770.30470.31690.14240.31500.14781.107327 1.062101 1.1644691.098111.16450.86230.87260.72570.59950.292371 0.131174 0.180605 0.1516860.34270.42870.37190.27780.25470.5569550.54423 0.552038 0.5131261.25011.00000.93170.88940.65700.262311 0.5419871.77489 0.3471141.77490.18420.14600.11660.11772005200620072008200920102011201220130.32680.37640.45330.48360.47430.51490.56640.99631.00000.04110.10580.13180.10830.23010.18380.24540.80851.00000.53501.00000.93870.30920.29180.17850.29190.37850.49910.26700.25740.11090.24230.62450.47070.61701.00000.85520.57000.73830.93960.83050.84050.95090.91211.00000.94300.31260.47261.00010.51350.43910.85310.38280.52700.44260.66180.68470.56140.46170.45260.44550.43530.44160.41050.10850.03370.14860.12940.13920.14780.30541.00000.195620012002200320042005200620076.75960.3899-1 0.070071 0.066755 0.050659 0.044425 0.048353 0.055688 0.0670542.97770.3899-1 0.016717 0.010475 0.006884 0.007182 0.013815 0.035539 0.0442526.37410.3899-1 0.049963 0.1...