Part (a) Calculate and draw in excel the following measures of inequality based on the dataset provided. The dataset depicts percentage of land owned by each decile of the population in a hypothetical country. Households deciles (bottom to top) Scenario 1 Scenario 3 Land holding Scenario 2 Land holding Land holding for each decile in % for each decile in % for each decile in % 0 0 0 0 10 1.5 2.3 1.1 10 3.3 3.5 2.5 10 4.1 4.5 2.8 10 5.1 5.6 3.8 10 6.2 6.8 4.6 10 7.2 10.4 6.2 10 8.6 12.4 10.5 10 15 15.5 11.5 10 21.5 18.5 25 10 27.5 20.5 32 (i) What is the Kuznets ratio in each of these scenarios? (ii) Draw the Lorenz curve in excel for each of these scenarios and report that in your answer sheet. What do these curves convey? (iii) Now calculate the gini coefficient of land inequality for all the above three scenarios and show your calculations in your answer sheet. (iv) What do you think about inequality based on the gini coefficients calculated? What kind of remedial measures would you suggest rectifying inequality in such instances