|
GINICOEFF function
The GINICOEFF function calculates the Gini inequality coefficient using the Angus Deaton formula. Empty cells and blank cells are ignored. If there are any negative numbers in the input data the entire data series is offset by the absolute value of the largest negative number found. Bias correction is optional but applied by default.
GINICOEFF is multithreaded, is NOT volatile and is NOT an array function.
GINICOEFF Syntax:
GINICOEFF(InputData, Sorted, BiasCorrect)
InputData (required)
InputData must be a single row or column (range, array or calculated values) of numeric data.
Sorted (Optional)
-1 for sorted descending
0 for unsorted
1 for sorted ascending
The default is Unsorted
BiasCorrect (Optional)
True to include the Bias Correction factor
False to exclude the Bias Correction factor
Default is True
|
