Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Rolling Regressions with Panel Data using asreg

    Hello everyone,

    I am trying to run a panel regression with a rolling window in order to obtain the coefficients over a regression window of 60 months each.

    I already ran a similar regression with another dataset for each company ID, where I used the user-contributed command by @Attaullah Shah. This worked perfectly fine for a "static regression".
    I used the following code:

    Code:
    bys ID: asreg ExcReturn SMB_ HML_ MOM_ MktRfECB_
    For the regression with a rolling window I was trying to use the same code, but I added a rolling window. However, the output generated was not what I needed. That's the code I used.

    Code:
    bys ID: asreg ExcReturn SMB_ HML_ MOM_ MktRfECB_, window(date 60) rec

    The goal is to use the first 60 months of each company ID and obtain the coefficients and then move on to the next months 2-61, 3-62...etc. In total I would need 19 times a regression of 60 months of data for each company ID.

    Can anyone help me with this issue? Is the format of the date variable the problem?


    Here, is a sample of my dataset:

    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input int ID double(Month_ SMB_ HML_ MOM_ RFECB_ MktRfECB_ MktReturn_) float(date ExcReturn)
    1  -.00816331063916087  -.022000000000000002                 .0031                -.0354   .00007855771554621249    .017621442284453788                 .0177 19814  -.008241869
    1   .11937058956974622                 .0218                 .0033  -.021400000000000002  -.00021591622453487336     .04811591622453487                 .0479 20179     .1195865
    1  .026416105733352294                -.0064                 .0335                -.0391   -.0004327660911997988    .024332766091199796   .023899999999999998 20545    .02684887
    1   .04648614431204509                 .0191  -.013000000000000001                 .0023   -.0006415446871788077      .0474415446871788   .046799999999999994 20910    .04712769
    1    .0932324728445517                -.0074                 .0151   .006999999999999999   -.0005511845246031211    .023951184524603125   .023400000000000004 21275    .09378365
    1  .006035021334470299                  .001                -.0104  -.043899999999999995   -.0004975216476115207    .039597521647611524                 .0391 21640   .006532543
    1   .17276286720240136                 .0504                -.0381                 .0102   -.0005123043778888503     .06763044313488914    .06709999999999999 22006    .17327517
    1   .08400792777071235                -.0097                -.0101                 .0033  -.00004614420928317209 -.00015385579071682792                -.0002 19936    .08405408
    1  -.06136894637629213   .037000000000000005                  -.01                 .0212  -.00022122731331630785    -.05997877268668369                -.0602 20301   -.06114772
    1   .15202688358818803                 .0161   .019299999999999998                -.0176   -.0005377819706646747    .008537781970664675                  .008 20667    .15256466
    1  .010062541533153058                -.0006 -.0070999999999999995   .013300000000000001   -.0006406257274652605   .0026406257274652605                  .002 21032   .010703167
    1  -.13255300343537135                 .0088                -.0265                 .0242   -.0005609230927768882    -.02433907690722311                -.0249 21397   -.13199209
    1  -.08654045633105636                -.0059                -.0196   .032799999999999996   -.0007383804296020591   -.021661619570397937  -.022399999999999996 21762   -.08580208
    1  .018388373587279568                     .                -.0174                     .   -.0005220002253455425    .050180869664140725                 .0496 22128   .018910374
    1  .016360283105206853                 .0222                -.0235   .019799999999999998  -.00007543879269333864   -.036924561207306666  -.037000000000000005 20058   .016435722
    1 -.052814265545862445                 .0377                -.0125                 .0401  -.00033127876821847924   -.018168721231781523  -.018500000000000003 20423   -.05248298
    1   .14336906537841607                -.0083                 .0199                -.0196   -.0006879671832880074     .04818796718328801                 .0475 20789    .14405704
    1  .044260268220982765                 .0155                  .005  -.014199999999999999   -.0006169843835842626    .016216984383584265   .015600000000000001 21154    .04487725
    1 -.008057339919867698 -.0068000000000000005                 .0095   .032400000000000005   -.0006263079412752726   -.043373692058724725                 -.044 21519  -.007431032
    1 -.023327191657974266                 .0279  .0040999999999999995                 .0166   -.0005522660704037063    .042652266070403705                 .0421 21884  -.022774925
    1   .08361878069589906   .009899999999999999                 .0196                -.0397  -.00020577021794732087     .06230577021794732                 .0621 20120    .08382455
    1  .007490671729157438   .014499999999999999                 .0037  -.006999999999999999  -.00042645801152185747    -.01647354198847814                -.0169 20485   .007917129
    1 -.003856721896140414                -.0004  -.026000000000000002                 -.016   -.0007371765285624221    .007937176528562424   .007200000000000001 20851  -.003119545
    1  -.07312743854956623   .012199999999999999                -.0075                 .0062   -.0005693344001306277    -.05183066559986937  -.052399999999999995 21216  -.072558105
    1 -.010465532039661263                -.0147                -.0123                -.0115   -.0004739644158900935    .031573964415890096   .031100000000000003 21581  -.009991568
    1   -.1420618825082541                 .0029                -.0073                 .0077    -.000615196470831636    -.08796507329364876                -.0886 21946   -.14144668
    1   .15588779665087954  -.015600000000000001                -.0352                 .0351  -.00015317648082147084   -.002946823519178529                -.0031 20089    .15604097
    1 -.030783650296596226                -.0076                -.0149                 .0115   -.0003764425891231715    -.06382355741087682                -.0642 20454  -.030407207
    1   .03019588837589893                 .0203   .004699999999999999   .028300000000000002   -.0005873520266435062    .029387352026643505                 .0288 20820    .03078324
    1 -.032184649785555026                  .008   .011000000000000001                 .0296   -.0005344406522276302    .056834440652227626   .056299999999999996 21185  -.031650208
    1   -.1981769285837487                 .0059                -.0095                -.0223   -.0005030402745956897     .06450304027459569                  .064 21550    -.1976739
    1 -.030170877633363354                 .0036                -.0288                 .0355   -.0005461374810858954   -.023653862518914104                -.0242 21915   -.02962474
    1  -.09339286142578701                -.0043                  .004                -.0058 -.000014963731461481444    -.04098503626853851  -.040999999999999995 19905    -.0933779
    1   .06288908854893364  -.008100000000000001                -.0265                 .0353   -.0002425140438256923    .024142514043825693                 .0239 20270     .0631316
    1  .030580837179675368                 .0154                 .0021                 -.001    -.000533995543566923    .045133995543566924                 .0446 20636   .031114833
    1    .0856965565583179                  .008                 .0259                 .0196   -.0005935362407027966    .036193536240702796                 .0356 21001     .0862901
    1  .028620105510629996                -.0191                  .004  -.005600000000000001   -.0005458893280377852    .029045889328037786                 .0285 21366   .029165994
    1  -.07071849745442123                -.0128                 .0009                 .0139    -.000621993411462296   -.023078006588537706  -.023700000000000002 21731   -.07009651
    1 -.004736284418952219                 .0269                -.0475    .06709999999999999   -.0005421838800333534     .04061519647083164                   .04 22097 -.0041941004
    1   .08171416718983518                 .0011                -.0176                 .0033  -7.576149014587585e-06  -.0011924238509854123                -.0012 19875    .08172175
    1   -.0535599932604153                 .0203                 .0016                 .0091  -.00021596383750988046   -.028184036162490118  -.028399999999999998 20240   -.05334403
    1  -.05728560793831404                -.0239  -.016399999999999998                  .071   -.0005425108252492539   -.049357489174750746                -.0499 20606    -.0567431
    1   -.0597302473716993                 .0155                 .0203                 .0159   -.0005454885958302569   -.005554511404169744  -.006100000000000001 20971   -.05918476
    1  -.22023596878813692                -.0085  -.015600000000000001                -.0066   -.0005918813161841507    -.00720811868381585 -.0078000000000000005 21336    -.2196441
    1   .09696672352935749                -.0269  -.013999999999999999 -.0039000000000000003   -.0005774026413249977    .061477402641324994   .060899999999999996 21701    .09754413
    1   .01123121956950048                 -.012                 .0174                 .0075   -.0005323911586925245      .0410461374810859                 .0405 22067    .01176361
    1  -.02341964372585837                -.0051 -.0034999999999999996   .015700000000000002   -.0002075225303665995   -.022592477469633398  -.022799999999999997 20148   -.02321212
    1   -.0733227345790196                 .0171   .011899999999999999                -.0149   -.0004056161622540966     .06760561616225409                 .0672 20514   -.07291712
    1   .09531017980432474  -.013000000000000001                  .005                 .0002   -.0006217391777666448     .04362173917776664                  .043 20879    .09593192
    1  -.12355023937854125  -.005600000000000001  -.009399999999999999                -.0043    -.000583153409159487   -.005316846590840513                -.0059 21244   -.12296709
    1  -.08912777989600727                -.0176                -.0233                 .0452   -.0005100090045742078    .008210009004574208                 .0077 21609   -.08861777
    1  -.07490707719864281  -.042199999999999994                 -.113                 .0755   -.0005808696641407263    -.15382553759897422   -.15439999999999998 21975   -.07432621
    1   .01074681456735932  -.006999999999999999 -.0034000000000000002                -.0023  .000025779677764292686   .0076742203222357076                 .0077 19844   .010721035
    1  .005784542521529858                 .0166  -.024700000000000003                 .0356  -.00020487904055832562  -.0012951209594416744                -.0015 20209   .005989422
    1  .015250840252466894   .015300000000000001                -.0287                 .0381   -.0004500314028320629  -.0032499685971679373                -.0037 20575   .015700871
    1   .12721129003781229                 .0002                -.0079                -.0043   -.0006191280794665133    .051519128079466514                 .0509 20940    .12783042
    1                    0                 .0123                -.0499                   .02   -.0006015000952903637   -.025298499904709636                -.0259 21305  .0006015001
    1  -.23342486353013098                 .0132                -.0154                  .085   -.0005363292448664625   -.050763670755133536                -.0513 21670   -.23288853
    1   .08047720691999859                 .0121                -.0414   .028999999999999998   -.0004993432769760942     .05495226607040371   .054400000000000004 22036    .08097655
    1   .03639309950313204  -.013500000000000002                -.0182                -.0062  -.00005277948517878883     .02125277948517879                 .0212 20028    .03644588
    1   -.1455164305948154                 .0033  -.027999999999999997   .026099999999999998   -.0003366492978409408    -.01456335070215906                -.0149 20393   -.14517978
    1   -.1513916193328682                 .0089                 .0192  -.020499999999999997   -.0006653913750100937    -.02423460862498991  -.024900000000000002 20759   -.15072623
    1    .0720891014517267                -.0038                 .0129                  .003   -.0006395834118079202   .0013395834118079203  .0007000000000000001 21124   .072728686
    1   .08268402912507528                -.0118  -.005699999999999999                -.0209   -.0005811061712430732   -.010718893828756928  -.011300000000000001 21489    .08326513
    1 -.011884689971514095                 .0207  -.022400000000000003   .006999999999999999    -.000530443134889147    .019430443134889147                 .0189 21854  -.011354247
    1   .03850820866998566                -.0123  -.030899999999999997                 .0108  -.00006792286859436114   -.026932077131405642  -.027000000000000003 19997    .03857613
    1  .024530032709535948                -.0297                -.0077  -.015600000000000001   -.0002752571670172621    .062175257167017266   .061900000000000004 20362    .02480529
    1  -.03030534949532915                -.0077                 .0636                -.0083   -.0006195845128315058   -.029980415487168496  -.030600000000000002 20728  -.029685766
    1  .033187050937816424                -.0096                -.0013   .012199999999999999   -.0006588161449018193    .007458816144901819                 .0068 21093   .033845868
    1  -.01680711831638129                 -.017                 .0147                -.0147   -.0006111643575186232    -.08288883564248137   -.08349999999999999 21458  -.016195955
    1  -.17738675650810648   .009300000000000001                 -.005  -.011899999999999999    -.000574462401025766     .03477446240102577                 .0342 21823    -.1768123
    1  -.07713249420127181  -.022799999999999997                -.0044   .024900000000000002  -.00007915361669907917   -.037820846383300924                -.0379 19967   -.07705334
    1    .1633666713289294                 .0111                -.0363   .042800000000000005   -.0002257016327344985   -.042474298367265496  -.042699999999999995 20332    .16359237
    1  .029947631730827647                 .0092                -.0015   .031400000000000004   -.0006034823597192984    .010303482359719299                 .0097 20698   .030551113
    1   .02286789069121414                -.0012   .004699999999999999                 .0063   -.0006278602823639456    .028727860282363946                 .0281 21063    .02349575
    1   -.0341713565449153                -.0146   .023399999999999997                 .0159   -.0005266067230381699     .00322660672303817                 .0027 21428   -.03364475
    1    .1328249284481955                -.0089                 .0308  -.022799999999999997   -.0006349267063512354    .023934926706351237                 .0233 21793    .13345985
    1  -.21997062427363212                 .0291                -.0374                 .0004   -.0005383058965158227    -.02908769562211115                -.0296 22159   -.21943232
    2   .03049697112210658  -.022000000000000002                 .0031                -.0354   .00007855771554621249    .017621442284453788                 .0177 19814    .03041841
    2  .011204599012863062                 .0218                 .0033  -.021400000000000002  -.00021591622453487336     .04811591622453487                 .0479 20179   .011420515
    2   .04345136577836155                -.0064                 .0335                -.0391   -.0004327660911997988    .024332766091199796   .023899999999999998 20545    .04388413
    2  .014706147389695487                 .0191  -.013000000000000001                 .0023   -.0006415446871788077      .0474415446871788   .046799999999999994 20910   .015347692
    2   .10249928337679416                -.0074                 .0151   .006999999999999999   -.0005511845246031211    .023951184524603125   .023400000000000004 21275    .10305047
    2   .03089048701933851                  .001                -.0104  -.043899999999999995   -.0004975216476115207    .039597521647611524                 .0391 21640   .031388007
    2  .022353245780747908                 .0504                -.0381                 .0102   -.0005123043778888503     .06763044313488914    .06709999999999999 22006    .02286555
    2     .067565319495766                -.0097                -.0101                 .0033  -.00004614420928317209 -.00015385579071682792                -.0002 19936    .06761146
    2  -.17273092629225284   .037000000000000005                  -.01                 .0212  -.00022122731331630785    -.05997877268668369                -.0602 20301    -.1725097
    2   .07796154146971192                 .0161   .019299999999999998                -.0176   -.0005377819706646747    .008537781970664675                  .008 20667    .07849932
    2   .18481345940413357                -.0006 -.0070999999999999995   .013300000000000001   -.0006406257274652605   .0026406257274652605                  .002 21032     .1854541
    2   .04573600932268429                 .0088                -.0265                 .0242   -.0005609230927768882    -.02433907690722311                -.0249 21397    .04629693
    2  .010582109330537008                -.0059                -.0196   .032799999999999996   -.0007383804296020591   -.021661619570397937  -.022399999999999996 21762    .01132049
    2  -.11672427430814143                     .                -.0174                     .   -.0005220002253455425    .050180869664140725                 .0496 22128   -.11620227
    2 -.029980832211935784                 .0222                -.0235   .019799999999999998  -.00007543879269333864   -.036924561207306666  -.037000000000000005 20058  -.029905394
    2   .00473560474583425                 .0377                -.0125                 .0401  -.00033127876821847924   -.018168721231781523  -.018500000000000003 20423   .005066883
    2   .07302513501488982                -.0083                 .0199                -.0196   -.0006879671832880074     .04818796718328801                 .0475 20789     .0737131
    2   .02504793886917213                 .0155                  .005  -.014199999999999999   -.0006169843835842626    .016216984383584265   .015600000000000001 21154   .025664924
    2   -.1004705303636345 -.0068000000000000005                 .0095   .032400000000000005   -.0006263079412752726   -.043373692058724725                 -.044 21519   -.09984422
    2   .11240956759524014                 .0279  .0040999999999999995                 .0166   -.0005522660704037063    .042652266070403705                 .0421 21884    .11296184
    2   .06326544649077304   .009899999999999999                 .0196                -.0397  -.00020577021794732087     .06230577021794732                 .0621 20120    .06347122
    2  -.00340136382349029   .014499999999999999                 .0037  -.006999999999999999  -.00042645801152185747    -.01647354198847814                -.0169 20485  -.002974906
    end
    format %td date

    Thank you in advance, I really appreciate your help.
    Nicole

  • #2
    You need a monthly date for this
    Code:
    gen mdate = mofd(date)
    bys ID: asreg ExcReturn SMB_ HML_ MOM_ MktRfECB_, window( mdate 60) rec
    Regards
    --------------------------------------------------
    Attaullah Shah, PhD.
    Professor of Finance, Institute of Management Sciences Peshawar, Pakistan
    FinTechProfessor.com
    https://asdocx.com
    Check out my asdoc program, which sends outputs to MS Word.
    For more flexibility, consider using asdocx which can send Stata outputs to MS Word, Excel, LaTeX, or HTML.

    Comment


    • #3
      Thank you very much for your help! I guess my last reply was deleted when Statalist was down.

      I ran the regression and some additional ones and now want to calulcate the standard devitaion of the residuals of each regression output.

      To do so, I used the following code and generated an extra id variable for every single regression output:
      Code:
      bys id: asrol _residuals, stat(sd) gen (idioVola)
      Unfortunately, this code only produces missing values. Am I missing something?

      Here's an example of my data after dropping all the unneccessary variables and only leaving the output of the asreg code:

      Code:
      * Example generated by -dataex-. To install: ssc install dataex
      clear
      input int ID float(mdate _Nobs) double(_R2 _adjR2 _b_MktRfECB_ _b_cons) float(_se_MktRfECB_ _se_cons) double(_fitted _residuals) float id double IdioVola
      2 531 11   .02500396203896826    -.08332893106781314   .6053831954732745  -.0010029126636941603 1.2601032   .04610354  -.009000317033113733   -.10750219148796629   1 .
      2 543 23  .046588358887634344   .0011878045489501776   .6019174394570075    .006847875209294297  .5941947   .02124319  -.008515398810375894   -.04095423980547074   2 .
      2 555 35  .026039055810709828  -.0034749121950261586  .44292540385239276    .002383666998673987  .4715544  .016631974   .026102206588537985   -.05705065924003869   3 .
      2 567 47   .04840695394625571    .027260441811728153    .581397995893633 -.00011355976439958448 .38427225    .0131087    .03274452967305324    .02510979863147595   4 .
      2 579 59   .07766371162090721     .06148237322829153   .6445530653301139   -.004554681547154839  .2942096  .010449328   .022976619881481638    -.0907894426406331   5 .
      2 591 60    .3686735049956014        .35778856542656   .9017685727655658    -.00629010949823321  .1549484  .008926524    .11635272655374179    .11613767888658871   6 .
      2 603 60    .2562195915720031     .24339579142669288   .7205250242279451   -.006617759564830518  .1611949   .00990237   -.01886657405507906    .14150506038081986   7 .
      2 615 60    .2668368611027834      .2541961173286935   .6405523666099575  -.0047773685457937615 .13941774   .00955348   .046614137850915685   -.03377442006043126   8 .
      2 523  3    .9857822324525564      .9715644649051127 -14.291871185461709     .22548831705218605 1.7163833   .01908612    .21392038246298392   .005213188327306911   9 .
      2 535 15   .02133936731196468    -.05394221981788405   .4998025283946579    .006657583691584784  .9387546  .030931424   .008180073786832345  -.022191819127954496  10 .
      2 547 27   .03843468759420421 -.00002792490202763176   .5503774942221242    .013981380255164901  .5505774  .018843306   .025801066140144584    .05482893081525016  11 .
      2 559 39  .054010394597211214    .028443107964703507   .6318956924907818   -.003762914331514598  .4347595   .01487908   .014174159543752224   .058703642410994024  12 .
      2 571 51  .036686554055578864    .017027095975080453     .49404888133056    .004568249301010657  .3616615  .011965326  -.005241580861628431   .012386197778404134  13 .
      2 583 60   .09090396852625411     .07522989901808619   .6022479844322634   -.004705097875932415  .2500776  .009461985  -.033512478757285455    .08982575504817901  14 .
      2 595 60    .3586722271804646     .34761485178702434   .8363588197917728   -.009690665493294958 .14684859  .009045969    .03713251572275779    .03204725760793069  15 .
      2 607 60     .257934774471522     .24514054644516903   .6735615982202949    -.00901093406267648  .1500132  .009774108   -.03788809974658863  -.026691342396851614  16 .
      2 619 60   .28006343369590153      .2676507342768655   .6531450674504811   -.006900889089251559 .13750376    .0096012   -.07316536609004366  -.018912038170591713  17 .
      2 527  7   .24069284780466596     .08883141736559919  -2.180521915531757     .10294660034667898  1.732019   .07154123   -.05444524375958627   -.01476139636473471  18 .
      2 539 19   .02377424167937689    -.03365080292771849   .4835748085613874   .0055953889324596336  .7515554   .02772789   .025977819285463895   -.03280018229327759  19 .
      2 551 31   .07085150384218669    .038811900526399934   .7397694194708767    .008025911814507972  .4974683  .016645467   .036890756303305475    .05407467115498081  20 .
      2 563 43   .04727978591658584    .024042707524307483   .5862626599573784  -.0025335758932715988  .4110032  .014010602   .017470236233126036   -.01666163985493373  21 .
      2 575 55   .06980722651528624     .05225641946840487   .6801363370336431   -.004304788637500879  .3410314   .01145823  -.018978342658581705   -.09443546807139877  22 .
      2 587 60   .37843358989594944      .3677169276527762  1.0178873920242197   -.010084181853892489 .17129105  .008742495     .0565586898512816   -.10284612961482759  23 .
      2 599 60    .3435667752865537     .33224896106735635    .816270219838687   -.009740881884835479 .14815272  .009017944 -.0025363134958936552 -.0037866245216534753  24 .
      2 611 60   .23302357399027654      .2197998425073503   .6048958897940349   -.008369048501896695 .14409792  .009877705   .046071113730167305   .027445128475929344  25 .
      2 529  9   .25486548608724985      .1484176983854285  -2.307984746075573     .11655755897640022 1.4915773   .05753676    .04766925004322413   .011871923236061302  26 .
      2 541 21  .030538931700737876    -.02048533505185479   .5328470842420288    .009606188206722138  .6887539  .025193967   .033878224126141866     .0727519745313708  27 .
      2 553 33   .04616978638334307     .01540106981506384   .5937219428067292    .004321934921839115  .4846842    .0166587   .008239186157098542   -.09308098142277313  28 .
      2 565 45   .04268562608362664     .02042250110882715    .557275225323939  -.0001058198928133372  .4024593   .01342087  -.002560946712337942    .00532790747850439  29 .
      2 577 57   .09367504355445819      .0771964079827212   .7030761309022316   -.005111518998060536 .29488388    .0105239  .0076111927253404085  -.014040249827990813  30 .
      2 589 60    .3392570128022583      .3278648923333317   .8839812766232585   -.009648038642894227  .1619873  .008803766   -.09834343394110101     .0685184636510362  31 .
      2 601 60   .28308227340996556      .2707216229515168   .7493177507191131   -.007855297120791733 .15657786  .009553784   -.02392898770511337    .01717368737325259  32 .
      2 613 60   .25080849138859057     .23789139641253187   .6245039812816542   -.005779925567029361 .14172502  .009679008   .012835231918583127  -.029142500210294936  33 .
      2 528  8    .2542372773544391     .12994349024684548 -2.3024512420908962      .1148971388906448 1.6098875   .06363893    .06049811993409958    .05543388272951279  34 .
      2 540 20  .020086667144184975    -.03435296245891584   .4291153234557611    .008135116300315971  .7064438  .025482766   .002682859355083534   .024814206829794815  35 .
      2 552 32   .04209214059032407    .010161878610001396   .5545273649342994     .00795274991406194   .482974  .016847882    .04402810849318684   -.09941659636864841  36 .
      2 564 44   .04259894739072154    .019803684233357877   .5608295332608502  -.0002933747081299426  .4102549  .013832737    .00383133733122869    .07558918452412562  37 .
      2 576 56   .09391525781396429     .07713591073644499   .7038971147122982   -.004872757427768967 .29752854  .010688484    -.0759023027491961  -.009461100213488532  38 .
      2 588 60   .35472555157283003     .34360013004822365   .9323994516136043   -.010044281464628884 .16512544  .008738894   -.11349248746562945    .09826095542092073  39 .
      2 600 60    .2896051501008501     .27735696303362345   .7663922313110084   -.006855524838551642 .15761003   .00965146   -.04777585392126712     .2058552694810358  40 .
      2 612 60    .2479787061159567     .23501282173864568    .626283662853754  -.0066863687846033274 .14320724  .009765458    .01589041015067029    .01630423033676219  41 .
      2 522  .                    .                      .                   .                      .         .           .                     .                     .  42 .
      2 534 14   .01907124202793459    -.06267282113640404   .4745346076942512    .008671794333612006  .9824411  .033497486 -.0064910096594981165    .02136944192591228  43 .
      2 546 26    .0379550206202925   -.002130186853861904   .5419639343054303    .012023882081179365 .55696493  .019282874    .03309267041834621  -.011822728715861125  44 .
      2 558 38   .05152402492093067    .025177470057623275   .6127099898746129   -.004971186836094394  .4381391  .015056184   .001990248284874492  -.041088030509291225  45 .
      2 570 50  .037157663784037835     .01709844844620534   .5061151997821477     .00410175833282737  .3718623  .012381277 -.0068612710409885185    .07435790606076773  46 .
      2 582 60    .0862109897844357     .07045600684968456   .6404473552636133  -.0029436439467790555 .27378592  .010220157  -.028768460299654186  -.011685081724242985  47 .
      2 594 60    .3528697749995846     .34171235732716365   .8290719820990476   -.010303855103717303 .14742355  .009018848    .07366754527055122   -.02489098573886253  48 .
      2 606 60   .25447845598947105     .24162463626515163   .6744125740504544   -.007315277549836742 .15157105  .009848883    .07254326042885681  .0042597979569921895  49 .
      2 618 60   .27044532312340946      .2578667942117441    .651856904913149   -.005562093761069144 .14058127    .0096556   -.02787015648204185   -.09772031693142555  50 .
      2 521  .                    .                      .                   .                      .         .           .                     .                     .  51 .
      2 533 13  .023357940673933264    -.06542770108298179   .5911135301087509     .00460951291229645 1.1524577     .039478   .015814173541538086    .06137637463999573  52 .
      2 545 25   .03879587552590063   -.002995608146886264   .5534817980245657     .01229928241327339 .57445294   .01978432   .021149592309837623    .05009522119199725  53 .
      2 557 37   .05058231079348654    .023456091101871968   .6048401848946221  -.0037213309390881424  .4429309  .015402962  -.004214973283158837   -.02065536090995163  54 .
      2 569 49  .048434987262722974     .02818892316192989    .586890538987344   .0010541665778691645  .3794441   .01270785  .0003582522317903405  -.022506440435363567  55 .
      2 581 60   .08123198693294653     .06539115912144566    .631760240376651   -.002641520792086679 .27898297  .010328446   -.05872294142356228  -.002441731994244342  56 .
      2 593 60   .34445663541898264      .3331541636158617    .832179821457377   -.009035979806162255  .1507428  .009030238  -.025133552495790128   .005580503959608678  57 .
      2 605 60   .24427343030857526     .23124366186561973   .6727088768838304  -.0073448117092395175  .1553665  .009843083  -.014107172430884869   .007524069917780192  58 .
      2 617 60   .26583128033138786      .2531731989577911   .6377057884314872   -.004572582360103064 .13915579  .009540082  -.018378684915666327   -.07596397896849658  59 .
      2 530 10 .0007679641903629767    -.12413604028584158  .10668934082572445    .022258737127014018  1.360626   .05190083   .018627563914740023   -.16070284923025363  60 .
      2 542 22  .031191343901255487    -.01724908890368182   .5090524329390922    .010557548100569854    .63438    .0229312 -.0023949741657466952   .008955239252337939  61 .
      2 554 34   .03370300538107918    .003506224299237859   .5120443340548292   .0027662599711962676  .4846783  .016763555    .02381316759207177   -.10002489574768472  62 .
      2 566 46   .04274576166098431    .020989983516915833   .5546316472995769  -.0001609950240765816  .3956812  .013239442   .021020190828125517  -.004646385126392882  63 .
      2 578 58   .08855038318699608     .07227449717247814   .6869922800919384   -.003600305110384775 .29452962  .010420364 -.0027289627975753093     .0727300061768821  64 .
      2 590 60   .30944496478613204     .29753884348934123   .8202285189734704   -.009955578307312618 .16088973  .008832102    .04653276491845776   -.11180211592401196  65 .
      2 602 60   .27696238436085063     .26449621857396877   .7364872066585253   -.009439503559120084 .15625045  .009606308    .03747544366442484   -.06185273196124357  66 .
      2 614 60    .2619499256753793      .2492249243939203   .6389281025779834  -.0052176168935644815 .14082241  .009588413 -.0069278127023826245  -.060371687405382575  67 .
      2 532 12   .02501589452123481     -.0724825160266418   .6034406063161314  -.0007627543291297174 1.1913114    .0419721   .007119215283037919   .002180039693175059  68 .
      2 544 24   .03974919871848602  -.0038985649761282826   .5561910046372127    .010165393243854407 .58282846  .020398175   .010393613475131213    .05744988332433778  69 .
      2 556 36   .04828895516674892     .02029745384812398   .5928455005447383   -.002928981271694598  .4513679  .015912756    -.0234941866929587   -.08238560438799299  70 .
      2 568 48   .04608714724508219     .02534991131562736   .5743796968926017   .0017652831254422914  .3852872  .013037093   .011105223951903751    .08189716988983972  71 .
      2 580 60   .06807592794789163      .0520082715332002    .624167921283993   -.001603665262595368  .3032361  .010683177  .0026831646796817614    .15621818403037835  72 .
      2 592 60   .34346630585656535      .3321467594058165   .8379135431882784    -.00797357242951529 .15211487  .009112115    .09913343960368134   -.09990758822248377  73 .
      2 604 60   .24431420983554505     .23128514448788218   .6771236680515423   -.006346774802938421 .15636885  .009909766   -.08802890226169173    .08072468133567516  74 .
      2 616 60    .2648188178791331     .25214328025635957   .6312270155726389   -.003614107697334504  .1381002  .009459856  -.023618703247462926  -.012448000250900568  75 .
      2 526  6   .12528239012338172     -.0933970123457728  -1.911617980637276     .09826905550877615 2.5255735   .08460177   .014481590142284895   -.15477262531760838  76 .
      2 538 18  .027584997363942272    -.03319094030081127   .5265394919200226    .006490840887523729  .7815564   .02858926     .0424542095413214   .009773909682988524  77 .
      2 550 30  .062210359409311584    .028717872245358378   .6910157542902249    .007012293742326075  .5070261  .016863223   .016583239427575773   .011847103246679598  78 .
      2 562 42  .048185796454041314     .02439044136539248   .5938075401399019   -.002277228308960875  .4172845  .014224404   .020794869805821778   -.04124587907935083  79 .
      2 574 54   .05504325743560523     .03687101238628998   .5989925535632196  -.0011463470314600228  .3441705  .011626453  -.025134433104691878   -.11297320942670308  80 .
      2 586 60    .3655392297489588     .35460025095152714   1.000141078711669   -.010550046876334528 .17301457  .008856512   -.08379575505592944   -.04131849214694379  81 .
      2 598 60   .34133562350396107     .32997934115058114   .8110059432279458   -.010179652185568704 .14792831  .009038621   .013613931231283169    .02303090006849863  82 .
      2 610 60   .22721464841382688     .21389076304165155   .6061538298218678   -.007567889359992619 .14678448  .009943803   -.05654347498883016    .07441707325149782  83 .
      2 622 60   .29040214761703326      .2781677018862926   .6453305104180432   -.006424466097067391 .13245685   .00963219  -.037864303761268515    .08716146143629636  84 .
      2 525  5  .012081781039656646     -.3172242919471244  -.4159645050567029     .09469398001514577 2.1716542   .06736741    .06935205041322447    .05414693326797747  85 .
      2 537 17  .020573315800742516    -.04472179647920793  .49044410186675724    .006595288441338474  .8737309  .029531386   .026149445845810342   -.07618889368983882  86 .
      2 549 29  .062434539143180465    .027709892444779727   .6921434248168968    .006585435773070712 .51618165  .017410673  -.016520707925014096  -.059643850604839725  87 .
      2 561 41   .05191475338843493    .027604875270189844   .6190867033631904   -.001729015636173446  .4236405  .014388275   .022634307257754276    .00819521550096803  88 .
      2 573 53   .02992945340387826    .010908462294150545  .44150525205584573   .0038917252001018973  .3519679  .011844297   .023015210326894762   -.07684338643787766  89 .
      2 585 60     .307700162572794     .29576395847922154   .9337761725389004   -.012512921617908544 .18391284  .009310755     -.219583084883631   -.05923063486581967  90 .
      2 597 60    .3448889893189982      .3335939718934636   .8104912169755516   -.010444011244115448 .14667365 .0090377405  -.025984452321838155   .045990091964315194  91 .
      2 609 60   .23945220166166398     .22633930858686524   .6308107397830449   -.008458093166282436 .14761786   .00988453   .022577763180095595    .02855173813287552  92 .
      2 621 60     .299466346695289      .2873881802590008   .6536379495012081   -.008522330696948093 .13126947   .00953284    .06288973106068861  -.002262900155012723  93 .
      2 524  4    .7113686313773844      .5670529470660766  -7.587251605499863     .17888370881328658  3.417385   .05666935   -.02596906461222534   .044631982971266554  94 .
      2 536 16   .03292244054966565    -.03615452798250107    .622248929399672    .009049671194827164   .901332   .03008925   .033515388171018755    .06536439617460807  95 .
      2 548 28   .03822021329982487   .0012286830421257555   .5574734328387947    .011144228649592636 .54843956   .01850547   .020010244691536436   -.07313281356708766  96 .
      2 560 40   .05041906648958424     .02543009455509959   .6137414466201292  -.0018399368530161997  .4320781  .014611864  .0031501622057006403   .062379079952235454  97 .
      2 572 52    .0366994454379278    .017433434346686316   .4886051343653844    .004522748439206999 .35401705  .011837787   .028055111602186315   -.00714731468284046  98 .
      2 584 60    .1969106094432619      .1830642406405596   .8428391837782371   -.009447746639091046  .2235003  .009496135    -.1376850531952784   -.11557403937407279  99 .
      2 596 60    .3400781320170314     .32870016877594577   .8048504044504577   -.012375260131717865 .14721704  .009095521   .030940352820791335   -.09232099994365128 100 .
      end
      Thank you!

      Comment

      Working...
      X