Gini Index and Lorenz Curve in Excel

There is an earlier video titled Lorenz Curve in Excel. That video does not include the Gini Index. It focuses on how to construct a Lorenz curve from raw data in Excel.

[LX-rvlp]

Thank you for this video. I took an economic class that gave us an assignment without guidance on how to create a Lorenz curve and Gini coefficient. My book only reveals formula without application. Luckily, I was able to learn from you and your videos better than the paid textbook. Thank you.

[martinfiedler]

Wow, honestly THANK for this explanation.
You are the first professor that I experience who explains where the Gini-coefficient originally comes from. Found the article online.

Thank you!

[gerwincordova]

I have searched for some tutorials to calculate GINI, and this is definitely the easiest method I found. Thank you very much for sharing the knowledge. Regards.

[manochehrteimory]

It is time to redefine studying by transition from traditional reading of the printed texts to practical tangible video lessons and that's the point you achieved. Thanks a lot.

[fernandaaguilar]

thanks you so much Arnold for this amazing video! you have no idea how much this helped me. god bless you 🙏🏻

[hindustanfirst]

Thanks a lot sir, it's even helping me after 9yrs of upload

[arnoldhite]

Angelica Marie Gratuito
I am unable to access your comment. It appears as a notification on my side of Youtube. I cannot figure out how to reply. If you had a question about Lorenz Curves or the Gini Index, please post them as comments. I am happy to respond. Alternatively, you can find me, and my email address, on the Charleston Southern University web page.

[karensofiareyes]

Thank you so much! This is helpful. No one explains this like in this video. Best Regards.

[RobiulIslam-ltpx]

i have almost forgot that but your video help me to understand the Gini coefficient. thank you sir

[dandeperdomo]

Excellent Arnold!! my students are so happy, because your explanation es deep and nice!!

[adnkhan]

Thank you. This is super helpful. I have always struggled with this calculation. Hopefully, no more

[mhan]

Thank you so much! You were a lifesaver for my economics class.

[fatennaseha]

Thank you for the fantastic explanation. Would you explain further, does household number affect the population percentage? If for example, the richest individual has the highest income, but also big household number, does it affect the population percentage. And if this is the case, how do we represent the correlation between income and household number in Gini Index and Lauren Curve?

[gunnarjensen]

Your simple Excel setup looks great I would like to experiment with such a program..

[giovanivaldrighi]

Hi, thanks for de video!
It really helped me
Greetings from Brazil

[oluwaseunajele]

thank you, the video was very helpful for my exercise.

[soniadavies]

Thank you so much, very helpful and easy to understand

[yannicko.]

Great vid. Could you also explain how to construct other Inequality measures from this such as Theil Index and more?

[chinamannn]

Hello, for the % outcomes as well as the other decimal answers such as the area a/ gini/ under the lorenz how can i format my excel to round them to the same amount of digits as you have in your sheet?

[kaxuong]

Hi mr Hite. What about cases with negative income or values? Do you have a good approach for that?