Excel: Lorenz Curve and Gini Coefficient - Full Tutorial

Поделиться
HTML-код
  • Опубликовано: 25 янв 2025

Комментарии • 35

  • @diegocaicedo36
    @diegocaicedo36 3 года назад +7

    Great explanation, love the simplicity and clarity, thanks

    • @andersjensenorg
      @andersjensenorg  3 года назад

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

  • @gauravbansal6940
    @gauravbansal6940 9 месяцев назад +3

    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
      @andersjensenorg  9 месяцев назад

      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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders

  • @MarioGiordano96
    @MarioGiordano96 3 года назад +5

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

    • @andersjensenorg
      @andersjensenorg  3 года назад +1

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

  • @sen6114
    @sen6114 11 месяцев назад +1

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

    • @andersjensenorg
      @andersjensenorg  11 месяцев назад

      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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders

  • @bentsusdiary
    @bentsusdiary 3 года назад +1

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

    • @andersjensenorg
      @andersjensenorg  3 года назад

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

  • @nikosioannou6859
    @nikosioannou6859 3 года назад +3

    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
      @andersjensenorg  3 года назад +1

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

    • @nikosioannou6859
      @nikosioannou6859 3 года назад +1

      @@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
    @sheistyshiney 3 года назад +1

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

    • @andersjensenorg
      @andersjensenorg  3 года назад +1

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

    • @sheistyshiney
      @sheistyshiney 3 года назад

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

  • @Eridingle
    @Eridingle 4 года назад +1

    thank you so much!! this helped me immensely!

    • @andersjensenorg
      @andersjensenorg  4 года назад

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

  • @Caniballe
    @Caniballe 4 года назад +2

    Perfect! That´ll help a lot!

    • @andersjensenorg
      @andersjensenorg  4 года назад +1

      Thank you, Paulo 🙂👍

    • @Caniballe
      @Caniballe Месяц назад

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

  • @IndiaKatjivena
    @IndiaKatjivena 2 месяца назад

    How may I contact you? I need your help

  • @aliankhan8429
    @aliankhan8429 3 года назад

    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
      @andersjensenorg  3 года назад

      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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

  • @claudiacampos20
    @claudiacampos20 3 года назад +1

    Thank you!

    • @andersjensenorg
      @andersjensenorg  3 года назад

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

  • @Silvertestrun
    @Silvertestrun Год назад +2

    Ty

  • @zarccos
    @zarccos 4 года назад +1

    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
      @andersjensenorg  4 года назад

      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
      @zarccos 4 года назад +1

      @@andersjensenorg Thanks a lot Anders !

  • @dinaralixie
    @dinaralixie Год назад

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