Announcement

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

  • Descriptive statistics in correlation table

    Hi all,
    I have this correlation table, and I want to add also the value of SD and mean (descriptive statistics)
    Code:
            |   FSTS_5   FATA_5     HHI2     HHI2      emp      xad    ppent
    -------------+---------------------------------------------------------------
          FSTS_5 |   1.0000
          FATA_5 |   0.0087   1.0000
            HHI2 |   0.0516   0.0377   1.0000
            HHI2 |   0.0516   0.0377   1.0000   1.0000
             emp |  -0.0082  -0.0067   0.0502   0.0502   1.0000
             xad |  -0.0139  -0.0203  -0.0013  -0.0013   0.4755   1.0000
           ppent |  -0.0093  -0.0813   0.0396   0.0396   0.8818   0.5234   1.0000
             xrd |  -0.0131  -0.0012  -0.0900  -0.0900   0.0705   0.6663   0.1580
            FSTS |   0.1597   0.0169  -0.0476  -0.0476  -0.0080  -0.0286  -0.0206
            FATA |  -0.0009   0.3055  -0.0187  -0.0187  -0.0509  -0.0150  -0.0650
           fyear |  -0.0501  -0.0440   0.0536   0.0536   0.0826   0.0858   0.0557
         naicsh2 |  -0.0285  -0.0519  -0.1514  -0.1514   0.0683   0.0152   0.0127
    
                 |      xrd     FSTS     FATA    fyear  naicsh2
    -------------+---------------------------------------------
             xrd |   1.0000
            FSTS |  -0.0567   1.0000
            FATA |   0.0574  -0.1169   1.0000
           fyear |   0.0215  -0.0689   0.0712   1.0000
         naicsh2 |   0.0739   0.0023  -0.2521   0.0275   1.0000
    How can I do that?
    Thanks

  • #2
    Is this the same question as https://www.statalist.org/forums/for...elation-matrix ?

    No one answered that yet, but presumably an unsatisfying answer is

    1. Get a correlation matrix

    2. Get a matrix of means & SDs

    3. Join the matrices

    4. Details only you can know about depending on whether you are using MS Office, TeX./LaTeX, HTML, XML, Hogwarts spells, etc.

    Comment


    • #3
      You may find this topic from a year ago helpful.

      https://www.statalist.org/forums/for...relation-table

      Comment

      Working...
      X