Announcement

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

  • summarize descriptive statistic with T-Value, star (all)

    Dear I am using this comand with support stata research, so how to export using asdoc, Collect preview star (all).
    See the comanad below:

    label define CATH 0 "Non-Chatolic" 1 "Chatolic"
    label values CATH CATH
    label define PROT 0 "Non-Prot" 1 "Prot"
    label values PROT PROT
    drawnorm x1-x26
    label var x1 IPOV
    label var x2 IPOC
    label var x3 lnIPOV
    label var x4 lnIPOC
    label var x5 PD
    label var x6 IND
    label var x7 MAS
    label var x8 UAI
    label var x9 LTO
    label var x10 MO
    label var x11 GDPg
    label var x12 VALUE
    label var x13 SAVING
    label var x14 PRIVAT
    label var x15 INVEST
    label var x16 BANK
    label var x17 LDGP_1
    label var x18 MCP_1
    label var x19 TURN_1
    label var x20 PCW
    label var x21 ESG
    label var x22 BUR
    label var x23 COR
    label var x24 DEM
    label var x25 LORD
    label var x26 GST


    collect results
    foreach x of varlist x* {
    ttest `x', by(CATH)
    collect get mean=(r(mu_1)), tags(var[`x'] CATH[0])
    collect get mean=(r(mu_2)), tags(var[`x'] CATH[1])
    collect get t=(r(t)) p=(r(p)), tags(var[`x'] CATH[_hide])
    ttest `x', by(PROT)
    collect get mean=(r(mu_1)), tags(var[`x'] PROT[0])
    collect get mean=(r(mu_2)), tags(var[`x'] PROT[1])
    collect get t=(r(t)) p=(r(p)), tags(var[`x'] PROT[_hide])
    }
    * define the rules for significance labels
    collect stars p .1 "*" .01 "**" .001 "***" , attach(t) dimension

    collect layout (var) (CATH#result#stars PROT#result#stars)

    * select results to show in table
    collect style autolevels result mean t, clear
    * change display order of grouping variables
    collect style autolevels CATH 1 0 _hide
    collect style autolevels PROT 1 0 _hide
    * label the test statistic
    collect label levels result t "Test t", modify
    * hide column labels for the mean
    collect style header result[mean], level(hide)
    * left align the stars labels
    collect style cell stars[label], halign(left)
    * other misc style choices
    collect style cell result[mean t], nformat(%9.3f)
    collect style cell border_block[corner row-header], ///
    border(right, pattern(none))
    collect style column, dups(center)
    collect preview

    I get this table: I Think the table does not report all significance level ( 0.01; 0.05; 0.1)
    Click image for larger version

Name:	stata table28.png
Views:	1
Size:	64.6 KB
ID:	1731854



    The table must to be like belows , where we can see all the significance level. Someone can Help:
    Click image for larger version

Name:	tablecomsignificance.png
Views:	1
Size:	128.6 KB
ID:	1731855



    Wait for some Help
    Best regards



    Last edited by Jose Tavares; 28 Oct 2023, 05:48.
Working...
X