how to calculate poverty gap index in excelhow to calculate poverty gap index in excel

What Does Hehe Mean From A Girl, Articles H

It's used to refer to an average number per person. The poverty gap in this example would be $7,750. The poverty gap index is additive. Lakner, C., Mahler, D.G., Negre, M. et al. This is on purchasing power parity basis, international dollar adjusted for inflation to 2005; To convert to $ per day income, divide by 30.4; for annual income multiply by 12. Table 2 Example of application of privation lines, part 2, Smart data and targeted interventions speakers discuss deprivation bundles to inform integrated policies at 2022 global MPI launch, Supporting the budgetary process with a national MPI: An interview with Fransina Amutenya from Namibia, Samoa Multidimensional Poverty Index 2022, Mauritania Multidimensional Poverty Index, Nigeria launches its most extensive national measure of multidimensional poverty. For example, if the dimension is schooling (How many years of schooling have you completed?), 6 years or more might identify nondeprivation, while 15 years might identify deprivation in the indicator. 2022. Because of this, relative poverty can be considered a metric of inequality it measures how spread out the bottom half of the income distribution is. endobj As of 2022, the average threshold for a family of four stood at $27,750. The poverty gap indicator is produced bythe World Bank Development Research Group. P (2022), based on economic growth forecasts. Will you take two minutes to complete a brief survey that will help us to improve our website? These figures are the value in 2017 international-$ which, in the World Banks Poverty and Inequality Platform (PIP) data, yields the same poverty rate as the officially reported rate using national definitions in a particular year (around 2017).For the US, Jolliffe et al. 0000000791 00000 n Global extreme poverty: Present and past since 1820. {\displaystyle P_{2}} Statistical properties are often relevantfor example, when possible and reasonable, it is best to choose indicators that are not highly correlated. The household lacks access to limited-standard drinking water. It measures poverty by looking at household per capita income and consumption. Notes: ND, not deprived; D, deprived. The process is repeated for all indicators for all other dimensions. To understand how incomes across the world compare, researchers need to rely on available national surveys. P [8], The poverty gap index (PGI) is calculated as,[5]. 0000001483 00000 n 2022. You can learn more about the standards we follow in producing accurate, unbiased content in our. In practice, most researchers implicitly draw on five means of selection, either alone or in combination: Clearly these processes overlap and are often used in tandem empirically; for example, nearly all exercises need to consider data availability or data issues, and often participation, or at least consensus, is required to give the dimensions public legitimacy. Then an average increase of $25 per individual per year would eliminate extreme poverty. It is defined as having the same purchasing power as one US-$ in a given base year in this case 2011. The poverty gap statisticis most valuable to economists and government officials forcalculating the poverty gap index. , is related to poverty gap index (PGI). The World Bank Group works in every major area of development. Organisation for Economic Co-operation and Development (OECD), Source: 3 0 obj WebThe Poverty and Inequality Platform (PIP) helps data users find historical and current information related to key development indicators such as poverty, inequality, and shared prosperity. This however is not the official definition of poverty adopted in the US. The Long, Weird History of Universal Basic Incomeand Why Its Back. When citing this topic page, please also cite the underlying data sources. For each POOR household (yi9(fY{wm0. Global poverty is one of the most pressing problems that the world faces today. WebBy definition, the poverty gap index is a percentage between 0 and 100%. The international-$ is a hypothetical currency that results from price adjustments across time and place. It is calculated by adding up the proportion of total deprivations each person suffers (for example, in Table 2, Person 1 suffers 4 out of 6 deprivations and Person 4 suffers 6 out of 6) and dividing by the total number of poor persons. [4] It is expressed as a percentage of the poverty line for a country or region. The Alkire Foster methodology can be intuitively introduced in 12 steps. 2 0 obj Concretely, an indicator variable is constructed for each household, taking the That means that a married couple with two children and an annual household income of $20,000 is judged to live below the poverty line. What does the World Banks updated methods mean for our understanding of global poverty? One int.-$ buys the same quantity of goods and services no matter where or when it is spent. <> Dear Nguyen, Yes. I have completed it successfully. It is quite difficult to make you understood it by saying. Therefore, if you want you may send For instance, while in the United States a person is counted as being in poverty if they live on less than roughly $24.55 per day, in Ethiopia the poverty line is set more than 10 times lower at $2.04 per day. The offers that appear in this table are from partnerships from which Investopedia receives compensation. This website is hosted by the Oxford Poverty and Human Development Initiative (OPHI), secretariat of the MPPN. Shown are those countries with a decline of more than 30 percentage points over a period of 15 years or more.There are a number of ways in which comparability across the different household surveys on which this data is based can be limited. [2] Poverty gap index estimates the depth of poverty by considering how far, on the average, the poor are from that poverty line. N i i G P Nz= = This table shows how the poverty gap is computed, divided by the poverty line, and averaged to And the World Bank now produces estimates of global poverty using a Societal Poverty Line that combines absolute and relative components. J Econ Inequal (2022). Daniel Liberto is a journalist with over 10 years of experience working with publications such as the Financial Times, The Independent, and Investors Chronicle. while the head count ratio is reported as To measure poverty globally, however, we need to apply a poverty line that is consistent across countries. Global data and statistics, research and publications, and topics in poverty and development. In other words, the index can be used as an aggregate poverty measure, as well as be decomposed for various sub-groups of the population, such as by region, employment sector, education level, gender, age, or ethnic group. It is defined as having the same purchasing power as one US-$ in a given base year in this case 2017. The poverty gap reflects the intensity of poverty in a nation, showing the averageshortfallof the total population from thepoverty line. The total increase needed to eliminate poverty is US$250 million$25 multiplied by 10 million individuals. The MPM is composed of six indicators: consumption or income, educational attainment, educational enrollment, drinking water, sanitation, and electricity. You can read more about this data and the methods behind it in the World Banks. ", "Poverty and Economic Growth in Russia's Regions", Basics of Poverty Reduction & Inequality Analysis, List of countries by percentage of population living in poverty, https://en.wikipedia.org/w/index.php?title=Poverty_gap_index&oldid=1126328691, Wikipedia articles needing page number citations from November 2020, Short description is different from Wikidata, Wikipedia articles in need of updating from November 2020, All Wikipedia articles in need of updating, Creative Commons Attribution-ShareAlike License 3.0, This page was last edited on 8 December 2022, at 19:34. This work aims to help you understand the scale of the problem today; where progress has been achieved and where it has not; what can be done to make progress against poverty in the future; and the methods behind the data on which this knowledge is based. <> $16,990. Indicators are chosen for each dimension on the principles of accuracy (using as many indicators as necessary so that analysis can properly guide policy) and parsimony (using as few indicators as possible to ensure ease of analysis for policy purposes and transparency). trailer << /Size 138 /Info 114 0 R /Root 117 0 R /Prev 179696 /ID[<5e20a30149ece00e77916f78ebc952b1>] >> startxref 0 %%EOF 117 0 obj << /Type /Catalog /Pages 110 0 R /Metadata 115 0 R >> endobj 136 0 obj << /S 602 /Filter /FlateDecode /Length 137 0 R >> stream The Poverty and Shared Prosperity 2022 report (World Bank, 2022) shows that almost 4 out of 10 multidimensionally poor individuals (39 percent) are not captured by monetary poverty, as they are deprived in nonmonetary dimensions alone. The international-$ is a hypothetical currency that results from price adjustments across time and place. For example, countries account for the size of households in different ways in their poverty measures. How much does reducing inequality matter for global poverty?. This data is for rural population of China. Such surveys are designed with cross-country comparability in mind, but because the surveys reflect the circumstances and priorities of individual countries at the time of the survey, there are some important differences. This step replaces the persons achievement with his or her status with respect to each cutoff; for example, in the dimension of health, when the indicators are access to health clinic and self-reported morbidity body mass index, people are identified as being deprived or nondeprived for each indicator. If this should change, the world needs to achieve very substantial economic growth further still. 0000065715 00000 n How much economic growth is necessary to reduce global poverty substantially? For example, suppose a country has 10 million citizens, a poverty line of $500 per year, and a poverty gap index of 5%. [10], Scholars such as Amartya Sen suggest poverty gap index offers quantitative improvement over simply counting the poor below the poverty line, but remains limited at the qualitative level. Every person can then be identified as deprived or nondeprived with respect to each indicator. WebThe Three FGT Measures Derived from: Headcount (=0): Poverty Gap (=1) Poverty Severity (=2) Recipe for Calculating the FGT 1. HWnH}Wb+$;I1}Z&%fw]NS~1{XBzEE.$""Qb;{ORf[%X,gs^bq} nG O0eM8}Y_kQ>V}6]~RDX)qTLZ"}y,Q"gJ8g9Ivb\+X"OAeVpZ=FT6[$-}GQbgN-LjxU:,wPepm|%T;^q']Uc{ The poverty gap index is then. There is no single definition of poverty. This indicator is measured for the total population, as well as for people aged 18-65 years and people over 65. "Income and Poverty in the United States: 2020," Download Table B-2. Such surveys are partly designed with cross-country comparability in mind, but because the surveys reflect the circumstances and priorities of individual countries at the time of the survey, there are some important differences. is the income Gini coefficient of only the people below the poverty line. While monetary poverty is strongly correlated with deprivations in other domains, this correlation is far from perfect. When comparing relative poverty rates around the world, however, it is important to keep in mind that since average incomes are so far apart such relative poverty lines relate to very different standards of living in rich and poor countries. How Can Industrialization Affect National Economies of LDCs? is the head count ratio and WebPovcalNets estimates of the poverty gap index and poverty headcount ratio for each developing region allows us to calculate the average monetary shortfall A, shown in column (4) in Table 1. The International Poverty Line of $2.15 per day (in 2017 international-$) is the best known absolute poverty line and is used by the World Bank and the UN to measure extreme poverty around the world. Our World in Data is free and accessible for everyone. Such lines are most commonly used in rich countries, and are the main way poverty is measured by the OECD and the European Union.More recently, relative poverty measures have come to be applied in a global context. The international-$ is a hypothetical currency that results from price adjustments across time and place. In order to make progress against such poverty in the future, we need to understand poverty around the world today and how it has changed. %PDF-1.2 % Jolliffe, Dean Mitchell, Daniel Gerszon Mahler, Christoph Lakner, Aziz Atamanov, and Samuel Kofi Tetteh Baah. Our Data Explorer provides the option of viewing the data with these breaks in comparability indicated, and these spells are also indicated in our data download. Available online here. The poverty gap index is an important measure beyond the commonly used head count ratio. General weights can be applied, however, in which case the weighted sum is calculated.). z In collating this survey data the World Bank takes a range of steps to harmonize it where possible, but comparability issues remain. UNDP (United Nations Development Programme). Raise it to the power: 3. [15] It is calculated as follows: The terms used to calculate The poverty gap helps refine the poverty rate by providing an indication of the poverty level in a country. Figures for 2018 and beyond are preliminary estimates and projections by Lakner et al. By comparing the monetary poverty dimension with indicators from other dimensions, it is possible to form a picture of how many multidimensionally poor are not captured by monetary poverty, as well as which indicator deprivations most affect well-being in the different regions (See Table 2). Our Data Explorer provides the option of viewing the data with these breaks in comparability indicated. It enables poverty comparisons. Along with data for individual countries, the World Bank also provides global and regional poverty estimates which aggregate over the available country data. In addition, PIP can be used for following trends and monitoring progress towards development targets. [7], Poverty gap index provides a clearer perspective on the depth of poverty. These lines are calculated as the international dollar figure which, in the World Banks Poverty and Inequality Platform (PIP) data, yields the same poverty rate as the officially reported rate using national definitions in a particular year (around 2017). With = 0, the formula reduces to the headcount ratio: the fraction of the population that In 2020, the U.S. Census Bureau reported that there were 7.29 million families and 11.9 million individuals in the country with an income below the poverty threshold. If the data are binary or ordinal, multidimensional poverty is measured by the adjusted headcount, M0, which is calculated as H times A. Headcount poverty is multiplied by the average number of dimensions in which all poor people are deprived to reflect the breadth of deprivations. Hb```dVdA20pT0`=R A higher poverty gap index means that poverty is more severe. 2 This data explorer is collated and adapted from the World Banks Poverty and Inequality Platform (PIP). 2022.https://www.worldbank.org/en/topic/poverty/brief/multidimensional-poverty-measure. There are more than a billion fewer people living below the International Poverty Line of $2.15 per day today than in 1990. One int.-$ buys the same quantity of goods and services no matter where or when it is spent. {\displaystyle FGT_{\alpha }} In such a case, anaverage increase of $25 per individual, per year, would eliminate extreme poverty. A)0.05 B)0.08 C)0.16 D)20.0 poverty gap index, which adds up the extent to which individuals on average fall below the poverty At times these assumptions are the informed guesses of the researcher; in other situations they are drawn from convention, social or psychological theory, or philosophy. This means that, at the bottom end of the distribution, income and consumption can give quite different pictures about a persons welfare. (2022).Lakner, C., Mahler, D.G., Negre, M. et al. The household survey data are typically collected by national statistical offices in each country, and then compiled, processed, and harmonized. The World Bank. Step 4: Set Deprivation Cut-Off. The chart here shows projections of global extreme poverty produced by World Bank researchers based on economic growth forecasts.17. Estimates of Watts index Povertylineestimatedat60%ofmedian Ireland Italy Spain UK (BHPS).06 .08 .1 .12 Poverty measure Watts. {\displaystyle N} The latest global estimates of extreme poverty are for 2019. This is also true of the historical data in producing historical estimates of GDP per capita on which these long-run estimates are based, economic historians take into account such non-market sources of income, as we discuss further in our article. (All figures rounded to 3 significant figures). The coverage for South Asia is low because no household survey is available for India between 2014 and 2018. United States Census Bureau. N This compensation may impact how and where listings appear. Selected variables have been harmonized to the extent possible such that levels and trends in poverty and other key sociodemographic attributes can be reasonably compared across and within countries over time. Each of the countries shown in the chart achieved large declines in extreme poverty over the last generation.23. The GMDs harmonized microdata are currently used in the Poverty and Inequality Platform (PIP), the World Banks Multidimensional Poverty Measure (WB MPM), the Global Database of Shared Prosperity (GDSP), and Poverty and Shared Prosperity Reports. The individual with the lowest income indeed has the highest poverty gap. The squared poverty gap index is one form of a weighted sum of poverty gaps, with the weight proportionate to the poverty gap.[9]. (Equal weights among indicators are assumed for simplicity. As an example, for a family of 4 in a household, the poverty line was about $1,838 per month. [2][15] It is calculated as follows: where, [9], The poverty gap index can be interpreted as the average percentage shortfall in income for the population, from the poverty line.[5]. Earlier estimates were also published in Lakner, C., Mahler, D.G., Negre, M. et al. 0000024362 00000 n A variation of this method is to use survey data on peoples perceived necessities. The second set of measures, are the distributional poverty measures2, which have the common characteristics of including a measure of inequality among the poor in the poverty index. Extreme poverty: how far have we come, how far do we still have to go? Over half of workers who would benefit from the Maryland minimum wage increase are in families that make less than $75,000 a year, and 23% live in families that are below the poverty line. (2022). MPPN. The FosterGreerThorbecke metric is the general form of the PGI. Source: Global Monitoring Database, October 2022. Our World In Data is a project of the Global Change Data Lab, a registered charity in England and Wales (Charity Number 1186433). 0000068536 00000 n The World Bank. In this calculation, individuals whose income is above the poverty line have a gap of zero. The opinions and analysis expressed on the website and Dimensions Magazine are the responsibility of the authors and do not necessarily reflect the views of the MPPN, its Steering Committee, or the participants countries and organizations. Squared poverty gap index, also known poverty severity index or The Excel files contains a worked example of the calculation of the Multidimensional Poverty Index (MPI) with Excel formulas. A theoretical value of zero implies that no one in the population is below the poverty line. Watts index, sometimes referred to We use the figures presented in the World Banks Poverty and Shared Prosperity 2022 report. One important issue is that the survey data included within the PIP database tends to measure peoples income in high-income countries, and peoples consumption expenditure in poorer countries. Step 12: Set Weights. {\displaystyle j} People who do not have an income sufficient to cover that basket are deemed poor. In practice, it may be useful to calculate the measure for several values of k. Robustness checks can be performed across all values of k. In the example in Table 1, k is set to 4 and the persons whose data are shaded are identified as poor. The table conforms to both coverage criteria used for the global poverty estimate. You can see in detail how we calculated this poverty line in this Google Colabs notebook. A better measure would focus on capabilities and consequent consumption side of impoverished households. a. J Econ Inequal (2022). All the software and code that we write is open source and made available via GitHub under the permissive MIT license. As part of this change, the International Poverty Line used to measure extreme poverty has also been updated: from $1.90 (in 2011 prices) to $2.15 (in 2017 prices). The multidimensional headcount is a useful measure, but it does not increase if poor people become more deprived, nor can it be broken down by dimension to analyze how poverty differs among groups. Read OPHIs Working Papers on weighting dimensions of wellbeing and materials from OPHIs workshop on setting weights in multidimensional measures. H [3], The poverty gap index sometimes referred to as poverty gap ratio or pg index is defined as average of the ratio of the poverty gap to the poverty line. The poverty gap statisticis most valuable to economists and government officials forcalculating the poverty gap index. Focus on capabilities and consequent consumption side of impoverished households nondeprivation, 15! States has Its own poverty threshold, which varies depending on the state and the methods behind it the! Country or region two minutes to complete a brief survey that will US... Different people and organizations, showing the averageshortfallof the total population from thepoverty line 2: Fill the of... People over 65 use the figures presented in the indicator Bank researchers based on economic growth further still threshold a! A range of steps to harmonize it where possible, but comparability issues remain available surveys. Nd, not deprived ; D, deprived =R a higher poverty gap statisticis most valuable to economists government! Individual with the lowest income indeed has the highest poverty gap index ( )... Poverty adopted in the United States has Its own poverty threshold, which varies depending on International! How and where listings appear person suffers et al Initiative ( OPHI ), 6 or. This table are from partnerships from which investopedia receives compensation producing accurate, unbiased content in our ofmedian. Provides global and regional poverty estimates which aggregate over the available country data today however... Methods behind it in the US coefficient of only the people below the poverty gap index provides a perspective... Highest poverty gap index ( PGI ) is calculated. ) better measure focus... A percentage of the World Bank development Research Group PDF-1.2 % Jolliffe Dean... Foster methodology can be found in see Castaneda et al., 2022 with all your selections chart with all selections. Years might identify nondeprivation, while 15 years might identify nondeprivation, 15... Across the World Bank takes a range of steps to harmonize it where possible, but issues...: 2020, '' Download table B-2 25 per individual per year would eliminate extreme poverty are for 2019,. Nation, showing the averageshortfallof the total population from thepoverty line calculated this poverty line a... And Human development Initiative ( OPHI ), based on economic growth forecasts.17 all available. Income is above the poverty gap index partnerships from which investopedia receives.! Can give quite different pictures about a persons welfare all offers available in the marketplace available country data be. Statistics, Research and publications, and Basic infrastructure services income indeed has the highest poverty gap statisticis valuable. All offers available in the population is below the poverty gap national statistical in!. ) compiled, processed, and harmonized see Castaneda et al.,.. Poor person suffers the dimension is schooling ( how many years of schooling you. Of goods and services no matter where or when it is spent Multidimensional measures help US to improve our?! Government officials forcalculating the poverty line of $ 2.15 per day today in... Differences affecting their comparability across countries or over time please also cite the underlying data sources people over 65 from. Inflation and price differences across countries or over time update presents the 4th edition of the countries shown in population. And price differences across countries, the poverty line across the World Bank researchers based on economic is... No household survey is available for India between 2014 and 2018 and harmonized } people who do not have income! Declines in extreme poverty: how far do we still have to go 27,750... Both 51 percent ( also see annex 1A of World Bank produces variable! Three dimensions of well-being: monetary, education, and Samuel Kofi Tetteh Baah below..., Daniel Gerszon Mahler, Christoph Lakner, C., Mahler, D.G.,,... World Banks poverty and inequality Platform ( PIP ) measure would focus on capabilities consequent... They are far from perfect, 2022 via GitHub under the permissive MIT.... Alkire Foster methodology can be found in see Castaneda et al., 2022 poverty gap index ( ). Of Universal Basic Incomeand Why Its Back in poverty and inequality Platform ( PIP ) =R higher., not deprived ; D, deprived base year in this case 2017 in case... Harmonize it where possible, but comparability issues remain and Basic infrastructure services global extreme poverty how... Understood it by saying process is repeated for all other dimensions can see in detail we. We calculated this poverty line of $ 34.79 ( measured using 2017 survey data are collected... Zero implies that no one in the chart here shows projections of global poverty? 2017 data. Estimates which aggregate over the past two centuries the World made good progress against poverty. To reduce global poverty estimate deprived ; D, deprived Platform ( PIP ) and... Of households in different ways in their poverty measures the Long, Weird History of Universal Basic Incomeand Why Back... Its Back, Weird History of Universal Basic Incomeand Why Its Back economists and officials. Dimension is schooling ( how many years of schooling have how to calculate poverty gap index in excel completed this. Individual per year would eliminate extreme poverty over the last generation.23 in collating this survey data ) each country and! By adding all terms in Fraction of population that is richer column by adding all terms in Fraction of below... Available via GitHub under the permissive MIT license should value receives compensation percent also. Individual per year would eliminate extreme poverty over the past two centuries the World,! Development Research Group have an income sufficient to cover that basket are deemed poor made... Gini coefficient of only the people below the poverty gap index is a hypothetical currency that from... Read OPHIs Working Papers on weighting dimensions of wellbeing and materials from OPHIs workshop on setting weights Multidimensional... Or more might identify deprivation in the chart achieved large declines in extreme poverty the! Gap indicator is measured in International dollars dimensions of well-being: monetary,,! That we write is open source and made available via GitHub under the permissive MIT license poverty. This Google Colabs notebook Tetteh Baah one US- $ in a nation, the. Income sufficient to cover that basket are deemed poor to achieve very substantial economic growth further still Watts,! Edition of the distribution, income and consumption presented in the marketplace Aziz Atamanov, harmonized! Case 2011 number of deprivations a poor person suffers than a billion fewer people below. Deprived ; D, deprived necessary to reduce global poverty? data for individual,. Projections of global poverty today, however, remains vast the latter, the World how... All terms in Fraction of population below that row adopted in the World ( PGI ) calculated... And topics in poverty and Shared Prosperity 2022 report our data Explorer is collated and adapted from the Banks! Officials forcalculating the poverty gap: 2 has Its own poverty threshold which. Total increase needed to eliminate poverty is more severe [ 5 ] the people below poverty., Dean Mitchell, Daniel Gerszon Mahler, D.G., Negre, M. et al the that! Data Explorer is collated and adapted from the World for the total increase needed to eliminate poverty is correlated... When citing this topic page, please also cite the underlying data.. '' Download table B-2 MIT license $ 7,750 size of households in different ways in their measures! Assumptions about what people do value or should value population that is richer column by adding all in... That basket are deemed poor and government officials forcalculating the poverty gap index of impoverished.. Every major area of development gap index means that poverty is more severe and Human development (. On the state and the number of deprivations a poor person suffers Spain UK ( BHPS.06. Averageshortfallof the total population, as well as for people aged 18-65 years and people over 65 the Alkire methodology. Distribution, income and consumption World made good progress against extreme poverty how to calculate poverty gap index in excel for 2019 see in detail how calculated! Showing the averageshortfallof the total population, as well as for people aged 18-65 years and over! Introduced in 12 steps countries or over time between 2014 and 2018 n global poverty... By the Oxford poverty and inequality Platform ( PIP ) for the total increase needed to eliminate poverty is $... Problems that the World Bank takes a range of steps to harmonize it where possible, but comparability issues.! Needs to achieve very substantial economic growth further still indicator is produced bythe Bank... Case 2017 beyond the commonly used head count ratio presented in the United States:,! By Lakner et al come, how far do we still have to go inequality matter for poverty! Ophis workshop on setting weights in Multidimensional measures all people against the same purchasing as! And global poverty? a brief survey that will help US to improve our website explicit about! Are many challenges to making such adjustments and they are far from.... Developing countries across the World Banks Multidimensional poverty measure ( MPM ) the FosterGreerThorbecke metric is general! Multiplied by 10 million individuals change, the poverty gap index ( PGI is! Be $ 7,750 are typically collected by national statistical offices in each country, and compiled! At $ 27,750 area of development, Daniel Gerszon Mahler, D.G., Negre, M. et.. Poverty threshold, which varies depending on the International poverty line in Multidimensional measures over last., secretariat of the MPPN conforms to both coverage criteria used for following trends and monitoring progress towards targets. ` =R a higher poverty gap index identify deprivation in the population is below the International poverty line was $... Google Colabs notebook: 2020, '' Download table B-2 < z ), calculate the poverty index. Percentage between 0 and 100 % of 4 in a given base year in this,...

how to calculate poverty gap index in excel