基尼系數(shù)和錫爾系數(shù)計(jì)算

,洛倫茲曲線的繪制,,,,,,,,,,,計(jì)算基尼系數(shù),,,,,,,,,計(jì)算錫爾系數(shù),,,,,

亞區(qū)代碼,人口數(shù)/萬人,GDP/億元,人口占全區(qū)的比重（p),GDP占全區(qū)的比重(w),w/p,p的累計(jì)（X),w的累計(jì)(Y),均衡分布人口占全區(qū)的比重,均衡分布GDP占全區(qū)的比重,均衡分布時(shí)p的累計(jì),均衡分布時(shí)w的累計(jì),lnX,lnY,∑（lnX*lnY）,∑(lnX)^2,冪函數(shù)指數(shù)β,基尼系數(shù)G,2Y-w,∑p*(2Y-w),基尼系數(shù)G,p/w,log(p/w),∑p*log(p/w),w/p,log(w/p),∑w*log(w/p)

,,,,,,0.00,0.00,,,,0.00,,,,,,,,,1-∑p*(2Y-w),,,,,,

3,3710,911.86,0.13,0.08,0.58,0.13,0.08,0.13,0.13,0.13,0.13,(2.05),(2.59),11.28,9.08,1.24,0.108,0.08,0.89,0.105,1.72,0.23,0.0110,0.58,(0.23),0.0103

7,2543,931.98,0.09,0.08,0.87,0.22,0.15,0.09,0.09,0.22,0.22,(1.53),(1.88),,,,,0.23,,,1.15,0.06,,0.87,(0.06),

6,3618,1487.61,0.13,0.12,0.98,0.34,0.27,0.13,0.13,0.34,0.34,(1.07),(1.29),,,,,0.43,,,1.03,0.01,,0.98,(0.01),

5,256,105.61,0.01,0.01,0.98,0.35,0.28,0.01,0.01,0.35,0.35,(1.04),(1.26),,,,,0.56,,,1.02,0.01,,0.98,(0.01),

2,8550,3711.61,0.30,0.31,1.03,0.65,0.59,0.30,0.30,0.65,0.65,(0.43),(0.53),,,,,0.87,,,0.97,(0.01),,1.03,0.01,

4,4192,1855.74,0.15,0.15,1.05,0.79,0.74,0.15,0.15,0.79,0.79,(0.23),(0.30),,,,,1.33,,,0.95,(0.02),,1.05,0.02,

9,543,241.49,0.02,0.02,1.05,0.81,0.76,0.02,0.02,0.81,0.81,(0.21),(0.27),,,,,1.50,,,0.95,(0.02),,1.05,0.02,

8,510,238.39,0.02,0.02,1.11,0.83,0.78,0.02,0.02,0.83,0.83,(0.18),(0.25),,,,,1.54,,,0.90,(0.04),,1.11,0.04,

1,3075,1479.71,0.11,0.12,1.14,0.94,0.90,0.11,0.11,0.94,0.94,(0.06),(0.10),,,,,1.69,,,0.88,(0.06),,1.14,0.06,

10,1774,1168.55,0.06,0.10,1.56,1.00,1.00,0.06,0.06,1.00,1.00,,,,,,