研究数据普通数据
面板数据熵值法综合评价Stata案例
数据摘要
多指标综合评价需要明确标准化与赋权步骤。本资料提供面板数据熵值法Stata代码、示例数据、计算结果及方法说明,围绕标准化、指标占比、信息熵、权重和加权汇总介绍操作。可用于学习面板综合指标构建,并根据研究对象调整指标体系。
基本信息
| 数据频率 | 年度 |
|---|---|
| 当前预览样本量 | 1190 行 |
| 文件格式 | Stata / Stata代码 / PDF / Word |
| 文件包大小 | 628.02 KB |
| 包含内容 | 数据表2份、代码1份、文档2份 |
| 所属分类 |
样本年份分布
合计 1,190 行 · 17 个年份
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
查看年份明细
| 年份 | 样本量 |
|---|---|
| 2001 | 70 |
| 2002 | 70 |
| 2003 | 70 |
| 2004 | 70 |
| 2005 | 70 |
| 2006 | 70 |
| 2007 | 70 |
| 2008 | 70 |
| 2009 | 70 |
| 2010 | 70 |
| 2011 | 70 |
| 2012 | 70 |
| 2013 | 70 |
| 2014 | 70 |
| 2015 | 70 |
| 2016 | 70 |
| 2017 | 70 |
测算方法
采用熵值法对面板数据中的各项指标客观赋权并计算综合指标。每项指标的标准化极值取自全部地区、全部年份的样本,指标比重以标准化值除以该指标在全部地区、全部年份的标准化值之和。随后计算信息熵与信息冗余度,以各指标冗余度占全部指标冗余度之和的比例确定权重,再将指标权重与标准化值相乘并加总,得到地区年度综合指标。信息熵中log(m)的m取样本年份数。
以下字段、样本量及样本仅对应当前展示的数据表,不代表资料包全部文件。查看文件结构
字段列表共 8 个字段
| 字段 | 类型 | 均值 | 标准差 | 最小值 | 最大值 | 缺失率 |
|---|---|---|---|---|---|---|
id | 整数 | 37.64285714 | 21.40661677 | 1 | 74 | 0.0000% |
year | 整数 | 2009 | 4.901039179 | 2001 | 2017 | 0.0000% |
x1 | 数值 | 8.635689921 | 35.15519487 | -4.863278 | 1058.3736 | 0.0000% |
x2 | 数值 | 27.41004901 | 5.220849833 | 0 | 38.291667 | 0.0000% |
x3 | 数值 | 16.21860606 | 5.086109807 | 4.6298861 | 33.011887 | 0.0000% |
x4 | 数值 | 75.22821246 | 31.40422082 | 15.635592 | 189.59017 | 0.0000% |
x5 | 数值 | 65.01871302 | 49.76293466 | 1.385387 | 312.02694 | 0.0000% |
Score | 数值 | 0.3649227614 | 0.1510628995 | 0.0431280546 | 0.9407056182 | 0.0000% |
数据样本预览
资料样本(部分数据)
仅可预览前100 行、100 列,滚动查看其余行列,完整数据以下载文件为准。
| id | year | x1 | x2 | x3 | x4 | x5 | Score |
|---|---|---|---|---|---|---|---|
| 1 | 2001 | 29.779626 | 18.75 | 16.76379 | 55.191005 | 5.199387 | 0.216736092041 |
| 1 | 2002 | 18.679076 | 22.333333 | 15.774319 | 53.705148 | 5.3649027 | 0.322724016306 |
| 1 | 2003 | 5.7335228 | 24.666667 | 16.538379 | 52.243911 | 3.9074169 | 0.0846671891126 |
| 1 | 2004 | 4.9501616 | 22.583333 | 17.791909 | 45.094451 | 4.5638225 | 0.260033456067 |
| 1 | 2005 | 2.6455111 | 22 | 16.787237 | 50.929115 | 5.3880899 | 0.205832620184 |
| 1 | 2006 | 0.33916319 | 22.75 | 13.583947 | 62.858344 | 5.9656402 | 0.179240413489 |
| 1 | 2007 | 4.2259883 | 22.083333 | 14.775075 | 58.706163 | 8.0142643 | 0.284555320642 |
| 1 | 2008 | 1.4183019 | 22.541667 | 15.487122 | 61.134165 | 12.199792 | 0.371997684387 |
| 1 | 2009 | 4.268954 | 21.583333 | 14.803394 | 62.124772 | 11.222325 | 0.362239325215 |
| 1 | 2010 | 3.9618003 | 22.75 | 13.772649 | 65.701426 | 10.99778 | 0.340636356007 |
| 1 | 2011 | 1.3824466 | 25.458333 | 11.450422 | 71.278597 | 11.92915 | 0.352847193677 |
| 1 | 2012 | 2.3145241 | 25.166667 | 11.231577 | 70.730014 | 12.117098 | 0.362990762202 |
| 1 | 2013 | 3.6738273 | 24.416667 | 11.643496 | 71.938127 | 12.990103 | 0.423336963368 |
| 1 | 2014 | 4.8629905 | 23.791667 | 13.206714 | 76.684522 | 12.7958 | 0.38544518294 |
| 1 | 2015 | 5.7343334 | 24.25 | 16.145286 | 71.324329 | 16.265805 | 0.496756966997 |
| 1 | 2016 | 3.9130435 | 24.5 | 17.226756 | 69.866662 | 15.208241 | 0.531937319674 |
| 1 | 2017 | 4.5242115 | 21.166667 | 20.667465 | 67.472276 | 13.715511 | 0.48381960138 |
| 2 | 2001 | 2.2433667 | 26.583333 | 19.589658 | 68.256601 | 90.905198 | 0.154017117009 |
| 2 | 2002 | 1.8609738 | 30.5 | 19.565743 | 70.083671 | 90.905198 | 0.227176186762 |
| 2 | 2003 | 1.3059831 | 32.375 | 19.600791 | 74.86769 | 90.905198 | 0.0763582120477 |
| 2 | 2004 | 0.92246584 | 32.75 | 19.553055 | 76.927149 | 90.905198 | 0.249725528262 |
| 2 | 2005 | 0.56899077 | 32 | 19.843667 | 78.26014 | 92.097034 | 0.224444731043 |
| 2 | 2006 | 2.3448646 | 32.083333 | 19.219717 | 85.360496 | 90.905198 | 0.244270544019 |
| 2 | 2007 | 2.6499992 | 35 | 18.976168 | 87.536665 | 89.713362 | 0.330742474172 |
| 2 | 2008 | 1.8103595 | 34.625 | 18.838697 | 86.948168 | 88.521526 | 0.405146029433 |
| 2 | 2009 | 1.3555567 | 35.75 | 18.97964 | 86.387383 | 87.806366 | 0.34346739306 |
| 2 | 2010 | 2.0612035 | 35.208333 | 18.891359 | 90.792346 | 87.765846 | 0.356297122576 |
| 2 | 2011 | 2.2991388 | 34.541667 | 19.346273 | 94.033805 | 94.324106 | 0.450067444754 |
| 2 | 2012 | 1.441547 | 33.958333 | 19.25829 | 98.088311 | 94.437606 | 0.437325308315 |
| 2 | 2013 | 2.168556 | 34.75 | 18.744792 | 100.73325 | 92.919884 | 0.492681387803 |
| 2 | 2014 | 3.2159502 | 34.458333 | 19.272131 | 102.07368 | 95.812966 | 0.428106509432 |
| 2 | 2015 | 0.50630835 | 36.5 | 20.684213 | 87.062231 | 97.739575 | 0.646625573669 |
| 2 | 2016 | 1.8135363 | 35.416667 | 20.492548 | 99.019796 | 98.528324 | 0.617634188588 |
| 2 | 2017 | 3.286582 | 33.625 | 19.896568 | 105.10279 | 96.061099 | 0.535457240403 |
| 3 | 2001 | 2.7040348 | 24.583333 | 20.846595 | 152.46432 | 43.093573 | 0.13013208209 |
| 3 | 2002 | -0.45222738 | 23.75 | 20.23711 | 164.11542 | 41.611822 | 0.177515789764 |
| 3 | 2003 | 2.4315513 | 27 | 19.482259 | 148.58208 | 45.000626 | 0.0661823507072 |
| 3 | 2004 | -0.36653386 | 29 | 20.764698 | 128.4891 | 50.070965 | 0.210511382 |
| 3 | 2005 | -1.287588 | 28.583333 | 20.815426 | 141.8317 | 52.319745 | 0.178313126529 |
| 3 | 2006 | -0.70485295 | 30 | 16.208927 | 135.80902 | 40.511754 | 0.18846213493 |
| 3 | 2007 | -1.2075718 | 31.5 | 17.260399 | 127.02611 | 41.815626 | 0.266197662802 |
| 3 | 2008 | -0.49554014 | 31.708333 | 17.999289 | 130.60752 | 44.359618 | 0.364042885851 |
| 3 | 2009 | 1.5936255 | 31.708333 | 17.316024 | 128.09149 | 42.125455 | 0.308011501023 |
| 3 | 2010 | 2.3529412 | 31.5 | 15.438407 | 140.73723 | 43.942896 | 0.289755931217 |
| 3 | 2011 | 2.5862069 | 31.166667 | 14.056754 | 148.31349 | 43.684341 | 0.327120552997 |
| 3 | 2012 | 2.0074697 | 30.833333 | 12.712744 | 147.10186 | 44.877046 | 0.300813097909 |
| 3 | 2013 | 3.2566667 | 28.5 | 12.099779 | 137.78505 | 53.118054 | 0.358179849286 |
| 3 | 2014 | 3.5260032 | 28.5 | 11.069286 | 145.88266 | 64.213446 | 0.298385238117 |
| 3 | 2015 | 2.7955128 | 28.5 | 13.978344 | 117.96373 | 71.437267 | 0.466036390359 |
| 3 | 2016 | 1.9618847 | 28.916667 | 12.927963 | 120.4724 | 67.697263 | 0.459660264968 |
| 3 | 2017 | -0.40148699 | 26.958333 | 13.872921 | 174.15896 | 69.55268 | 0.296131061606 |
| 4 | 2001 | 10.297812 | 14 | 4.6298861 | 28.209496 | 20.881761 | 0.131609578854 |
| 4 | 2002 | 2.377129 | 16.833333 | 4.7274992 | 26.076088 | 18.911998 | 0.176000871482 |
| 4 | 2003 | 5.3056011 | 22.083333 | 4.9029821 | 26.325514 | 19.986631 | 0.0600194311726 |
| 4 | 2004 | 8.402238 | 22.75 | 5.1256798 | 27.880063 | 20.496638 | 0.218462613938 |
| 4 | 2005 | 6.1066959 | 22 | 5.0396152 | 28.38794 | 20.987234 | 0.181014017461 |
| 4 | 2006 | 2.2082562 | 20.416667 | 4.9731214 | 29.321714 | 21.779389 | 0.144732268422 |
| 4 | 2007 | 2.0071737 | 22 | 4.8456598 | 32.098017 | 24.179593 | 0.216279959037 |
| 4 | 2008 | 3.3325649 | 20.75 | 5.0226486 | 28.967381 | 26.208125 | 0.309231481565 |
| 4 | 2009 | 5.6687077 | 20.583333 | 5.1282986 | 27.657885 | 26.038628 | 0.341524292841 |
| 4 | 2010 | 7.5875364 | 20.791667 | 5.1743831 | 26.858234 | 27.913403 | 0.332577495422 |
| 4 | 2011 | 7.0466182 | 22.458333 | 5.1802252 | 34.396935 | 29.34383 | 0.451793911811 |
| 4 | 2012 | 6.7652612 | 22.375 | 5.4400786 | 38.111925 | 31.165702 | 0.452578868089 |
| 4 | 2013 | 9.106985 | 22.083333 | 5.3594562 | 39.942383 | 32.042833 | 0.520756706254 |
| 4 | 2014 | 8.9019449 | 22 | 5.1782769 | 42.620914 | 34.042192 | 0.396855740049 |
| 4 | 2015 | 5.4234724 | 23.791667 | 5.0937452 | 40.092796 | 36.191038 | 0.412872616801 |
| 4 | 2016 | 8.1266764 | 23.375 | 5.0753258 | 37.802843 | 40.961323 | 0.4754838109 |
| 4 | 2017 | 11.332915 | 20.333333 | 5.0974467 | 47.42085 | 42.470241 | 0.46600318113 |
| 5 | 2001 | 1.467967 | 26.75 | 21.131267 | 115.51137 | 68.162224 | 0.142106858298 |
| 5 | 2002 | 2.0770211 | 30.25 | 21.504809 | 118.06009 | 68.162224 | 0.221089243049 |
| 5 | 2003 | 1.6281605 | 29.583333 | 20.955778 | 124.36669 | 68.162224 | 0.0718194976327 |
| 5 | 2004 | 0.94925029 | 31 | 20.856703 | 123.4845 | 65.936662 | 0.228924054342 |
| 5 | 2005 | 1.1208482 | 30.666667 | 21.015862 | 123.99724 | 65.936662 | 0.213371134063 |
| 5 | 2006 | 2.5445178 | 31.083333 | 20.874403 | 141.07907 | 65.936662 | 0.232161574975 |
| 5 | 2007 | 2.4692582 | 33.833333 | 21.278694 | 138.69447 | 65.936662 | 0.321512967055 |
| 5 | 2008 | 1.6452144 | 33.583333 | 21.916375 | 135.12489 | 63.7111 | 0.407325822773 |
| 5 | 2009 | 1.588964 | 33.5 | 22.351607 | 131.99031 | 62.213125 | 0.334264157939 |
| 5 | 2010 | 2.0972831 | 33.333333 | 22.03526 | 136.03783 | 61.451076 | 0.337896008165 |
| 5 | 2011 | 2.7814326 | 32.5 | 22.107847 | 143.37622 | 63.303099 | 0.407289957826 |
| 5 | 2012 | 1.7912077 | 32.5 | 21.892255 | 147.6939 | 65.529181 | 0.388272954059 |
| 5 | 2013 | 1.8230563 | 30.5 | 21.586598 | 151.16362 | 68.226711 | 0.400494496463 |
| 5 | 2014 | 4.4894442 | 31.333333 | 22.554389 | 158.90805 | 62.346586 | 0.410055643283 |
| 5 | 2015 | -0.05314567 | 32.875 | 24.021313 | 136.35676 | 58.290429 | 0.591031755683 |
| 5 | 2016 | 2.1892992 | 31.875 | 23.554857 | 151.10018 | 56.496499 | 0.591369956358 |
| 5 | 2017 | 3.5320821 | 30.5 | 23.773675 | 162.75367 | 54.962157 | 0.502480530676 |
| 6 | 2001 | 10.193207 | 20.833333 | 13.57262 | 49.737986 | 48.201845 | 0.158307776851 |
| 6 | 2002 | 12.425487 | 21.5 | 13.327267 | 49.856291 | 52.73723 | 0.260309015604 |
| 6 | 2003 | 4.7084444 | 25.5 | 13.903529 | 50.469663 | 58.275424 | 0.0723536501279 |
| 6 | 2004 | 7.673229 | 27.75 | 14.218871 | 52.281162 | 64.051843 | 0.264635060522 |
| 6 | 2005 | 2.1595163 | 27.5 | 14.797892 | 44.168254 | 64.449992 | 0.210109608357 |
| 6 | 2006 | 4.60823 | 27.583333 | 14.5393 | 45.597775 | 58.721803 | 0.234645796936 |
| 6 | 2007 | 1.5896538 | 26.291667 | 15.72413 | 45.227822 | 53.5566 | 0.275984145123 |
| 6 | 2008 | 0.92825885 | 24.75 | 15.96789 | 49.350261 | 51.001677 | 0.362654702896 |
| 6 | 2009 | 3.337275 | 22.333333 | 16.521142 | 51.967835 | 47.88052 | 0.345511747174 |
| 6 | 2010 | 4.4373808 | 22.875 | 16.258537 | 57.464267 | 42.650701 | 0.351614273149 |
| 6 | 2011 | 5.3932311 | 19.958333 | 15.974558 | 67.641943 | 45.025463 | 0.42758636477 |
| 6 | 2012 | 4.2855493 | 19 | 14.354233 | 74.53785 | 37.800093 | 0.376833263719 |
| 6 | 2013 | 8.7062472 | 18.125 | 14.058653 | 76.061912 | 36.968428 | 0.488924862691 |
| 6 | 2014 | 14.000408 | 19.375 | 13.277374 | 82.867021 | 34.692625 | 0.472691247344 |
| 6 | 2015 | 3.3493698 | 20.166667 | 14.708765 | 68.627074 | 37.018216 | 0.373227558323 |
代码公开披露
仅展示前 30 行,供了解变量构造与处理流程,完整代码请下载文件查看。
import excel "数据.xlsx", firstrow clear
save data.dta, replace
///从这开始运行
use data,clear
*=========================== 需要设置 ===========================
//正向指标
global positive_var x1 x2 x3
//负向指标
global negative_var x4 x5
*================================================================
*========================= 后面无需改动 =========================
//所有指标
global all_var $positive_var $negative_var
//年份
qui sum year
global min_year=r(min)
global max_year=r(max)
forvalues year=$min_year / $max_year{
use data.dta, clear
keep if year==`year'
//标准化数据 正向指标
foreach i in $positive_var {
qui sum `i'