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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
