Announcement

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

  • fractionalisation and Polarisation

    Dear users, I want to create an index of district-wise fractionalisation and Polarisation.
    There are two groups and four districts in my data.

    Code:
    bysort district group: gen group_count = _N  // Count of each group within a district
    bysort district: egen total_count = count(group)  // Total count of people in each district
    
    **Ethnic Fractionalization**
    bysort district: gen sharec=group_count/total_count //each group's share in respective district total
    bysort district: gen sharec_sq=sharec*sharec //square of each group's share
    How to proceed further to construct final Indices?

    The reference paper is: https://www.jstor.org/stable/4132741

    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input float(group district group_count total_count sharec sharec_sq)
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    1 1 216 381 .56692916  .3214087
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    2 1 165 381  .4330709  .1875504
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    1 2  91 143  .6363636  .4049587
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    2 2  52 143  .3636364 .13223141
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    1 3  42  64    .65625  .4306641
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    2 3  22  64    .34375 .11816406
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    1 4 148 254  .5826772  .3395127
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    2 4 106 254  .4173228 .17415835
    end


    Thank you!

    I am using STATA 15.1, SE
    Last edited by Mukesh Punia; 13 Sep 2024, 09:11.
    Best regards,
    Mukesh

  • #2
    Dear Clyde Schechter George Ford Carlo Lazzaro can you please find some time to look into it.
    Best regards,
    Mukesh

    Comment


    • #3
      This may help, modulo subtraction from 1.


      Code:
      . order district group
      
      . sort district group
      
      . egen tag = tag(district group)
      
      . egen wanted = total(tag * sharec_sq), by(district)
      
      . tabdisp district group, c(sharec* wanted)
      
      ------------------------------
                |       group       
       district |        1         2
      ----------+-------------------
              1 | .5669292  .4330709
                | .3214087  .1875504
                | .5089591  .5089591
                | 
              2 | .6363636  .3636364
                | .4049587  .1322314
                | .5371901  .5371901
                | 
              3 |   .65625    .34375
                | .4306641  .1181641
                | .5488281  .5488281
                | 
              4 | .5826772  .4173228
                | .3395127  .1741583
                |  .513671   .513671
      ------------------------------

      Comment


      • #4
        To my understanding, the more methodologically focused publication on Reynal-Querol's polarisation measure is:
        Marta Reynal-Querol. 2002. Ethnicity, Political Systems, and Civil Wars. Journal of Conflict Resolution. 46,1:29-54.

        The so-called "rq index" ("IRC1") is on p. 33, if my old notes are correct. See -ssc describe rq-.

        What I also have that might be of interest is that I derived the standard error of the rq index, and my program also calculates a Delta-Method estimator of that. I have never put this program out for the public, since it's no big deal. (I wrote it for a student of mine to use in her M.A. thesis so the code is not too "fancy." It is "byable," which appears relevant for your problem). If you want to contact me directly, we could work something out for you to use it..

        (Added) To clarify: One of the authors of the article Mukesh cites is Reynal-Querol.
        Last edited by Mike Lacy; 16 Sep 2024, 19:28.

        Comment

        Working...
        X