Excel: Lorenz Curve and Gini Coefficient - Full Tutorial

[@diegocaicedo36]

Great explanation, love the simplicity and clarity, thanks

[@andersjensenorg]

Hey Diego. Thank you - nice that you took your time to comment :) Kind regards, Anders

[@gauravbansal6940]

Hi Andres, thanks for the great explanation. I followed your instructions but I am stuck at a point. I am trying to create the equality line but when I edit graph data, the pop-up box (at 04:45) asks only for 'series name' and 'series values' instead of separate sections for 'series x value' and 'series y values'. What can I do?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@MarioGiordano96]

Thank you very much for the amazing content! Really well explained.

[@andersjensenorg]

Hey Mario. Thanks a lot 😊 I forgot about this video. Have a great week. Kind regards, Anders

[@bentsusdiary]

Thank you so much for your wonderful tutorial. It's very informative and easy to digest. :-)

[@andersjensenorg]

You're very welcome, ベンツ Bentsu's diary - your support helps me a lot 😍

[@Eridingle]

thank you so much!! this helped me immensely!

[@andersjensenorg]

Hey Eridingle. Thanks a lot for letting me know 😊 Kind regards, Anders

[@Caniballe]

Perfect! That´ll help a lot!

[@andersjensenorg]

Thank you, Paulo 🙂👍

[@Caniballe]

@@andersjensenorg And 4 years later, I always come back to assure I'm doing it right! Thanks again!

[@sen6114]

hi Anders, I am using raw numbers instead of % of income and population. what do i do?!

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@nikosioannou6859]

my friend thank you for this great video. I only have one question: where did you get this data from, I mean the data where you based your calculations, the starting data of population and income. Is it for a specific country, which source did you use?

[@andersjensenorg]

Thank you, Nikos!! Great question, and no it was just random data :) Kind regards, Anders

[@nikosioannou6859]

@@andersjensenorg ok I see, thank you. I was wondering if you could help me with the following: I am doing a project for school and I have also used random data to calculate the Gino coefficient, and my teacher wants me to justify the validity of this data. Do you have any idea for how I could do that? Basically I have to show that my data is realistic and not abnormal. How could I show that my data is valid?

[@sheistyshiney]

thx for the great video. if possible could you provide citations or the source for the calculations?

[@andersjensenorg]

Hey shastock. Thank you. Yeah for sure, check this: towardsdatascience.com/clearly-explained-gini-coefficient-and-lorenz-curve-fe6f5dcdc07 Kind regards, Anders

[@sheistyshiney]

@@andersjensenorg thx for the anwser and the fastest replay ever :D

[@IndiaKatjivena]

How may I contact you? I need your help

[@claudiacampos20]

Thank you!

[@andersjensenorg]

Hey Claudia, you're very welcome :) Kind regards, Anders

[@aliankhan8429]

sir if i want to calculate gini coefficient of a country from 1990-2019 yearly then kindly if you could guide me about which variables data should i take.

[@andersjensenorg]

Hey Alian. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@Silvertestrun]

Ty

[@andersjensenorg]

YW 😊

[@zarccos]

Thanks for your video. May be can you help me. Could you explain the differences between this two formulas for gini calculation: www.paho.org/English/SHA/be_v22n1-Gini.htm and Brown formula: www.statsdirect.com/help/nonparametric_methods/gini_coefficient.htm) / transportgeography.org/contents/methods/gini- coefficient /. What kind of method could be better if you have a list of countries population and global income by country. Thanks in advance

[@andersjensenorg]

Hey Maurici. I honestly don't know. I made the videos when I studied economics, because my fellow students had problems with it. Now I moved into IT (with my Eco background) and I'm not touching statistic much. Sorry. Kind regards, Anders

[@zarccos]

@@andersjensenorg Thanks a lot Anders !

[@dinaralixie]

мы с соней ничего не поняли если что мы устали

[@andersjensenorg]

I dont understand? 🙂