I provide a sample of my data in the following:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input long GVKEY double fyear float(DA_JONES DA_MJONES DA_LU DD McNicols) double RET_w float(FRET_w taac_w CFO_w lcfo_w fcfo_w) 1004 1990 -8.256 -8.256 -8.256 . . .09090909361839294 -.010526316 -8.256 0 . . 1004 1991 13.341337 13.26765 13.652452 -.04802015 .008925857 -.010526316240429878 .05454545 -.7839892 .0231973 .0970923 .0442312 1004 1992 -8.141216 -8.2323475 -7.350275 -.0796989 -.00977255 .05454545468091965 .01904762 -10.759987 .04250906 .022294113 .016939377 1004 1993 13.566643 14.117864 14.09556 .04626517 .07532828 .01904761977493763 .1972789 23.50899 .018340359 .0460248 .04177724 1004 1994 -14.492256 -14.055967 -14.265173 -.06504817 -.05583758 .1972789168357849 .012552301 -6.257996 .0365279 .016035879 .0592875 1004 1995 -2.4286425 -2.6148415 -3.132785 -.02797665 .017469876 .012552301399409771 .004862237 -11.09899 .05814746 .035825502 .02238301 1004 1996 23.730614 24.75957 24.756886 .028092774 .05883552 .00486223679035902 -.05445544 25.106005 .02176793 .05654956 .05212563 1004 1997 26.225645 27.268093 25.745283 -.06367623 -.0529479 -.05445544421672821 .0871212 25.333 .04309609 .017997146 .05386303 1004 1998 24.24059 24.246626 24.074104 -.01340166 .008550974 .08712121099233627 .21686748 7.257001 .04253913 .03403578 .014988987 1004 1999 .9719733 -.6571926 -1.0798613 -.02949971 -.02102535 .21686747670173645 .10552155 1.4869937 .01383235 .03925657 .06343394 1004 2000 9.092382 8.997414 11.744568 .030657284 .02975682 .1055215522646904 -.06363635 -18.132002 .06220395 .01356414 -.04495963 1004 2001 -98.74294 -99.30154 -99.65705 -.1093418 -.09630986 -.06363634765148163 .4292543 -117.48099 -.04746714 .0656732 .0494875 1004 2002 -91.93835 -91.81636 -91.71247 -.1586378 -.13920915 .42925429344177246 -.0036576584 -115.159 .04890601 -.04690939 .020518193 1004 2003 46.02369 46.45681 48.29313 .0822738 .0838898 -.003657658351585269 .14374404 69.57001 .02122277 .0505854 .07418649 1004 2004 -2.1880944 -1.8565302 -3.930658 .001778974 -.007355464 .14374403655529022 .09778114 -13.87401 .071815275 .02054443 -.05707382 1004 2005 -37.128277 -35.798073 -41.60302 .09017174 .06219852 .09778113663196564 .15172617 11.696993 -.05528591 .06956557 -.029005915 1004 2006 -9.966827 -6.390003 3.485631 -.0852655 -.0926004 .15172617137432098 .08677682 -41.22898 -.0216986 -.041358 .017292269 1004 2007 112.59082 114.2914 114.39149 .2093206 .24702795 .08677681535482407 .23151124 109.691 .01585376 -.01989354 .06036812 1004 2008 80.36669 81.13081 88.91612 .01760847 .010085392 .23151123523712158 .11848534 -11.70304 .0473205 .01242722 .11244851 1004 2009 -7.288349 -6.435791 -4.799705 -.05543999 -.02274436 .11848533898591995 .0498357 -64.81002 .11118314 .04678801 .0788364 1004 2010 -87.20821 -83.28567 -82.80732 -.069902174 -.06407525 .0498356968164444 .21614587 -77.26303 .07234841 .10203312 .06276773 1004 2011 42.15107 43.78926 41.42621 .008975395 .00616803 .21614587306976318 -.10281868 1.4510243 .05530053 .06374143 .0956139 1004 2012 -36.488354 -36.662605 -40.34578 .027520867 .02850782 -.10281867533922195 .08388613 -61.52596 .07419205 .0429107 .06367126 1004 2013 2.404595 1.8305283 -9.236383 .023641456 .032485448 .08388613164424896 .0704398 -57.19995 .06542188 .07623193 -.02012261 1004 2014 -146.50688 -146.78801 -133.66913 -.05299955 -.034832798 .07043980062007904 -.10409325 -230.5 -.019549897 .0635599 .014594226 1004 2015 -8.2277775 -7.518768 -15.15935 .04192104 .04855819 -.10409325361251831 -.05507458 -45.29998 .02118812 -.02838284 .014389439 1004 2016 -10.257802 -10.399855 -7.814354 -.03497087 -.05522114 -.055074576288461685 -.14534216 -40.79997 .015116843 .022259206 .04458775 1004 2017 10.244425 8.082229 5.721819 .002455582 -.006106112 -.145342156291008 .009174309 -5.299993 .04274982 .014493718 .04481085 1004 2018 28.68169 28.503075 23.173126 . . .009174308739602566 . -47.40002 .04420542 .04217223 . 1009 1990 -1.971 -1.971 -1.971 . . -.09276595711708069 .06105263 -1.971 0 . . 1009 1991 28.37594 28.913557 28.58571 -.037147727 -.0022268018 .061052631586790085 .05523809 -4.066 .10449977 .064171955 .1862997 1009 1992 23.671753 24.004135 20.221943 .09815284 .07041661 .05523809418082237 -.07916667 -.4080001 .1694086 .09502517 .0969375 1009 1993 19.16707 20.36717 12.944288 -.011516947 .07054906 -.07916666567325592 -.12592593 -.7340001 .08211835 .14351057 .04585954 1009 1994 17.27624 18.681213 18.086359 . . -.1259259283542633 . .37299985 .030079534 .0538619 . 1011 1990 -.7 -.7 -.7 . . -.023255813866853714 . -.7 0 . . 1011 1991 319.2774 347.9676 296.8991 .18493855 .16803867 . . -.3019999 -.03121788 -.10033402 -.120889 1011 1992 434.8656 431.133 432.77075 .896776 .9381768 . .016949153 -1.7770003 -.10791284 -.02786697 -.09369266 1011 1993 409.49625 413.17825 419.7848 -.25659484 -.29623902 .016949152573943138 .16666667 2.7829995 -.04785334 -.05511627 .1592573 1011 1994 729.5606 735.9243 591.38464 . . .1666666716337204 . -21.056 .10884708 -.032706164 . 1013 1990 -11.98 -11.98 -11.98 . . .05376344174146652 .035 -11.98 0 . . 1013 1991 21.097996 21.17002 21.111187 .10109564 .03214332 .03500000014901161 .02209945 -4.770001 .20203672 .1909834 .1913137 1013 1992 11.73341 11.80088 11.055116 .01678054 .030943803 .0220994483679533 .032608695 -9.738998 .14061229 .14849354 .11914115 1013 1993 27.331835 28.06971 28.23423 -.024916973 -.024165554 .032608695328235626 .20481928 -2.605005 .12231167 .14435418 .24173667 1013 1994 7.117548 7.185659 7.245049 .06363347 .07716833 .20481927692890167 -.1978022 -10.461004 .20782064 .10515115 .1580374 1013 1995 45.54981 47.1945 45.04772 .55047464 .5162946 -.19780220091342926 -.14137931 11.45099 .13224116 .17389837 .18960273 1013 1996 42.23747 45.6678 13.55961 -.10399084 -.14522167 -.14137931168079376 .12268908 20.111986 .1055711 .07363209 .13261563 1013 1997 63.14164 68.35321 70.139206 -.04137847 -.08877397 .12268907576799393 .1631799 33.229984 .10368969 .08254408 .10676605 1013 1998 -84.18027 -70.15776 -76.247345 .04673602 .0399762 .1631799191236496 .3610786 -130.65698 .0876618 .0851359 .3548862 1013 1999 188.676 192.12286 179.5814 .06110387 -.00006085868 .36107856035232544 -.10216718 179.145 .25548542 .06310842 .1702308 1013 2000 761.3878 773.45 764.5245 .4527775 .23573594 -.10216718167066574 .036036 438.281 .13237438 .1986698 .05680021 1013 2001 -1130.5537 -1144.9546 -1141.7229 -.2415796 -.1805559 .03603599965572357 -.036866434 -1232.9 .02392646 .05576124 .015237376 1013 2002 -368.1365 -371.1822 -380.7026 -.12113004 -.06192207 -.036866433918476105 .2122449 -452.2999 .024202906 .03800456 .015561868 1013 2003 52.38578 52.39902 56.43102 .3409744 .4028691 .2122448831796646 .14042561 -48.30001 .033997554 .05287537 .0027093166 1013 2004 79.53783 82.94804 74.94458 -.22469953 -.1628078 .14042560756206512 .09251098 -22.9 .002390315 .0299946 .04518467 1013 2005 432.2295 436.8245 443.734 -.02789532 -.04582892 .09251098334789276 .05366206 349.8 .04103354 .0021707164 .06099013 1013 2006 107.40763 105.42643 98.39964 .016571395 .030515723 .05366205796599388 -.0609903 16.200003 .05674267 .0381759 .09237785 1013 2007 -497.442 -494.31305 -483.5091 -.1173807 -.08935453 -.06099029630422592 -.2306611 -593.60004 .087998 .05405238 .10897356 1013 2008 244.1038 246.96454 284.88773 .1587128 .14463033 -.230661079287529 .013050558 71.700005 .09950136 .08034904 .04527425 1013 2009 9.257248 9.777885 6.098389 -.0696949 -.0518992 .013050558045506477 . -105.7 .04159292 .09141073 .071108796 1013 2010 258.623 261.78693 259.55957 . . . . 110.69998 .10166717 .0594671 . 1017 1990 -6.271 -6.271 -6.271 . . .18918919563293457 .12 -6.271 0 . . 1017 1991 42.48269 40.51878 40.15167 .09641416 .10694478 .11999999731779099 -.08571429 -6.208 .10369116 .08460887 .02586353 1017 1992 53.02612 53.90828 52.90792 -.08978355 -.03552302 -.08571428805589676 .02777778 -.24199827 .027143976 .10882469 .07833102 1017 1993 33.416042 33.385918 32.522724 -.06246643 -.05924939 .02777777798473835 .0045045046 -17.566998 .07689758 .026647244 .015918566 1017 1994 44.66039 45.34223 41.02727 . . .0045045046135783196 . 1.0179987 .01671919 .08076514 . 1021 1990 -1.325 -1.325 -1.325 . . .11764705926179886 -.125 -1.325 0 . . 1021 1991 -.9145064 -1.3242712 -.13994789 -.2242146 -.15047126 -.125 -.1 -7.542 .036310025 .025006505 .11005753 1021 1992 28.126307 27.82079 27.63086 .08007175 .1029592 -.10000000149011612 .3529412 4.129 .12825091 .04231236 .03833715 1021 1993 14.61129 14.471304 12.913254 -.20638284 -.15890595 .3529411852359772 .2631579 -6.025 .04434227 .14834009 .065071695 1021 1994 14.777784 13.503155 14.21237 -.035597675 .05053456 .2631579041481018 .15 -.677999 .07348735 .05007701 .12818481 1021 1995 19.46993 19.7254 18.38887 .1494159 .37306035 .15000000596046448 .39534885 3.31 .19323383 .11077943 -.07986733 1021 1996 1.0873173 8.872835 -1.218776 1.195947 .8385531 .39534884691238403 .04827586 3.09 -.10212044 .2470738 .464207 1021 1997 21.90713 21.554907 1.5244447 -.4581643 -.357462 .04827586188912392 0 -3.759 .27016488 -.05943331 -.032480996 1021 1998 41.71472 37.706245 5.759314 . . 0 . -.33099955 -.03207253 .26676738 . 1028 1990 -2.711 -2.711 -2.711 . . -.20000000298023224 . -2.711 0 . . 1034 1990 -8.283 -8.283 -8.283 . . .15522727370262146 .25846153 -8.283 0 . . 1034 1991 45.64215 46.66649 64.14858 -.20353216 -.12702438 .25846153497695923 .1781818 -3.735995 .04013455 .04078601 .072616026 1034 1992 75.14813 70.96396 62.24413 -.07880253 -.023035904 .17818181216716766 .021454545 2.903009 .066477165 .036741633 .02315024 1034 1993 21.19539 23.42487 63.57073 -.02505783 -.025797844 .021454544737935066 .17391305 -30.741995 .022347225 .06417127 .04616866 1034 1994 72.265816 80.78925 114.9713 .13319264 .1208013 .17391304671764374 .2011494 18.96701 .04055274 .019628925 .08702227 1034 1995 87.77238 88.47419 88.17165 -.0024137616 .006177725 .20114941895008087 .14705883 -7.169997 .06217606 .0289743 .04190486 1034 1996 47.27048 46.58684 45.10899 -.0897999 -.013326615 .14705882966518402 -.04918033 -14.73898 .03909724 .05801028 .04877192 1034 1997 76.30097 76.26172 74.55457 .009507607 .034408573 -.04918032884597778 -.01909722 3.8989916 .05047709 .04046416 .0923612 1034 1998 109.74043 113.52586 98.09737 .07229469 .0404691 -.01909722201526165 -.0390625 -1.0620065 .089663 .04900248 .11068486 1034 1999 69.689545 70.18668 69.95132 -.006914323 -.04888802 -.0390625 .2857143 23.67499 .0769449 .06233112 .03644261 1034 2000 135.21422 136.83913 138.9692 -.08503086 -.1910175 .2857142984867096 .10300256 56.27199 .028548626 .06027756 .10289365 1034 2001 8.952849 9.920845 228.6172 -.07732446 -.07255016 .10300255566835403 -.11449814 -94.18803 .07413152 .020568356 .10071813 1034 2002 -31.08823 -31.25359 62.88961 .003750612 .0022527098 -.11449813842773438 -.002481352 -80.081 .06786588 .0499513 .06569015 1034 2003 26.03505 26.249874 105.67494 -.03985698 -.02231471 -.002481351839378476 .020469606 -42.54 .06835228 .07061618 .0810484 1034 2004 -758.5277 -757.3066 -618.3099 -.2816874 -.1506219 .020469605922698975 .07910674 -836.859 .07992296 .067403145 .10616253 1034 2005 61.35334 59.59576 167.1692 .4048228 .4996383 .07910674065351486 .10045666 -21.77998 .12340344 .09290253 .02142534 1034 2006 518.38556 518.2887 508.7973 -.2199424 -.2000906 .10045665502548218 -.04047621 438.281 .026446624 .1523245 .02894634 1034 2007 83.87479 84.31306 200.0242 . . -.04047621041536331 . -50.83899 .05067841 .04630198 . 1036 1990 -18.628 -18.628 -18.628 . . .061721742153167725 -.10607082 -18.628 0 . . 1036 1991 -78.89796 -79.20221 -78.1724 -.03370579 -.05807186 -.10607081651687622 .04615385 -87.519 .019155037 .05161968 .09613688 1036 1992 -12.137446 -11.492722 -3.074312 .07850186 -.116273 .04615384712815285 .04827586 -16.355032 .11136398 .022189 .16018595 1036 1993 19.65856 19.69547 17.755167 .036547914 -.00051181106 .04827586188912392 -.012903226 13.656015 .13766903 .09570982 .150403 1036 1994 -78.86307 -78.66415 -78.97009 -.03249029 -.001718728 -.012903225608170033 -.05978261 -81.75803 .11655498 .10668678 .12204833 1036 1995 -40.02811 -41.11493 -42.16572 -.006137588 .05677794 -.05978260934352875 -.003174603 -52.40701 .11775944 .11245914 .12493417 1036 1996 3.437677 2.732731 -13.23481 .12375493 .1528028 -.0031746032182127237 -.019033816 -12.191974 .114335 .10776897 .03808339 end
The first graph I would like to generate is the mean value of CFO_w by firms over time
I use
egen mean = mean(CFO_w), by(fyear)
graph mean fyear
But it seems not in a correct way.
The second graph I want to generate is the DA_JONES estimates over time. So the regression variables of this model are FRET_w taac_w CFO_w -- and what I want to know is the change of R^2 over time
I use graph twoway line FRET taac CFO fyear
Still, I do not think it is in a correct way.
Can anyone provide some suggestions for me? Thanks a lot.
0 Response to query about graph
Post a Comment