Talking about the Gini coefficient applied to hospital management

http://tnc.k12.edu.tw/1002017184/class/equality.swf
We learned how to draw colored pattern (using VBA as cell.Interior.color = RGB(color, color, color) to explain the properties of something regarding to the relationship between multi-variables in addition to the calcaulation of Gini coefficient describing some phenomenon for the equaltity of resource allocation.

Carrying out these analyses is essential to reducing the inequities that are characteristic of the health profile of the Region.

http://www.paho.org/English/SHA/be_v22n1-Gini.htm

That is a example at http://people.hofstra.edu/geotrans/eng/ch4en/meth4en/ch4m1en.html and clicked onto http://people.hofstra.edu/geotrans/eng/gallery/Demo-Gini.xls

SUB COLOR()  

  for jk=102 to 149

  for jk2=2 to 49

             aa=.cells(jk-50,jk2) 

             .cells(jk,jk2).interior.color=rgb(AA,AA,AA)  
    NEXT JK2

NEXT JK

END WITH 

END SUB