Problem 1 Lorenz curves and Gini coefficients:

Use the excel file here: https://docs.google.com/spreadsheets/d/18M_RlalBfmTpAJHwia2C8annKxQrEV_tWKVMOjLkQSs/edit?usp=sharing

Problem 1: Lorenz curves and Gini coefficients Using the KwaZulu-Natal Income Dynamics Study (KIDS) survey, we will examine the evolution of inequality in South Africa between 1993 and 2004. (Use the data provided in the "SQ2020_PS2_template" Excel file under the worksheet titled "Q1_Lorenz and Gini_n" in the folder for Problem Set 2. DO NOT use the data from the Problem Set 1 since it is a different version. All the numbers are reported in real values of 2000. Thus, there is no need to use any CPI conversions.) (a) Plot the Lorenz curves for per-capita expenditures for 1993, 1998 and 2004 in Excel. Put the three Lorenz curves on a single graph. While there are multiples ways to generate the Lorenz curves, we would like you to divide your sample into ten deciles of per-capita expenditures (so that you have 1 1 points on the horizontal axis). Please fill out the following table first, which will help you plot the Lorenz curve for each year in Excel. Please insert final graph AS AN IMAGE (screenshot is allowed) under this question AND copy it into the worksheet titled "Figure 1A" in the Excel template. (Use two decimal spaces for display along the axes) Income Percent of Cumulative Cumulative Cumulative Cumulative Decile Population percent of Percent of Percent of Percent of Population Income 1993 Income 1998 Income 2004 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.1 0.2 MacBook Air\f\f\f\f