Announcement

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

  • Help about the construction of a graph based on a variable with many categories

    Hi everyone,

    I would like to do about the variable called power_p1 from my dataset. This variable contains 1,278,934 observations, about various forms of electricity power available for household's electricity provision.

    Here is an example:

    Code:
    tab power_p1
    
       power_p1 |      Freq.     Percent        Cum.
    ------------+-----------------------------------
              0 |          9        0.00        0.00
              1 |         37        0.00        0.00
              2 |          1        0.00        0.00
              3 |          7        0.00        0.00
              4 |          7        0.00        0.00
              5 |          2        0.00        0.00
             10 |         21        0.00        0.01
             14 |          1        0.00        0.01
             15 |          2        0.00        0.01
             50 |          1        0.00        0.01
            100 |        579        0.05        0.05
            200 |        284        0.02        0.07
            300 |        109        0.01        0.08
            330 |        112        0.01        0.09
            345 |        573        0.04        0.14
            350 |          6        0.00        0.14
            381 |         47        0.00        0.14
            400 |        164        0.01        0.15
            500 |        569        0.04        0.20
            600 |        266        0.02        0.22
            625 |          4        0.00        0.22
            635 |        152        0.01        0.23
            640 |          8        0.00        0.23
            659 |          1        0.00        0.23
            660 |         98        0.01        0.24
            690 |        139        0.01        0.25
            700 |        543        0.04        0.29
            750 |         14        0.00        0.29
            770 |        234        0.02        0.31
            790 |          1        0.00        0.31
            800 |        237        0.02        0.33
            805 |        201        0.02        0.35
            880 |          1        0.00        0.35
            900 |         63        0.00        0.35
            950 |          4        0.00        0.35
            970 |          5        0.00        0.35
            998 |          8        0.00        0.35
           1000 |      2,837        0.22        0.58
           1039 |        417        0.03        0.61
           1040 |         17        0.00        0.61
           1090 |          5        0.00        0.61
    ...
    Here is a dataex:

    Code:
    * Example generated by -dataex-. For more info, type help dataex
    clear
    input float id_numerical byte sp_zipcode_twodigits long(power_p1 power_p2 power_p6) str13 product_classification
     468766 1 3450 3450 . "Clasico"      
     753801 1 3450 3450 . "Clasico"      
     868864 1 1000    . . "Clasico"      
     538474 1 3300 3300 . "Clasico"      
     117736 1 2800 2800 . "Tarifa Justa" 
     957926 1 3450    . . "Sin Sorpresas"
    1065497 1 9400 9400 . "Clasico"      
     765602 1 3450 3450 . "Tarifa Justa" 
     141017 1 3450    . . "Sin Sorpresas"
     158792 1 3450 3450 . "Clasico"      
     138014 1 3300 3300 . "Clasico"      
     193737 1 5500 5500 . "Tarifa Justa" 
     207352 1 3450 3450 . "Sin Sorpresas"
      80188 1 3300 3300 . "Tarifa Justa" 
     392312 1 2200    . . "Clasico"      
     413147 1 3450 3450 . "Clasico"      
     177248 1 3300 3300 . "Clasico"      
     234988 1 3300 3300 . "Sin Sorpresas"
     383765 1 2300 2300 . "Tarifa Justa" 
     105657 1 3400 3400 . "Tarifa Justa" 
     107116 1 3100 3100 . "Tarifa Justa" 
     155602 1 3300 3300 . "Clasico"      
     430455 1 3450 3450 . "Tarifa Justa" 
     772213 1 2300 2300 . "Clasico"      
     212555 1 3450 3450 . "Sin Sorpresas"
     518286 1 3450 3450 . "Sin Sorpresas"
     413969 1 3450 3450 . "Tarifa Justa" 
     117494 1 4000 4000 . "Clasico"      
     160695 1 3450    . . "Sin Sorpresas"
     213550 1 3450 3450 . "Tarifa Justa" 
     165627 1 3450    . . "Sin Sorpresas"
     399430 1 3450 3450 . "Clasico"      
     933379 1 1725 1725 . "Clasico"      
     999214 1 5500 5500 . "Clasico"      
     485765 1 2000 2000 . "Tarifa Justa" 
     824452 1 2300 2300 . "Tarifa Justa" 
     867405 1 3300 3300 . "Sin Sorpresas"
     531980 1 3300 3300 . "Clasico"      
     791532 1 3300 3300 . "Clasico"      
     892332 1 3450 3450 . "Tarifa Justa" 
     124208 1    .    . . "Clasico"      
    1259999 1 2300 2300 . "Tarifa Justa" 
     429256 1 1725    . . "Clasico"      
     164374 1 3300 3300 . "Tarifa Justa" 
    1078414 1 2300 2300 . "Tarifa Justa" 
    1278400 1 2300 2300 . "Clasico"      
     766449 1 3100 3100 . "Tarifa Justa" 
     386397 1 3000 3000 . "Tarifa Justa" 
     170801 1 5500 5500 . "Clasico"      
    1078162 1 6200 6200 . "Clasico"      
     618357 1 3450    . . "Sin Sorpresas"
     203635 1 3450 3450 . "Clasico"      
     181621 1 3400 3400 . "Tarifa Justa" 
     754229 1 2200 2200 . "Tarifa Justa" 
    1201883 1 1150 1150 . "Clasico"      
     786996 1 3450 3450 . "Sin Sorpresas"
     177351 1 2300 2300 . "Clasico"      
     872791 1 3450    . . "Clasico"      
     460462 1 3100    . . "Clasico"      
     173233 1 3450    . . "Sin Sorpresas"
     154347 1 2300 2300 . "Tarifa Justa" 
     175603 1 3450    . . "Clasico"      
     102637 1 3300 3300 . "Sin Sorpresas"
     680203 1 2300 2300 . "Sin Sorpresas"
     918395 1 3450 3450 . "Clasico"      
     808119 1 3450 3450 . "Tarifa Justa" 
    1271978 1 3450 3450 . "Tarifa Justa" 
     374043 1 3300 3300 . "Clasico"      
     836073 1 5400 5400 . "Tarifa Justa" 
     829933 1 2300 2300 . "Clasico"      
     280286 1 3450 3450 . "Tarifa Justa" 
     320711 1 3300 3300 . "Clasico"      
     100353 1 3450 3450 . "Clasico"      
     251739 1 3450 3450 . "Sin Sorpresas"
      56467 1 3450    . . "Clasico"      
     231140 1 3450 3450 . "Clasico"      
     101139 1 3450 3450 . "Tarifa Justa" 
    1042178 1 2800 2800 . "Tarifa Justa" 
    1013042 1 2200 2200 . "Tarifa Justa" 
     194043 1 2300 2300 . "Clasico"      
     488513 1 3300 3300 . "Clasico"      
     118836 1 3100    . . "Tarifa Justa" 
     963042 1 2300 2300 . "Sin Sorpresas"
    1202264 1 3450 3450 . "Tarifa Justa" 
     172981 1 3450 3450 . "Clasico"      
     945251 1 3450    . . "Sin Sorpresas"
     544481 1 3450 3450 . "Sin Sorpresas"
    1227786 1 2300 2300 . "Tarifa Justa" 
     441368 1 2300 2300 . "Clasico"      
     292542 1 3450 3450 . "Clasico"      
     563942 1 3450 3450 . "Clasico"      
     106644 1 3450 3450 . "Clasico"      
     405790 1 3300 3300 . "Clasico"      
    1109581 1 3450 3450 . "Sin Sorpresas"
    1144596 1 3450    . . "Clasico"      
     970186 1 2300 2300 . "Tarifa Justa" 
     233154 1 2800 2800 . "Tarifa Justa" 
     645069 1 2300 2300 . "Indexado"     
     425867 1 3400 3400 . "Tarifa Justa" 
     435772 1 2300 2300 . "Tarifa Justa" 
    end


    Can you give me an insight about a potential graph that I could make with that?
    Thank you so much in advance. I've been stuck since a while now.

    Best,

    Michael
Working...
X