Creating a Custom Excel Function to Calculate Gini Coefficients
Harlan,
Your code is very helpful. Thanks!
I have noticed one thing though. In order for the calculation to be
accurate, there cannot be any missing data in the array. At first I
thought that maybe the functions are treating the missing values as
zeros, but they are not. The effect of the missing values on the gini
coefficient is less than zero. Is there something that can be added to
function to have it ignore missing values?
John
|