GINI - Gini Coefficient

Returns the sample Gini coefficient, a measure of statistical dispersion.

Syntax

Gini(X)
X
is the input data sample (must be non-negative) (a one dimensional array of cells (e.g. rows or columns)).

Remarks

1. A low Gini coefficient indicates a more equal distribution, with 0 corresponding to complete equality. While higher Gini coefficients indicate more unequal distributions, with 1 corresponding to complete inequality.
2. The input data series may include missing values (e.g. #N/A, #VALUE!, #NUM!, empty cell), but they will not be included in the calculations.
3. The values in the input data series must be non-negative.
4. The Gini coefficient is computed as follows:

$$G(S)=1-\frac{2}{n-1}\left ( n-\frac{\sum_{i=1}^{n}iy_i}{\sum_{i=1}^{n}y_i} \right )$$

Where
• $h$ is the input data series ($h$) arranged in descending order, so that $y_i\leq y_{i+1}$
• $n$ is the number of non-missing values in the input time series data sample
5. The Gini coefficient value can range from 0 to 1 and is half the relative mean difference (RMD).
6. $G(S)$ is a consistent estimator of the population Gini coefficient, but is generally unbiased (except when the population mean is known).
7. Developed by the Italian statistician Corrado Gini in 1912, the Gini coefficient is commonly used as a measure of comparative income or wealth. Where zero (0) corresponds to complete equality and one (1) to complete equality.

Examples

Example 1:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A B
Date Data
1/1/2008 #N/A
1/2/2008 1.28
1/3/2008 0.24
1/4/2008 1.28
1/5/2008 1.20
1/6/2008 1.73
1/7/2008 2.18
1/8/2008 0.23
1/9/2008 1.10
1/10/2008 1.09
1/11/2008 0.69
1/12/2008 1.69
1/13/2008 1.85
1/14/2008 0.98
1/15/2008 0.77
1/16/2008 0.30
1/17/2008 1.28
1/18/2008 0.24
1/19/2008 1.28
1/20/2008 1.20
1/21/2008 1.73
1/22/2008 2.18
1/23/2008 0.23
1/24/2008 1.10
1/25/2008 1.09
1/26/2008 0.69
1/27/2008 1.69
1/28/2008 1.85
1/29/2008 0.98
Formula Description (Result)
=GINI($B$2:$B$30) Gini Coefficient (0.280749)