[编程问题求助] 面板数据：用股票的月换手率求年几何平均值，如何进行stata编程？ [推广有奖]

0关注
0粉丝

本科生

99%

还不是VIP/贵宾

威望: 0 级
论坛币: 27 个
通用积分: 3.1392
学术水平: 0 点
热心指数: 0 点
信用等级: 0 点
经验: 564 点
帖子: 24
精华: 0
在线时间: 217 小时
注册时间: 2019-3-9
最后登录: 2021-7-8

楼主

西柚柠檬大橙子 发表于 2019-11-2 22:05:57 |AI写论文

是否 +2 论坛币

k人参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

---------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. To install: ssc install dataex
clear
input long(company_id yearmonth) int year byte month double(Dturn year_month)
2 200001 2000 1 .253203 480
2 200002 2000 2 1.046568 481
2 200003 2000 3 .854387 482
2 200004 2000 4 .327294 483
2 200005 2000 5 .181676 484
2 200006 2000 6 .337082 485
2 200007 2000 7 .451299 486
2 200008 2000 8 .297897 487
2 200009 2000 9 .115802 488
2 200010 2000 10 .1197 489
2 200011 2000 11 .280428 490
2 200012 2000 12 .183124 491
2 200101 2001 1 .310418 492
2 200102 2001 2 .213741 493
2 200103 2001 3 .241581 494
2 200104 2001 4 .217848 495
2 200105 2001 5 .122045 496
2 200106 2001 6 .180703 497
2 200107 2001 7 .128894 498
2 200108 2001 8 .201243 499
2 200109 2001 9 .240781 500
2 200110 2001 10 .271845 501
2 200111 2001 11 .113982 502
2 200112 2001 12 .084369 503
2 200201 2002 1 .11933 504
2 200202 2002 2 .05195 505
2 200203 2002 3 .193283 506
2 200204 2002 4 .064664 507
2 200205 2002 5 .052395 508
2 200206 2002 6 .214634 509
2 200207 2002 7 .128371 510
2 200208 2002 8 .042145 511
2 200209 2002 9 .03081 512
2 200210 2002 10 .0238 513
2 200211 2002 11 .071743 514
2 200212 2002 12 .042171 515
2 200301 2003 1 .115331 516
2 200302 2003 2 .05402 517
2 200303 2003 3 .339152 518
2 200304 2003 4 .559557 519
2 200305 2003 5 .258095 520
2 200306 2003 6 .25112 521
2 200307 2003 7 .146571 522
2 200308 2003 8 .094816 523
2 200309 2003 9 .099951 524
2 200310 2003 10 .053649 525
2 200311 2003 11 .086058 526
2 200312 2003 12 .233816 527
2 200401 2004 1 .370427 528
2 200402 2004 2 .425709 529
2 200403 2004 3 .316912 530
2 200404 2004 4 .300408 531
2 200405 2004 5 .074053 532
2 200406 2004 6 .088791 533
2 200407 2004 7 .120863 534
2 200408 2004 8 .141589 535
2 200409 2004 9 .170309 536
2 200410 2004 10 .254918 537
2 200411 2004 11 .107131 538
2 200412 2004 12 .086531 539
2 200501 2005 1 .132338 540
2 200502 2005 2 .146414 541
2 200503 2005 3 .202929 542
2 200504 2005 4 .172808 543
2 200505 2005 5 .121521 544
2 200506 2005 6 .154144 545
2 200507 2005 7 .262118 546
2 200508 2005 8 .523 547
2 200509 2005 9 .246037 548
2 200510 2005 10 .16829 549
2 200511 2005 11 .066583 550
2 200512 2005 12 .328783 551
2 200601 2006 1 .269683 552
2 200602 2006 2 .293663 553
2 200603 2006 3 .328596 554
2 200604 2006 4 .432378 555
2 200605 2006 5 .541565 556
2 200606 2006 6 .357478 557
2 200607 2006 7 .301796 558
2 200608 2006 8 .280315 559
2 200609 2006 9 .248951 560
2 200610 2006 10 .217543 561
2 200611 2006 11 .423739 562
2 200612 2006 12 .375084 563
2 200701 2007 1 .496814 564
2 200702 2007 2 .280631 565
2 200703 2007 3 .396091 566
2 200704 2007 4 .438447 567
2 200705 2007 5 .519565 568
2 200706 2007 6 .536152 569
2 200707 2007 7 .356872 570
2 200708 2007 8 .432123 571
2 200709 2007 9 .312321 572
2 200710 2007 10 .342687 573
2 200711 2007 11 .195396 574
2 200712 2007 12 .272359 575
2 200801 2008 1 .313926 576
2 200802 2008 2 .134114 577
2 200803 2008 3 .307993 578
2 200804 2008 4 .31179 5794 200001 2000 1 1.025277 480
4 200002 2000 2 1.10933 481
4 200003 2000 3 .842801 482
4 200004 2000 4 .645771 483
4 200005 2000 5 .586508 484
4 200006 2000 6 .478441 485
4 200007 2000 7 .260105 486
4 200008 2000 8 .464024 487
4 200009 2000 9 .354171 488
4 200010 2000 10 .255676 489
4 200011 2000 11 .405103 490
4 200012 2000 12 .21463 491
4 200101 2001 1 .074732 492
4 200102 2001 2 .135594 493
4 200103 2001 3 .299614 494
4 200104 2001 4 .22519 495
4 200105 2001 5 .127321 496
4 200106 2001 6 .116547 497
4 200107 2001 7 .214431 498
4 200108 2001 8 .079554 499
4 200109 2001 9 .093586 500
4 200110 2001 10 .044705 501
4 200111 2001 11 .160581 502
4 200112 2001 12 .070961 503
4 200201 2002 1 .089247 504
4 200202 2002 2 .045986 505
4 200203 2002 3 .147082 506
4 200204 2002 4 .124492 507
4 200205 2002 5 .090563 508
4 200206 2002 6 .522493 509
4 200207 2002 7 .217536 510
4 200208 2002 8 .055064 511
4 200209 2002 9 .058525 512
4 200210 2002 10 .023728 513
4 200211 2002 11 .199744 514
4 200212 2002 12 .187404 515
4 200301 2003 1 .113416 516
4 200302 2003 2 .174253 517
4 200303 2003 3 .060393 518
4 200304 2003 4 .156531 519
4 200305 2003 5 .061072 520
4 200306 2003 6 .036473 521
4 200307 2003 7 .087703 522
4 200308 2003 8 .06256 523
4 200309 2003 9 .033859 524
4 200310 2003 10 .045129 525
4 200311 2003 11 .134644 526
4 200312 2003 12 .52914 527
4 200401 2004 1 .185485 528
4 200402 2004 2 .523027 529
4 200403 2004 3 .545273 530
4 200404 2004 4 .26395 531
4 200405 2004 5 .20836 532
4 200406 2004 6 .271628 533
4 200407 2004 7 .384065 534
4 200408 2004 8 .340098 535
4 200409 2004 9 1.151521 536
4 200410 2004 10 .542317 537
4 200411 2004 11 .695472 538
4 200412 2004 12 .550001 539
4 200501 2005 1 .243833 540
4 200502 2005 2 .131315 541
4 200503 2005 3 .194365 542
4 200504 2005 4 .26725 543
4 200505 2005 5 .196051 544
4 200506 2005 6 .272657 545
4 200507 2005 7 .163518 546
4 200508 2005 8 .639303 547
4 200509 2005 9 .500332 548
4 200510 2005 10 .329761 549
4 200511 2005 11 .207396 550
4 200512 2005 12 .316831 551
4 200601 2006 1 .450757 552
4 200602 2006 2 .227481 553
4 200603 2006 3 .278913 554
4 200604 2006 4 .387536 555
4 200605 2006 5 .557312 556
4 200606 2006 6 .459994 557
4 200607 2006 7 .183426 558
4 200608 2006 8 .268487 559
4 200609 2006 9 .404668 560
4 200610 2006 10 .302771 561
4 200611 2006 11 .580867 562
4 200612 2006 12 .539762 563
4 200701 2007 1 .790358 564
4 200702 2007 2 .491342 565
4 200703 2007 3 .904668 566
4 200704 2007 4 .90408 567
4 200705 2007 5 1.135162 568
4 200706 2007 6 1.163089 569
4 200707 2007 7 .821519 570
4 200708 2007 8 .951064 571
4 200709 2007 9 .58873 572
4 200710 2007 10 .506808 573
4 200711 2007 11 .576737 574
4 200712 2007 12 .522438 575
4 200801 2008 1 .739741 576
4 200802 2008 2 .25136 577
4 200803 2008 3 .296602 578
4 200804 2008 4 .260901 579
end
format %tm year_month

复制代码

------------------ copy up to and including the previous line ------------------
Listed 100 out of 418794 observations
Use the count() option to list more
.
我想计算的是第t年i股票月换手率的几何平均数，其中Dturn是股票的月换手率，最后一列是stata的年月格式的日期，请教大家！