Hello, can you answer the questions and compute the data as well as plotting the Lorenz curves for the per-capita income for 1993 and 2004 in Excel data shown below. Thank you!

2. Income Inequality: Lorenz Curve Plot the Lorenz curves for per-capita income for 1993 and 2004 in Excel. Put the two 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 income (so that you have 10 points on the horizontal axis). Replicating and lling out Table 2 in Excel may help you plot the Lorenz curve for each year. Please paste your nal graph into the box bellow titled \" Figure 1: Lorenz Curves for 1993 & 2004.\" (Report all numbers as a percentage and use two decimal points. E. g., I 2.25 % ) 1 In the year 2000, the market exchange rate was approximately 7 Rand/$US, while the PPP exchange rate was a bit under 3 Rand/$PPP. Table 2: Template or Lorenz curve Cumulative Cumulative Cumulative percent of Percent of Percent of Population Income I 993 Income 2004 Income Percent of Decile Population