https://docs.google.com/spreadsheets/d/1DV63E1AiQ6amKq0fywn30EKbgE0vsZdNv6r4201Im_c/edit#gid=0

(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 11 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)

(a)Use the covariance formula to calculate the Gini coefficient and report the Gini coefficients for 1993, 1998 and 2004 in the table below.[1] (Use two decimal spaces for display)

[1] See Chapter 5 of Taylor and Lybbert (page 121) for instructions on calculating the Gini coefficient in Excel.

Using the KwaZulu-Natal Income Dynamics Study (KIDS) survey, we will examine the evolution o inequality in South Africa between 1993 and 2004. (Use the data provided in th "SQ2020_PS2_template" Excel file under the worksheet titled "Q1_Lorenz and Gini_n" in th 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 thre Lorenz curves on a single graph. While there are multiples ways to generate the Lorenz curves, w would like you to divide your sample into ten deciles of per-capita expenditures (so that you have 1 points on the horizontal axis). Please fill out the following table first, which will help you plot th 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 10% 10% 0.2 10% 20% 0.3 10% 30% 0.4 10% 10% 0.5 10% 50% 0.6 10% 60% 0.7 10% 70% 0.8 10% 80% 0.9 10% 90% 1 10% 100% 100% 100% 100%