can anybody help me out with incorporation of the Gini
coefficient function in an excel worksheet
Given the definition in
http://mathworld.wolfram.com/GiniCoefficient.html (a
site it appears too many respondents don't know), with values in a range named
X, and you want the population statistic, try the array formula
=SUM(ABS(X-TRANSPOSE(X)))/(2*SUM(X)*(COUNT(X)-1))
[This can't be replaced by SUMPRODUCT because ABS is one of the old, stupidly
implemented functions that can't handle array arguments unless array-entered.]
Note that all values in X must be nonnegative for this statistic to be
meaningful.
