Lorenz Curve and Gini Index in Excel

What is Lorenz Curve?
In economics, the Lorenz curve is a graphical representation of the distribution of income or of wealth. It was developed by Max O. Lorenz in 1905 for representing the inequality of wealth distribution.
The curve is a graph showing the proportion of overall income or wealth assumed by the bottom x% of the people, although this is not rigorously true for a finite population (see below). It is often used to represent income distribution, showing the bottom x% of households and the percentage (y%) of the total income they have. The percentage of households is plotted on the x-axis, the percentage of income on the y-axis. It can also be used to show the distribution of assets. In such use, many economists consider it to be a measure of social inequality.
What is the Gini Coefficient?
Gini Coefficient, also known as the Gini index, is the statistical measure used to measure the distribution of the income among the country's population, i.e., it helps measure the income inequality of the country’s population. t is a value between 0 and 1. A higher number indicates a greater degree of income inequality. A value of 1 indicates the highest degree of income inequality where a single individual earns the country's entire income. A value of 0 indicates that all individuals have the same income. Thus, a value of 0 indicates perfect income equality. One of the limitations of the Gini index is that its use requires that no one has negative net wealth.
For further study:
**************************************************************************************************
Workshop Alert on An Integrated MCDM approach for Drought Vulnerability Assessment in ArcGIS
**************************************************************************************************
Enrollment link
*******************************************************************************************************
UDEMY Course
Rainfall Indices for MCDM models in ArcGIS: how and Why?
Preparation of 10 important rainfall indices for MCDM models and time series analysis using Excel, ArcGIS and QGIS
Click this link only Rs. 390 or 12.99 USD
*******************************************************************************************************
Advances in Geographical Research
Learn research methodology online with courses of Advanced Geospatial technologies, statistical methods, and Machine Learning algorithms.
*******************************************************************************************************

WhatsApp Group for subscribers:
Group 1
Group 2
***************************************************************************************
Playlist
1. Basics Remote sensing
2. MCDM and ML
3. Arc GIS
4. Free online data download
5. Advanced Excel

SUBSCRIBE to the YouTube channel Dr. Jayanta Das, to get notification about our recent lecture uploads on Advances in Geographical Research.

ALL RIGHTS RESERVED.

#DrJayantaDas

[yogeshmalhotra]

Thank you so much for explaining in a simple way and with example ❤

[biztuber]

If you can please tell me what formula you used while calculating parallelogram area under the curve?

[moyonga]

Thank you so much sir, you have saved my life.

[manishsharma]

A lot of thanks for this clarification

[sagarverma]

Thanks for this useful resource, but one thing is recommended to make this video more useful is, please also show and explain the formula which you have used while calculating the Gini index in excel. You are just saying click here and there, but not explaining why to click here and there.

[charlessayi]

Reminder:
the link of the paper is not seen here