Can't tell you waht is going on - statistics was not my forte - and I am on a different version so you would not be able to open a workbook
That said the issue is in the Gini calc - see below
this is your chart as a cross tab - the last 3 columns are the Gini numerator - the denominator and then the manual numerator/denominator
The 6th column is the Gini calculation from formula - I also included the index and the size in the table
Don't know what the numerical result you expected but at least you can see what is being returned from the parts and total formula
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks a million.I need to review table calculations across specific dimensions.
Technically, yes, the sort order should be reversed (ascending), but in this case I want to graph the opposite way - I think it is more revealing. But I can simply take the abs() of the result.
Thanks for your effort. I should have given a more verbose explanation, but Gerardo was able to read between the lines. (accidental pun there)
1 of 1 people found this helpful
You're welcome. There isn't a need to take the ABS you could just reverse the sort to descending and it'll give you what you are looking for. Here is a pretty handy link:
that's alright - you are out on the forum enough to understand