Answer the following?
Look over the Nicaragua Data and answer the following question
Nicaragua Data.xls: https://docs.google.com/spreadsheets/d/1GXa9bXNrXVc6lgaF3RDCkQaj0xVxXlxyVapX0UVmWlA/edit?usp=sharing
Part III. Data Analysis: Land Reform, Poverty and Inequality. Nicaragua has a very unequal distribution of agricultural land, with a small number of large farmers owning a large fraction of the land. The government is considering implementing a Land Reform Policy in order to reduce poverty and inequality. In this question you will use your expertise to evaluate how successful the Land Reform Policy will be. The Excel file "Nicaragua Data.xIs" contains farm size data for 588 households in Nicaragua. Assume that these households represent all farmers in Nicaragua. The variables are: HHID: Household Identification Number . LAND: Farm area owned by the household (in acres) 9. The Land Reform Policy The government proposes the following Land Reform Policy: . Take away 20% of the land owned by farmers who own more than OR EQUAL TO 20 acres. This is like a land "tax". For example, a farmer who owns 40 acres would have 8 acres (8 = 20% of 40) taken away and would be left with 32 acres. Transfer the land taken away from large farmers to small farmers in the following way. Give all farmers who own less than 10 acres enough land to bring them up to exactly 10 acres. For example, a farmer who owns 6 acres would be given 4 additional acres so that she ends up with 10 acres. What is the total amount of land taken away from large farmers under the Land Reform Policy (Acres)? 10. Impact of the Land Reform on Inequality of Land Holdings: Lorenz Curves Fill out Table 2, which you will use in the next problem to graph Lorenz Curves for the distribution of LAND. Table 2: Template for Lorenz curve for Land Distribution (Report all numbers as a percentage and use two decimal points. E.g., 12.25%) Income Percent of Cumulative Cumulative Cumulative Quartile Population percent of Percent of LAND Percent of LAND Population BEFORE Policy AFTER Policy 0 0 0 25% 0.00% 0.00% 0.00% 2 25% 0.00% 0.00% 0.00% 3 25% 0.00% 0.00% 0.00% 25% 0.00% 0.00% 0.00% A quartile is just like a decile, but instead of dividing up the population into 10 equal sized groups, it divides it up into 4 equal sized groups - each one accounting for 25% of the population. Since there are 588 households in the sample, there are 147 households in each quartile