Graph the Lorenz Curve in Excel

To graph the Lorenz Curve, we need to use the percentage of individuals, percentage of income, cumulative percentage of income, and cumulative percentage of individuals

Number Annual Total Cumulative Cumulative of Earnings Cumulative Percentage of % of Percentage Earnings Percentage of People (per person) Earnings Individuals Individuals of Income Income 60 3000 180000 180000 0.1 0.1 0.01154216 0.011542161 90 5000 450000 630000 0.15 0.25 0.0288554 0.040397563 90 7500 675000 1305000 0.15 0.4 0.0432831 0.083680667 60 8000 480000 1785000 0.1 0.5 0.0307791 0.114459763 60 21000 1260000 3045000 0.1 0.6 0.08079513 0.19254889 90 25000 2250000 5295000 0.15 0.75 0.14427701 0.339831901 90 50000 4500000 9795000 0.15 0.9 0.28855402 0.628085925 40 90000 3600000 13395000 0.0666667 0.9666667 0.23084322 0.858929144 20 110000 2200000 15595000 0.033333 1 0.14107086 1.0 Total 600 15595000 1