Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    Generating Blau Diversity Index

    Hello Statalist,

    I'm looking to generate a diversity index, identical to the following - see picture;

    However, I'm having some difficulty with the code.

    Code:
    *Total Squad Numbers
egen totalsquad = count(number), by(id year)
*Number of Unique Nationality in a squad
bysort id nat year: egen div =sum(playercount)
*Share of Unique Nationalities in %squad
gen divi = div/totalsquad
*Squaring each of unique nationalities in a squad
gen divi2 =divi^2
*Summing values by team and year
bysort id year: egen total =sum(divi2)
*Blau method
gen blau = 1-divi2
collapse teamdiv blau, by( team id year)
    I thought these commands would generate a value similar to what is the example attached to the picture, however it doesn't.

    Would anyone have a work around to my issue?

    Any advice welcome.

    Edit - I've attached some sample data.
    Code:
    * Example generated by -dataex-. To install: ssc install dataex
clear
input byte id str9 year str17 team byte playercount str3 nat
 1 "2009/2010" "Arsenal"           1 "BEL"
 1 "2009/2010" "Arsenal"           1 "BRA"
 1 "2009/2010" "Arsenal"           1 "CIV"
 1 "2009/2010" "Arsenal"           1 "CMR"
 1 "2009/2010" "Arsenal"           1 "CRO"
 1 "2009/2010" "Arsenal"           1 "CZE"
 1 "2009/2010" "Arsenal"           1 "DEN"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ENG"
 1 "2009/2010" "Arsenal"           1 "ESP"
 1 "2009/2010" "Arsenal"           1 "ESP"
 1 "2009/2010" "Arsenal"           1 "ESP"
 1 "2009/2010" "Arsenal"           1 "FRA"
 1 "2009/2010" "Arsenal"           1 "FRA"
 1 "2009/2010" "Arsenal"           1 "FRA"
 1 "2009/2010" "Arsenal"           1 "FRA"
 1 "2009/2010" "Arsenal"           1 "FRA"
 1 "2009/2010" "Arsenal"           1 "FRA"
 1 "2009/2010" "Arsenal"           1 "FRA"
 1 "2009/2010" "Arsenal"           1 "FRA"
 1 "2009/2010" "Arsenal"           1 "FRA"
 1 "2009/2010" "Arsenal"           1 "FRA"
 1 "2009/2010" "Arsenal"           1 "IRL"
 1 "2009/2010" "Arsenal"           1 "ITA"
 1 "2009/2010" "Arsenal"           1 "MEX"
 1 "2009/2010" "Arsenal"           1 "NED"
 1 "2009/2010" "Arsenal"           1 "NED"
 1 "2009/2010" "Arsenal"           1 "POL"
 1 "2009/2010" "Arsenal"           1 "RUS"
 1 "2009/2010" "Arsenal"           1 "SUI"
 1 "2009/2010" "Arsenal"           1 "WAL"
 1 "2010/2011" "Arsenal"           1 "ARG"
 1 "2010/2011" "Arsenal"           1 "BEL"
 1 "2010/2011" "Arsenal"           1 "BRA"
 1 "2010/2011" "Arsenal"           1 "CIV"
 1 "2010/2011" "Arsenal"           1 "CMR"
 1 "2010/2011" "Arsenal"           1 "CZE"
 1 "2010/2011" "Arsenal"           1 "DEN"
 1 "2010/2011" "Arsenal"           1 "ENG"
 1 "2010/2011" "Arsenal"           1 "ENG"
 1 "2010/2011" "Arsenal"           1 "ENG"
 1 "2010/2011" "Arsenal"           1 "ENG"
 1 "2010/2011" "Arsenal"           1 "ENG"
 1 "2010/2011" "Arsenal"           1 "ENG"
 1 "2010/2011" "Arsenal"           1 "ENG"
 1 "2010/2011" "Arsenal"           1 "ENG"
 1 "2010/2011" "Arsenal"           1 "ENG"
 1 "2010/2011" "Arsenal"           1 "ENG"
 1 "2010/2011" "Arsenal"           1 "ESP"
 1 "2010/2011" "Arsenal"           1 "ESP"
 1 "2010/2011" "Arsenal"           1 "ESP"
 1 "2010/2011" "Arsenal"           1 "FRA"
 1 "2010/2011" "Arsenal"           1 "FRA"
 1 "2010/2011" "Arsenal"           1 "FRA"
 1 "2010/2011" "Arsenal"           1 "FRA"
 1 "2010/2011" "Arsenal"           1 "FRA"
 1 "2010/2011" "Arsenal"           1 "FRA"
 1 "2010/2011" "Arsenal"           1 "GER"
 1 "2010/2011" "Arsenal"           1 "IRL"
 1 "2010/2011" "Arsenal"           1 "IRL"
 1 "2010/2011" "Arsenal"           1 "MAR"
 1 "2010/2011" "Arsenal"           1 "NED"
 1 "2010/2011" "Arsenal"           1 "NED"
 1 "2010/2011" "Arsenal"           1 "POL"
 1 "2010/2011" "Arsenal"           1 "POL"
 1 "2010/2011" "Arsenal"           1 "RUS"
 1 "2010/2011" "Arsenal"           1 "SUI"
 1 "2010/2011" "Arsenal"           1 "WAL"
 1 "2011/2012" "Arsenal"           1 "ARG"
 1 "2011/2012" "Arsenal"           1 "BEL"
 1 "2011/2012" "Arsenal"           1 "BRA"
 1 "2011/2012" "Arsenal"           1 "CIV"
 1 "2011/2012" "Arsenal"           1 "CMR"
 1 "2011/2012" "Arsenal"           1 "CZE"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ENG"
 1 "2011/2012" "Arsenal"           1 "ESP"
 1 "2011/2012" "Arsenal"           1 "ESP"
 1 "2011/2012" "Arsenal"           1 "ESP"
 1 "2011/2012" "Arsenal"           1 "FRA"
 1 "2011/2012" "Arsenal"           1 "FRA"
 1 "2011/2012" "Arsenal"           1 "FRA"
 1 "2011/2012" "Arsenal"           1 "FRA"
 1 "2011/2012" "Arsenal"           1 "FRA"
 1 "2011/2012" "Arsenal"           1 "GER"
 1 "2011/2012" "Arsenal"           1 "IRL"
 1 "2011/2012" "Arsenal"           1 "IRL"
 1 "2011/2012" "Arsenal"           1 "ISR"
 1 "2011/2012" "Arsenal"           1 "KOR"
 1 "2011/2012" "Arsenal"           1 "MAR"
 1 "2011/2012" "Arsenal"           1 "NED"
 1 "2011/2012" "Arsenal"           1 "NED"
 1 "2011/2012" "Arsenal"           1 "POL"
 1 "2011/2012" "Arsenal"           1 "POL"
 1 "2011/2012" "Arsenal"           1 "SUI"
 1 "2011/2012" "Arsenal"           1 "SUI"
 1 "2011/2012" "Arsenal"           1 "SUI"
 1 "2011/2012" "Arsenal"           1 "SUI"
 1 "2011/2012" "Arsenal"           1 "TUR"
 1 "2011/2012" "Arsenal"           1 "WAL"
 1 "2012/2013" "Arsenal"           1 "ARG"
 1 "2012/2013" "Arsenal"           1 "BEL"
 1 "2012/2013" "Arsenal"           1 "CIV"
 1 "2012/2013" "Arsenal"           1 "CZE"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ENG"
 1 "2012/2013" "Arsenal"           1 "ESP"
 1 "2012/2013" "Arsenal"           1 "ESP"
 1 "2012/2013" "Arsenal"           1 "ESP"
 1 "2012/2013" "Arsenal"           1 "ESP"
 1 "2012/2013" "Arsenal"           1 "ESP"
 1 "2012/2013" "Arsenal"           1 "ESP"
 1 "2012/2013" "Arsenal"           1 "FRA"
 1 "2012/2013" "Arsenal"           1 "FRA"
 1 "2012/2013" "Arsenal"           1 "FRA"
 1 "2012/2013" "Arsenal"           1 "FRA"
 1 "2012/2013" "Arsenal"           1 "FRA"
 1 "2012/2013" "Arsenal"           1 "FRA"
 1 "2012/2013" "Arsenal"           1 "GER"
 1 "2012/2013" "Arsenal"           1 "GER"
 1 "2012/2013" "Arsenal"           1 "GER"
 1 "2012/2013" "Arsenal"           1 "GER"
 1 "2012/2013" "Arsenal"           1 "IRL"
 1 "2012/2013" "Arsenal"           1 "ITA"
 1 "2012/2013" "Arsenal"           1 "MKD"
 1 "2012/2013" "Arsenal"           1 "NED"
 1 "2012/2013" "Arsenal"           1 "POL"
 1 "2012/2013" "Arsenal"           1 "POL"
 1 "2012/2013" "Arsenal"           1 "RUS"
 1 "2012/2013" "Arsenal"           1 "SUI"
 1 "2012/2013" "Arsenal"           1 "SUI"
 1 "2012/2013" "Arsenal"           1 "SUI"
 1 "2012/2013" "Arsenal"           1 "SWE"
 1 "2012/2013" "Arsenal"           1 "WAL"
 1 "2013/2014" "Arsenal"           1 "BEL"
 1 "2013/2014" "Arsenal"           1 "CZE"
 1 "2013/2014" "Arsenal"           1 "DEN"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ENG"
 1 "2013/2014" "Arsenal"           1 "ESP"
 1 "2013/2014" "Arsenal"           1 "ESP"
 1 "2013/2014" "Arsenal"           1 "ESP"
 1 "2013/2014" "Arsenal"           1 "ESP"
 1 "2013/2014" "Arsenal"           1 "ESP"
 1 "2013/2014" "Arsenal"           1 "ESP"
 1 "2013/2014" "Arsenal"           1 "FIN"
 1 "2013/2014" "Arsenal"           1 "FRA"
 1 "2013/2014" "Arsenal"           1 "FRA"
 1 "2013/2014" "Arsenal"           1 "FRA"
 1 "2013/2014" "Arsenal"           1 "FRA"
 1 "2013/2014" "Arsenal"           1 "FRA"
 1 "2013/2014" "Arsenal"           1 "FRA"
 1 "2013/2014" "Arsenal"           1 "GER"
 1 "2013/2014" "Arsenal"           1 "GER"
 1 "2013/2014" "Arsenal"           1 "GER"
 1 "2013/2014" "Arsenal"           1 "GER"
 1 "2013/2014" "Arsenal"           1 "GER"
 1 "2013/2014" "Arsenal"           1 "GER"
 1 "2013/2014" "Arsenal"           1 "GER"
 1 "2013/2014" "Arsenal"           1 "ITA"
 1 "2013/2014" "Arsenal"           1 "JPN"
 1 "2013/2014" "Arsenal"           1 "MKD"
 1 "2013/2014" "Arsenal"           1 "NGA"
 1 "2013/2014" "Arsenal"           1 "POL"
 1 "2013/2014" "Arsenal"           1 "POL"
 1 "2013/2014" "Arsenal"           1 "RWA"
 1 "2013/2014" "Arsenal"           1 "SWE"
 1 "2013/2014" "Arsenal"           1 "SWE"
 1 "2013/2014" "Arsenal"           1 "SWE"
 1 "2013/2014" "Arsenal"           1 "WAL"
 1 "2014/2015" "Arsenal"           1 "ARG"
 1 "2014/2015" "Arsenal"           1 "BOL"
 1 "2014/2015" "Arsenal"           1 "BRA"
 1 "2014/2015" "Arsenal"           1 "CHI"
 1 "2014/2015" "Arsenal"           1 "COL"
 1 "2014/2015" "Arsenal"           1 "CZE"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ENG"
 1 "2014/2015" "Arsenal"           1 "ESP"
 1 "2014/2015" "Arsenal"           1 "ESP"
 1 "2014/2015" "Arsenal"           1 "ESP"
 1 "2014/2015" "Arsenal"           1 "ESP"
 1 "2014/2015" "Arsenal"           1 "ESP"
 1 "2014/2015" "Arsenal"           1 "FIN"
 1 "2014/2015" "Arsenal"           1 "FIN"
 1 "2014/2015" "Arsenal"           1 "FRA"
 1 "2014/2015" "Arsenal"           1 "FRA"
 1 "2014/2015" "Arsenal"           1 "FRA"
 1 "2014/2015" "Arsenal"           1 "FRA"
 1 "2014/2015" "Arsenal"           1 "FRA"
 1 "2014/2015" "Arsenal"           1 "FRA"
 1 "2014/2015" "Arsenal"           1 "GER"
 1 "2014/2015" "Arsenal"           1 "GER"
 1 "2014/2015" "Arsenal"           1 "GER"
 1 "2014/2015" "Arsenal"           1 "GER"
 1 "2014/2015" "Arsenal"           1 "GRE"
 1 "2014/2015" "Arsenal"           1 "GRE"
 1 "2014/2015" "Arsenal"           1 "MKD"
 1 "2014/2015" "Arsenal"           1 "POL"
 1 "2014/2015" "Arsenal"           1 "POL"
 1 "2014/2015" "Arsenal"           1 "POR"
 1 "2014/2015" "Arsenal"           1 "SWE"
 1 "2014/2015" "Arsenal"           1 "WAL"
 2 "2009/2010" "Aston Villa"       1 "AUS"
 2 "2009/2010" "Aston Villa"       1 "AUT"
 2 "2009/2010" "Aston Villa"       1 "BUL"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ENG"
 2 "2009/2010" "Aston Villa"       1 "ESP"
 2 "2009/2010" "Aston Villa"       1 "IRL"
 2 "2009/2010" "Aston Villa"       1 "NED"
 2 "2009/2010" "Aston Villa"       1 "NOR"
 2 "2009/2010" "Aston Villa"       1 "SEN"
 2 "2009/2010" "Aston Villa"       1 "TOG"
 2 "2009/2010" "Aston Villa"       1 "USA"
 2 "2009/2010" "Aston Villa"       1 "USA"
 2 "2009/2010" "Aston Villa"       1 "USA"
 2 "2009/2010" "Aston Villa"       1 "WAL"
 2 "2010/2011" "Aston Villa"       1 "AUS"
 2 "2010/2011" "Aston Villa"       1 "BUL"
 2 "2010/2011" "Aston Villa"       1 "CMR"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ENG"
 2 "2010/2011" "Aston Villa"       1 "ESP"
 2 "2010/2011" "Aston Villa"       1 "FRA"
 2 "2010/2011" "Aston Villa"       1 "IRL"
 2 "2010/2011" "Aston Villa"       1 "IRL"
 2 "2010/2011" "Aston Villa"       1 "SCO"
 2 "2010/2011" "Aston Villa"       1 "SEN"
 2 "2010/2011" "Aston Villa"       1 "TOG"
 2 "2010/2011" "Aston Villa"       1 "USA"
 2 "2010/2011" "Aston Villa"       1 "USA"
 2 "2010/2011" "Aston Villa"       1 "USA"
 2 "2010/2011" "Aston Villa"       1 "USA"
 2 "2010/2011" "Aston Villa"       1 "WAL"
 2 "2011/2012" "Aston Villa"       1 "AUS"
 2 "2011/2012" "Aston Villa"       1 "AUT"
 2 "2011/2012" "Aston Villa"       1 "BUL"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ENG"
 2 "2011/2012" "Aston Villa"       1 "ESP"
 2 "2011/2012" "Aston Villa"       1 "FRA"
 2 "2011/2012" "Aston Villa"       1 "IRL"
 2 "2011/2012" "Aston Villa"       1 "IRL"
 2 "2011/2012" "Aston Villa"       1 "IRL"
 2 "2011/2012" "Aston Villa"       1 "IRL"
 2 "2011/2012" "Aston Villa"       1 "IRL"
 2 "2011/2012" "Aston Villa"       1 "IRL"
 2 "2011/2012" "Aston Villa"       1 "IRL"
 2 "2011/2012" "Aston Villa"       1 "IRL"
 2 "2011/2012" "Aston Villa"       1 "IRL"
 2 "2011/2012" "Aston Villa"       1 "SCO"
 2 "2011/2012" "Aston Villa"       1 "SCO"
 2 "2011/2012" "Aston Villa"       1 "USA"
 2 "2011/2012" "Aston Villa"       1 "USA"
 2 "2011/2012" "Aston Villa"       1 "WAL"
 2 "2012/2013" "Aston Villa"       1 "AUS"
 2 "2012/2013" "Aston Villa"       1 "AUS"
 2 "2012/2013" "Aston Villa"       1 "AUT"
 2 "2012/2013" "Aston Villa"       1 "BEL"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "ENG"
 2 "2012/2013" "Aston Villa"       1 "FRA"
 2 "2012/2013" "Aston Villa"       1 "FRA"
 2 "2012/2013" "Aston Villa"       1 "IRL"
 2 "2012/2013" "Aston Villa"       1 "IRL"
 2 "2012/2013" "Aston Villa"       1 "IRL"
 2 "2012/2013" "Aston Villa"       1 "IRL"
 2 "2012/2013" "Aston Villa"       1 "IRL"
 2 "2012/2013" "Aston Villa"       1 "IRL"
 2 "2012/2013" "Aston Villa"       1 "IRL"
 2 "2012/2013" "Aston Villa"       1 "IRL"
 2 "2012/2013" "Aston Villa"       1 "MAR"
 2 "2012/2013" "Aston Villa"       1 "NED"
 2 "2012/2013" "Aston Villa"       1 "SCO"
 2 "2012/2013" "Aston Villa"       1 "SUI"
 2 "2012/2013" "Aston Villa"       1 "USA"
 2 "2012/2013" "Aston Villa"       1 "USA"
 2 "2013/2014" "Aston Villa"       1 "AUS"
 2 "2013/2014" "Aston Villa"       1 "AUT"
 2 "2013/2014" "Aston Villa"       1 "BEL"
 2 "2013/2014" "Aston Villa"       1 "BUL"
 2 "2013/2014" "Aston Villa"       1 "CZE"
 2 "2013/2014" "Aston Villa"       1 "DEN"
 2 "2013/2014" "Aston Villa"       1 "DEN"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ENG"
 2 "2013/2014" "Aston Villa"       1 "ESP"
 2 "2013/2014" "Aston Villa"       1 "IRL"
 2 "2013/2014" "Aston Villa"       1 "IRL"
 2 "2013/2014" "Aston Villa"       1 "IRL"
 2 "2013/2014" "Aston Villa"       1 "LCA"
 2 "2013/2014" "Aston Villa"       1 "MAR"
 2 "2013/2014" "Aston Villa"       1 "MLI"
 2 "2013/2014" "Aston Villa"       1 "NED"
 2 "2013/2014" "Aston Villa"       1 "NED"
 2 "2013/2014" "Aston Villa"       1 "USA"
 2 "2014/2015" "Aston Villa"       1 "AUS"
 2 "2014/2015" "Aston Villa"       1 "AUT"
 2 "2014/2015" "Aston Villa"       1 "BEL"
 2 "2014/2015" "Aston Villa"       1 "COL"
 2 "2014/2015" "Aston Villa"       1 "CZE"
 2 "2014/2015" "Aston Villa"       1 "DEN"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ENG"
 2 "2014/2015" "Aston Villa"       1 "ESP"
 2 "2014/2015" "Aston Villa"       1 "FRA"
 2 "2014/2015" "Aston Villa"       1 "FRA"
 2 "2014/2015" "Aston Villa"       1 "IRL"
 2 "2014/2015" "Aston Villa"       1 "IRL"
 2 "2014/2015" "Aston Villa"       1 "IRL"
 2 "2014/2015" "Aston Villa"       1 "IRL"
 2 "2014/2015" "Aston Villa"       1 "LCA"
 2 "2014/2015" "Aston Villa"       1 "NED"
 2 "2014/2015" "Aston Villa"       1 "NED"
 2 "2014/2015" "Aston Villa"       1 "SCO"
 2 "2014/2015" "Aston Villa"       1 "SUI"
 2 "2014/2015" "Aston Villa"       1 "SUI"
 2 "2014/2015" "Aston Villa"       1 "USA"
    1 Photo
    Last edited by Sean O'Connor; 26 Apr 2016, 09:07.
    Tags: None
  • #2
    It is very difficult to go back & forth between a photo and the code. Please make some attempt to render the formula in the text. Please provide some examples of your data (see FAQ, especially #12), perhaps one id for one year, using dataex. You reference variables in the code that are undefined to us (player count, number, etc). Providing the data will help.

    Code:
    ssc install dataex
help dataex
*something like dataex if id==1 & year==2000
    One observation: You might be summing across all players instead of just the categories. egen tag() might be helpful here to "tag" one observation per category (each nationality) and then sum if tag==1
    Stata/MP 14.1 (64-bit x86-64)
    Revision 19 May 2016
    Win 8.1

    Comment

    • #3
      The Blau index was invented by many people before Blau, e.g. Gini.

      Here's one way.

      Code:
       
. sysuse auto, clear
(1978 Automobile Data)

. tab rep78, matcell(freq)

     Repair |
Record 1978 |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |          2        2.90        2.90
          2 |          8       11.59       14.49
          3 |         30       43.48       57.97
          4 |         18       26.09       84.06
          5 |         11       15.94      100.00
------------+-----------------------------------
      Total |         69      100.00

. mat li freq

freq[5,1]
    c1
r1   2
r2   8
r3  30
r4  18
r5  11

. mata
------------------------------------------------- mata (type end to exit) -------------------------------
: freq =  st_matrix("freq")

: freq :/ sum(freq)
                 1
    +---------------+
  1 |  .0289855072  |
  2 |   .115942029  |
  3 |  .4347826087  |
  4 |  .2608695652  |
  5 |  .1594202899  |
    +---------------+

: 1 - sum((freq :/ sum(freq)):^2)
  .7032136106

: end 
---------------------------------------------------------------------------------------------------------
      .

      Comment

      • #4
        Check divcat module
        ssc des divcat
        GV generalized variance is known as Blau index
        Emad A. Shehata
        Professor (PhD Economics)
        Agricultural Research Center - Agricultural Economics Research Institute - Egypt
        Email: [email protected]
        IDEAS: http://ideas.repec.org/f/psh494.html
        EconPapers: http://econpapers.repec.org/RAS/psh494.htm
        Google Scholar: http://scholar.google.com/citations?...r=cOXvc94AAAAJ

        Comment

        • #5
          Dear Sean
          In fact fortunately you can use divcat or (ineq) module for Nick
          to calculate directly Blau index
          Emad A. Shehata
          Professor (PhD Economics)
          Agricultural Research Center - Agricultural Economics Research Institute - Egypt
          Email: [email protected]
          IDEAS: http://ideas.repec.org/f/psh494.html
          EconPapers: http://econpapers.repec.org/RAS/psh494.htm
          Google Scholar: http://scholar.google.com/citations?...r=cOXvc94AAAAJ

          Comment

          • #6

            Code:
            clear all
input id y
 1 2
 2 8
 3 30
 4 18
 5 11
 end
 divcat id [fw = y], t base(e)
 ineq y
* Blau = 1 - Simpson
* Blau = 1 - 0.2968 = 0.7032
            HTML Code:
            .  divcat id [fw = y], t base(e)

Measures of Diversity

-------------------------------------------------------------------------
                 | categs      GV     NGV       H      NH      RQ       n
-----------------+-------------------------------------------------------
  (total sample) |      5   0.703   0.879   1.358   0.844   0.765      69
-------------------------------------------------------------------------
Note: Entropy (H) is calculated using the logarithm to base e
.
.  ineq y

----------------------------------------------------------
    group |       freq     Simpson     entropy     dissim.
----------+-----------------------------------------------
      all |          5       0.297       1.358       0.296
----------------------------------------------------------

. * Blau = 1 - Simpson
. * Blau = 1 - 0.2968 = 0.7032
            Emad A. Shehata
            Professor (PhD Economics)
            Agricultural Research Center - Agricultural Economics Research Institute - Egypt
            Email: [email protected]
            IDEAS: http://ideas.repec.org/f/psh494.html
            EconPapers: http://econpapers.repec.org/RAS/psh494.htm
            Google Scholar: http://scholar.google.com/citations?...r=cOXvc94AAAAJ

            Comment

            • #7
              See also this thread http://www.statalist.org/forums/foru...index-in-stata e.g. #5 for the essence in two calls to egen

              Comment

              • #8
                Hi,

                How would you code either approach above to compute the blau index for individuals on teams? My particular application is that I'd like to know how interdisciplinary each team is given the college values (1=this college, 2=that college, 3=other college) for each individual on the team, and then document that diversity value for each individual.

                An example of how to set the code up would be very helpful me and useful to others. Thanks!

                Thomas



                Comment

                • #9
                  Thomas: I don't follow what you want from a word description. I don't understand how a team index can differ between individuals, unless you're excluding the other members from the calculation. Use a data example to illustrate your answer. There are several already in this thread.

                  Comment

                  Previous Next
                  Working...
                  X