研究数据高级数据

Stata主成分分析案例(企业财务指标)

数据格式 Stata / Stata代码更新日期

数据摘要

资料以企业规模、资产负债率、盈利能力、流动性及成长性等指标为案例,提供主成分分析结果与Stata代码。可用于学习多指标降维与综合测度的操作,并理解财务变量信息的归集方式。

基本信息

数据频率年度
当前预览样本量49247 行
文件格式Stata / Stata代码
文件包大小4.29 MB
包含内容数据表2份、代码1份、文档1份
所属分类

样本年份分布

合计 49,247 行 · 22 个年份

查看年份明细
年份样本量
20011,043
20021,119
20031,181
20041,239
20051,311
20061,290
20071,318
20081,477
20091,526
20101,664
20112,005
20122,257
20132,364
20142,337
20152,415
20162,616
20172,872
20183,353
20193,433
20203,657
20214,152
20224,618

测算方法

案例从规模、杠杆、盈利、流动性和增长等11项财务变量出发,先检查KMO与Bartlett检验。初始KMO较低,于是把样本限制为2005—2022年的平衡面板,并结合相关性删除ROE、营业收入增长、净利润增长及TobinQ,保留Size、Lev、ROA、NetProfit、Liquid、Quick和AssetGrowth。对七项变量基于相关矩阵提取主成分,参照特征值大于1和碎石图保留三个成分,再用主成分因子法得到得分。综合指标按(0.3276×F1+0.1897×F2+0.1470×F3)/0.6642生成,权重来自本案例的解释比例,重新选样本或变量时需重新估计。

以下字段、样本量及样本仅对应当前展示的数据表,不代表资料包全部文件。查看文件结构

字段列表共 14 个字段

字段含义 / 说明类型均值标准差最小值最大值缺失率
id证券代码整数315212.5329281121.565428733390.0000%
Symbol股票代码文本————0.0000%
year年份整数2014.3053186.06115733200120220.0000%
Size企业规模数值21.995541031.36037057612.3142499928.636489870.0000%
Lev资产负债率数值0.49662892444.104451339-0.1946980208877.25592040.0000%
ROA净利润除以平均总资产数值0.032173954280.1835347611-16.1124458320.787637710.0000%
ROE净资产收益率数值0.083687291176.495120251-174.89472961389.551270.0000%
NetProfit销售净利率数值-6.0548306841299.008747-287764.2513357.553710.0000%
Liquid流动比率数值2.3048191233.396045805-5.131644726204.74211120.0000%
Quick速动比率数值1.8216741343.088406969-5.131644726179.57827760.0000%
Growth营业收入增长率数值3.644552141610.7202685-2.733487606134607.06250.0000%
AssetGrowth总资产增长率数值0.337535246417.29253249-0.99971735483741.2436520.0000%
NetProfitGrowth净利润增长率数值2.403368666545.28929-5712.554688113550.56250.0000%
TobinQ托宾Q值数值2.1267345018.5805428470.60851901771739.055420.0000%

数据样本预览

资料样本(部分数据)

仅可预览前100 行、100 列,滚动查看其余行列,完整数据以下载文件为准。

idSymbolyearSizeLevROAROENetProfitLiquidQuickGrowthAssetGrowthNetProfitGrowthTobinQ
2000002200122.59243583680.5177965760230.06310851126910.1254059076310.08573821187021.991119503970.4450236856940.1774457991120.1530819237230.2274973988531.59997296333
2000002200222.8293285370.5829439163210.05416089668870.1214943304660.0870172753932.532806158070.5769608020780.02677735500040.2673043906690.04209506884221.21047496796
2000002200323.08043670650.5492432117460.06027530878780.1382426321510.08869674801832.13762855530.3224116861820.3947439491750.2854513823990.4216631650921.31798899174
2000002200423.46632385250.5941627621650.0699473097920.1649636328220.1190330982212.413574934010.7353442311290.2017482072110.4709178507330.6127740740781.2978130579
2000002200523.81396293640.6098094582560.07639474421740.1925913542510.1357558369641.831064462660.4636790752410.377140998840.415719956160.570612907411.31527101994
2000002200624.60499382020.6494181156160.06548738479610.1804369986060.1293373703962.041482925420.6338946819310.6903552412991.205668091770.6104360818861.90020501614
2000002200725.32938003540.6611248850820.07156682759520.2088344246150.1496765613561.956627488140.5937518477440.9904859066011.063466548921.303503513342.52022099495
2000002200825.50437545780.6744409203530.04230927675960.1275774538520.1131902337071.757549643520.4268952310090.1538330763580.191240459681-0.1274342387911.24914503098
2000002200925.64767837520.6700167655940.05006913840770.1526826918130.1315440684561.914877653120.5912283658980.1924589276310.1540800184010.3858165740971.51115596294
2000002201026.09686470030.7468613386150.05004788562660.1768015623090.1743036657571.58518683910.5567823648450.03749591484670.5670359730720.3747434020041.16538894176
2000002201126.41432952880.7709972858430.04532459378240.1895070374010.1615932285791.408134698870.3702153265480.4154466092590.3736403286460.3122304677961.0426800251
2000002201226.66027832030.7831630110740.04640697687860.2088752686980.1518925428391.396177291870.4141482710840.4365045428280.278834640980.3502689898011.07689201832
2000002201326.89539527890.7799702882770.04265128448610.1950931102040.1351182460781.343925952910.3372027873990.313263416290.2650561928750.1682328283790.968693971634
2000002201426.95455169680.7720463871960.03905882686380.1742850840090.1317561715841.34471368790.4255101978780.08100215345620.0609413757920.05410419404511.06491398811
2000002201527.13884735110.7770152091980.04635052010420.2057819515470.1327003538611.302247285840.4258955121040.3358275592330.2023702561860.3454001545911.19234704971
2000002201627.44550323490.8053670525550.03932156786320.1902789920570.1178916394711.243616104130.4378185570240.2297535538670.358874917030.09251905232671.0690100193
2000002201727.7840404510.8398125767710.03728255629540.2136261314150.1531857997181.200857162480.4950286149980.01006279606370.402892857790.3124533295631.11796295643
2000002201828.05536079410.8458563685420.03658028319480.2333550304170.1655213832861.154341578480.4855713248250.2255367338660.3116946816440.3242254853251.01573598385
2000002201928.1791019440.8435894846920.03383855521680.2178254872560.1498573869471.130738377570.4258729815480.2358731031420.1317236721520.1189171373841.04627203941
2000002202028.25651931760.8128350377080.03295157477260.1911536455150.1414852440361.174493908880.4139105081560.1392189562320.08049324899910.07557373493910.992654025555
2000002202128.2930068970.7973975539210.01999546960.1025279909370.08407622575761.220231533050.4000554084780.08037498593330.0371612906456-0.3579977154730.929695010185
2000002202228.19470024110.7695146203040.02032106183470.09414035826920.07452967762951.313188314440.4716076254840.112722709775-0.0936294794083-0.0136229088530.908088982105
3000003200120.91548919681.819934129710.00621688133106-0.01544034760450.3147262334820.474856793880.263056874275-0.921229064465-0.514143645763-1.019244670872.32204294205
4000004200119.21822738650.4607225954530.0351888574660.1067855209110.2072733044621.536372423171.35961639881-0.526860117912-0.563152551651-0.4286709129814.86612510681
4000004200219.38999938960.5295407772060.03382346034050.06738810986280.06774750351911.502557396891.336169362070.9557419419290.187406092882-0.3607636392123.13538098335
4000004200319.28725624080.4601395130160.03047472611070.06054034829140.0639259219171.714483857151.44945585728-0.0139463841915-0.0976404547691-0.06956887245182.19971609116
4000004200419.18274879460.427696019411-0.0145215764642-0.0261539109051-0.03075410984461.882196307181.55690157413-0.106974586844-0.0992323383689-1.429625511172.04006099701
4000004200518.86452484130.358843773603-0.10038074106-0.166940003633-0.3026784658432.163711786272.00833082199-0.42503029108-0.2725599110134.658786773681.78839504719
4000004200619.13512229920.4504149854180.01696493476630.02879251539710.0669418573381.642169117931.3901913166-0.2564119696620.310747742653-1.164455533031.7034560442
4000004200718.95026397710.424183577299-0.0534682832658-0.0952253863215-0.2472703009841.974073529241.46043455601-0.113706618547-0.16877758503-4.273796558384.38372707367
4000004200818.93834686280.491793423891-0.0680276229978-0.125462919474-0.2651330530641.316346764560.6945990920070.0708359926939-0.01184770930560.1481928974392.06604599953
4000004201019.03163909910.2985742688180.09741856157780.184460207820.1538189500571.835651993751.040489673611.18592178822-0.2008251696833.456949472435.78135299683
4000004201119.09519195560.2949351668360.04831760376690.06870096921920.1233907267451.921917200091.18825888634-0.4327048659320.0656162276864-0.5449262857443.752368927
4000004201219.0777530670.232527613640.04015317559240.05455620214340.08025842905043.020583629611.904442667960.306824713945-0.0172874461859-0.1499872058633.78997397423
4000004201319.30507659910.4032394289970.02664769999680.03962740674610.07964256405832.328330039981.23478102684-0.2524435222150.255236119032-0.2581798434264.43922901154
4000004201419.63939285280.534754455090.05383831635120.1035128533840.1938350349661.759326577190.4661133587360.1074987873440.3969840109351.695443868644.39581823349
4000004201519.8036537170.590401709080.01860938966270.04276626184580.0569273568691.596114277840.3761572837830.4943082332610.178522124887-0.56113708019310.146903038
4000004201619.22588920590.2034563124180.1276252120730.2326020896430.1380620598793.657461166383.469742298131.38820648193-0.4388483464724.7919554710416.8639278412
4000004201719.40964317320.3152466118340.0239249411970.03252759575840.04251077398662.068985223771.8578915596-0.5181776881220.201719790697-0.8516417741787.22983598709
4000004202021.17023277280.06826370954510.04054232686760.04333038255570.2209748327735.195586681375.147918224331.591589570050.0462181679904-18.20044898991.63727104664
4000004202120.82813835140.146163895726-0.380365908146-0.422918140888-1.760113239293.934656620033.803000211720.0299901720136-0.289718389511-9.204098701482.39751791954
4000004202220.17056083680.387338280678-0.706957995892-0.916309773922-3.580078840262.412153959272.40669369698-0.423891186714-0.4818959832190.1718080937862.42055702209
5000005200121.37783622740.43296533823-0.036537848413-0.0746051445603-1.073625564580.706150412560.474924296141-0.540052235126-0.04768327251086.739645957951.70546400547
5000005200221.32240295410.463338851929-0.0500366315246-0.090601965785-1.70521795750.6001979708670.360412120819-0.18151819706-0.05392370745540.2999781668191.65345799923
5000005200321.30032920840.4795762896540.000511460937560.0009675179026090.01005702186380.5539742708210.4061334431170.666726589203-0.0218321178108-1.009829998021.2860519886
5000005200421.31692886350.5093521475790.0009413231746290.001862485893070.0342325195670.6251657009120.388773262501-0.4607916474340.01673828251660.8353802561761.19546401501
5000005200521.22032165530.598387420177-0.104195065796-0.23243355751-3.964471101760.3997166156770.127301171422-0.0806522667408-0.0920886546373-107.4697494511.16114401817
5000005200621.14741706850.5408641099930.03456255793570.08050417155030.1670996993780.3879380524160.1769657433036.22672128677-0.070309266448-1.304601311681.69538402557
5000005200721.09966087340.48500508070.05183682218190.1065727025270.2587508559230.3214343786240.205811411142-0.0884912908077-0.04663364216690.4114547073844.14511680603
5000005200821.05187225340.4586451351640.007378437556330.01397801935670.09657555818560.4397117495540.328270107508-0.636425495148-0.0466654226184-0.8643003106121.87054502964
5000005200921.00029373170.467574954033-0.0361264981329-0.0672740414739-1.132593750950.3066331446170.245126411319-0.602719187737-0.0502705425024-5.659127235414.63765621185
5000005201020.98070144650.477960318327-0.00338821625337-0.00642579980195-0.03225424885750.3644595742230.2767003774642.17727160454-0.0194020755589-0.9095169901853.07060909271
5000005201221.00067138670.4831415414810.01706911250950.03281822428110.2214981466530.5543901324270.5305512547490.5648300647740.04689584672450.9292414188392.53986096382
5000005201320.89608764650.474830955267-0.0337629504502-0.0648294240236-0.8133571147920.4624024033550.435130119324-0.476352244616-0.0993015319109-2.92287206652.39697194099
5000005201421.03563880920.5099635720250.0337836220860.06671607494350.8178552985190.3782062232490.3544150888920.0137393046170.149757519364-2.019345760353.25151491165
5000005201521.50899696350.447039991617-0.0303491633385-0.0573915876448-0.6422715187070.8322983980180.5018971562390.5939894318580.605375647545-2.251778841024.70405483246
5000005201621.65039253230.4637084901330.04954728856680.09107328951360.2427293956280.808670997620.4490075111394.727879524230.15188023448-3.164699316022.98119997978
5000005201721.79214096070.5177473425870.008433380164210.01662207394840.04320028424260.8606472611430.557930052280.1018105819820.152286812663-0.8039029240611.91894805431
5000005201821.86155509950.4940399229530.05195923522110.1050705388190.3224079906941.144871473310.832409143448-0.08427082747220.07188056409365.834177017211.36203694344
5000005201921.83243560790.4253374338150.05801754817370.1074774712320.323010683061.245190024380.8963971734050.136632457376-0.02869921550150.1387573033571.50389897823
5000005202021.62049484250.459425002337-0.140834406018-0.251751542091-0.9681432247161.237466216091.22510147095-0.27811345458-0.190988138318-3.163673162461.55097305775
5000005202121.62925529480.4038181304930.05660897865890.09957599639890.3636191487311.471567034721.45540726185-0.03856615722180.0087989801541-1.361099243161.3875399828
5000005202221.67961883540.497159123421-0.0634088888764-0.115638688207-0.5672365427021.82507467271.81170964241-0.2601906955240.0516544170678-2.154083490371.25364100933
6000006200122.16284942630.6840093731880.03306611627340.1019418761130.0653970539571.342125058170.7010269761090.07456895709040.113819345832-0.03013618290421.2204220295
6000006200222.2253150940.6909354925160.01870893687010.05988403037190.03905742987991.348628878590.6339234113690.03056009300050.0644576326013-0.3845131695271.09476196766
6000006200322.10158920290.727630853653-0.0727504566312-0.249273091555-0.1548505872491.265462875370.559732437134-0.0474371090531-0.116377733648-4.77661609651.03928697109
6000006200422.11468315120.7189990282060.01220981404190.04412442073230.0259837042541.209669709210.631308734417-0.05541593581440.0131801879033-1.158499836920.98724001646
6000006200521.66056251530.5575793981550.03170938044790.09226065129040.07268651574851.749397397040.618306994438-0.236077263951-0.3649933636191.136988759040.988618016243
6000006200621.79448127750.5455815792080.07874862849710.1754568219180.1717412620781.191396117210.275476843119-0.1250645220280.1432992666961.067268133161.53058898449
6000006200722.44038009640.6774184107780.05947759002450.1616580635310.2464788407092.65985465050.561614453793-0.1837335526940.9076990485190.1714855432511.74851095676
6000006200822.50184631350.7166751623150.02614668756720.08647816628220.1470143049961.738363146780.080642439425-0.002239845693110.0633950829506-0.4048778414731.1265399456
6000006200922.70730018620.6985768079760.05081649869680.1732575297360.1812764853244.413338661190.5857905745510.809880733490.2280838191511.231679558751.4754229784
6000006201022.87133598330.7014206051830.06268367916350.2090257704260.2122793644672.034830570220.4672765433790.2647032439710.1782549321650.4809995889661.31191802025
6000006201122.84216499330.6528552174570.05140437185760.1593894660470.1676596552131.392665624620.1558095514770.107126623392-0.028748774901-0.1255839914081.13711297512
6000006201222.95793914790.6201649904250.07127664238210.1955812275410.2046538442371.707720875740.4337339401250.1880718618630.1227420568470.4502204954621.29654705524
6000006201323.02266120910.5799717307090.07228913903240.1804603934290.1513838768012.50162076950.7117435336110.498858153820.06686300039290.1087158322331.24548900127
6000006201423.18739318850.6414202451710.04718426242470.1219927892090.220057129861.752962350850.492266386747-0.4949462413790.179075926542-0.2658354341981.44748604298
6000006201523.26514434810.6461507678030.03588264435530.1007592454550.1200735494492.458832263950.484841078520.5692287683490.0808533206582-0.1437547653911.86304795742
6000006201623.30123710630.6104992032050.06213805079460.1670392602680.2393325567252.433238744740.742604315281-0.08085878938440.03675216808920.8320472240451.57695305347
6000006201823.32867240910.5282362699510.06920861452820.1526650935410.3675097823141.917971849440.73397564888-0.1512462645770.03019778989260.1251030862331.04475605488
6000006201923.47980880740.5446121096610.05758237093690.1243791952730.2259422093632.420668125150.8764184117320.485494136810.163155570626-0.08672957867381.00416994095
6000006202023.45988845830.4921852946280.05791454389690.1203193590040.3076566159732.83207106590.955155789852-0.213488712907-0.01972400769590.07096149772410.982861995697
6000006202123.88455581670.6532196402550.0283580850810.06908965855840.1792059391742.117493391040.3736554384230.05241949111220.529083371162-0.3869794607160.908334970474
6000006202223.99659347530.6791756153110.01792165264490.0538064762950.1210985705262.025056123730.4934738576410.1979048252110.118555009365-0.1905147582291.00134503841
7000007200120.82055091860.8297898769380.01240452658390.07826175540690.03750154376030.7771576046940.3355351388455.514026641850.157880052924-1.07133400441.5358710289
7000007200220.86382484440.7733244895940.007599816191940.0381797440350.03766294568780.7484978437420.450208038092-0.3308514654640.0442242138088-0.327971518041.41775500774
7000007200320.83452415470.7634611725810.01399532891810.06044586747880.04746026173230.7213906645770.4276519417760.471443921328-0.02887450717390.8542127609251.20706403255
7000007200420.77054977420.909255623817-0.142546162009-0.858853638172-1.137892723080.5847608447070.246784254909-0.594376981258-0.0619709119201-10.72509384161.20621800423
7000007200520.56577873230.8729908466340.01081996597350.1010959148410.02936098910870.5413932204250.2955090701581.58400809765-0.185166150331-1.066675066951.22951102257
7000007200620.50744247440.97874546051-0.120042093098-1.58631050587-0.514317870140.3961212635040.284673601389-0.447380840778-0.0566679164767-10.68025684361.34925699234
7000007200720.4183464051.011333942410.01125508826231.979536652570.04686066135760.4322918653490.401762008667-0.0435330681503-0.0852420479059-1.087145924572.48555803299
7000007200820.23003578191.12261474133-0.09646186232571.5621137619-0.4088766574860.4584985673430.425259500742-0.142022058368-0.171643331647-8.486175537111.86402702332
7000007200919.71066093441.149898886680.0419350005686-0.3157954812050.1531808078290.2823496162890.22953504324-0.161511823535-0.405107080936-1.31412971024.72933197021
7000007201019.62191390991.098531007770.0623842775822-0.4976653158660.1514400243760.2910140454770.2330159544940.0748694911599-0.08492274582390.06265444308525.855905056
7000007201119.70830154420.1934203952550.02392083778980.06403487920760.05026347190142.080537319181.805181384090.1538635641340.0902276560664-0.6170286536223.71228790283
7000007201220.48713874820.624158442020.00769605906680.01505079399790.01417906582361.190721750261.152711033820.8910475969311.17893743515-0.4665452539924.08606290817
7000007201320.30397415160.4627542495730.02602364309130.05793674662710.08785039186481.386185407641.32679069042-0.31444644928-0.1673691719773.24753999714.47149181366
7000007201420.33896255490.474294364452-0.0498830266297-0.0938754156232-0.168515935541.47646236421.4207174778-0.07581426203250.0356089770794-2.77278685574.94588708878
7000007201519.99005508420.2238474786280.02280029095710.0362310595810.1337780505422.678238630292.53474903107-0.500441551208-0.294541478157-1.3965795040110.5003356934
7000007201620.05844879150.1499620676040.1639998406170.2013854235412.098999500273.357610940933.16295075417-0.6073178648950.07078620791445.1612467765810.5048475266

代码公开披露

仅展示前 30 行,供了解变量构造与处理流程,完整代码请下载文件查看。

///主成分分析命令+案例解析
///更多stata学习资料尽在丘知数据分析会员之家,网址:www.qqrdata.com
use 案例数据,replace
///////////////////////////////////////////////////////////////////////////////////////
///第一步检验主成分分析可行性,KMO抽样Bartlett球形检验
//首先安装所需命令
ssc install factortest
//进行检验
factortest Size Lev ROA ROE NetProfit Liquid Quick Growth AssetGrowth NetProfitGrowth TobinQ
/*结果如下
Determinant of the correlation matrix
Det                =     0.004
 
 
Bartlett test of sphericity
    
Chi-square         =          2.67e+05
Degrees of freedom =                55
p-value            =             0.000
H0: variables are not intercorrelated
 
 
Kaiser-Meyer-Olkin Measure of Sampling Adequacy
KMO               =     0.487
*/
//如果P值趋近于0,KMO值大于0.5即可进行主成分分析(一般0.6以上最好)
///更多stata学习资料尽在丘知数据分析会员之家,网址:www.qqrdata.com
//如果KMO值小于0.5,本例子就是KMO值小于0.5,那我们可以采用以下手段来进行优化
//缩减样本区间
keep if year>2004