P
peter
can anybody help me out with incorporation of the Gini
coefficient function in an excel worksheet
Thanks in advance!
coefficient function in an excel worksheet
Thanks in advance!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard V Liengme
And the Gini coefficient function is........?
Bernard
Bernard
B
Bob Phillips
Bernard,
I guess if we don't know, we can't help <vbg>
Bob
I guess if we don't know, we can't help <vbg>
Bob
A
Alan Beban
B
Bernard V Liengme
See private reply.
B
B
Alan Beban said:
H
Harlan Grove
...See private reply.
If the reply was private and your e-mail wasn't bounced back, why announce to
the world that you replied privately?!
H
Harlan Grove
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.