United Nations Population Division (UNPD): Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 481: Line 481:
In order use the Annualize functions in IFs, complete the following steps:
In order use the Annualize functions in IFs, complete the following steps:


#Format raw data in excel
1. Format raw data in excel
#Import Excel Data to an access file using IFs>Extended Features>Historical Data File Processing>Import Data


[[File:Annualize-screenshot-2.jpg|360x230px]]
2. Import Excel Data to an access file using IFs>Extended Features>Historical Data File Processing>Import Data


#Copy Series Table from access file Local Disk (C:)>Users>Public>IFs>DATA>IFsDataImport and paste in Local Disk (C:)>Users>Public>IFs>DATA>IFsHistSeries
[[File:Annualize-screenshot-2.jpg|360x230px|Annualize-screenshot-2.jpg]]
#Copy the corresponding row from the DataDict Table in access file “Local Disk (C:)>Users>Public>IFs>DATA>IFsDataImport” and paste in “Local Disk (C:)>Users>Public>IFs>DATA>DataDict”
#Annualize data in IFs: Extended Features>Manage Country Data>Historical Data File Processing>Annualize/Interpolate Data <u>OR</u> Annualize/Spread Data
##Select source name that matches the table you pasted in IFsHistSeries
##Use a unique name for the Output Data table so you can differentiate the annualized version


**note that the Source series must be included in both IFsHistSeries and DataDict tables, otherwise it will not show up as an option for annualizing
3. Copy Series Table from access file Local Disk (C:)>Users>Public>IFs>DATA>IFsDataImport and paste in Local Disk (C:)>Users>Public>IFs>DATA>IFsHistSeries


[[File:Annualize-screenshot-3.jpg|358x145px]]
4. Copy the corresponding row from the DataDict Table in access file “Local Disk (C:)>Users>Public>IFs>DATA>IFsDataImport” and paste in “Local Disk (C:)>Users>Public>IFs>DATA>DataDict”


#Compile all annualized tables in a new access file, include data dict table, and be sure series names match
5. Annualize data in IFs: Extended Features>Manage Country Data>Historical Data File Processing>Annualize/Interpolate Data <u>OR</u> Annualize/Spread Data
 
&nbsp; &nbsp; &nbsp;a. Select source name that matches the table you pasted in IFsHistSeries
 
&nbsp; &nbsp; &nbsp;b. Use a unique name for the Output Data table so you can differentiate the annualized version
 
*note that the Source series must be included in both IFsHistSeries and DataDict tables, otherwise it will not show up as an option for annualizing
 
[[File:Annualize-screenshot-3.jpg|358x145px|Annualize-screenshot-3.jpg]]
 
6. Compile all annualized tables in a new access file, include data dict table, and be sure series names match


==  ==
==  ==

Revision as of 17:27, 17 June 2020

About the UNPD

The Population Division was established in the earlier years of the United Nations to serve as the Secretariat of the then Population Commission, created in 1946. Over the years, the Division has played an active role in the intergovernmental dialogue on population and development, producing constantly updated demographic estimates and projections for all countries, including data essential for the monitoring of the progress in achieving the Millennium Development Goals, developing and disseminating new methodologies, leading the substantive preparations for the United Nations major conferences on population and development as well as the annual sessions of the Commission on Population and Development .

Series pulled from UNPD

Table Source
SeriesInfMortMedUNPD http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesLifExpectFemale http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesLifExpectMale http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesTFRMedUNPD http://esa.un.org/wpp/Excel-Data/fertility.htm
SeriesPopulation UNPD 2015 (DSR added Taiwan from WEO)
SeriesForecastandHistInfMortMedUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastandHistPopulationBothSexesConstUNPD2010Rev http://esa.un.org/wpp/Excel-Data/population.htm
SeriesForecastandHistPopulationBothSexesHighUNPD2010Rev http://esa.un.org/wpp/Excel-Data/population.htm
SeriesForecastandHistPopulationBothSexesLowUNPD2010Rev http://esa.un.org/wpp/Excel-Data/population.htm
SeriesForecastandHistPopulationBothSexesMedUNPD2010Rev http://esa.un.org/wpp/Excel-Data/population.htm
SeriesForecastCDR0MigrationUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastCDRConstFertUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastCDRConstMortalityUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastCDRHighUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastCDRlowUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastCDRMedUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastCDRNoChangeUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastCDRreplacementUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatio0MigrationUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioConstMortUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioNoChangeUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioOld0MigrationUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioOldConstFertUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioOldConstMortalityUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioOldHighUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioOldLowUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioOldMedUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioOldNoChangeUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioOldReplacementUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioYoungConstFertUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioYoungHighUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioYoungLowUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioYoungMedUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastDependencyRatioYoungReplacementUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastFertility0MigrationUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastFertility0MigrationUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastFertilityConstMortalityUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastFertilityConstMortalityUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastfertilityConstUNPD http://esa.un.org/wpp/Excel-Data/fertility.htm
SeriesForecastFertilityConstUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastFertilityConstUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastfertilityHighUNPD http://esa.un.org/wpp/Excel-Data/fertility.htm
SeriesForecastFertilityHighUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastFertilityHighUNPD2015ANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastfertilityLowUNPD http://esa.un.org/wpp/Excel-Data/fertility.htm
SeriesForecastFertilityLowUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastFertilityLowUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastfertilityMedUNPD http://esa.un.org/wpp/Excel-Data/fertility.htm
SeriesForecastFertilityMedUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastFertilityMedUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastFertilityNoChangeUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastFertilityNoChangeUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastFertilityReplacementUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastFertilityReplacementUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastInfantMortalityMedUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastLifeExpMedBothSexesUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastLifeExpMedBothSexesUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastLifeExpMedFemaleUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastLifeExpMedFemaleUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastLifeExpMedMaleUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastLifeExpMedMaleUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastLifExpectFemaleMedUNPD http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesForecastLifExpectFemaleUNPD2010Rev http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesForecastLifExpectMaleMedUNPD http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesForecastLifExpectMaleUNPD2010Rev http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesForecastLifExpectMedUNPD http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesForecastLifExpectUNPD2010Rev http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesForecastNetMigrantsUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastNetMigrationMedUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastNetMigrationRateMedUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastNetMigrationRateUNPD2015RevANN http://esa.un.org/unpd/wpp/DVD/
SeriesForecastPopBothSexes0MigrationUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopBothSexes0MigrationUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastPopBothSexesConstMortalityUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopBothSexesConstMortalityUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastPopBothSexesConstUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopBothSexesConstUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastPopBothSexesHighUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopBothSexesHighUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastPopBothSexesLowUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopBothSexesLowUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastPopBothSexesMedUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopBothSexesMedUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastPopBothSexesNoChangeUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopBothSexesNoChangeUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastPopBothSexesReplacementUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopBothSexesReplacementUNPD2015Rev http://esa.un.org/unpd/wpp/DVD/
SeriesForecastPopFemale0MigrationUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopFemaleConstMortalityUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopFemaleConstUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopFemaleHighUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopFemaleLowUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopFemaleMedUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopFemaleNoChangeUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopFemaleReplacementUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopMale0MigrationUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopMaleConstMortalityUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopMaleConstUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopMaleHighUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopMaleLowUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopMaleMedUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopMaleNoChangeUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopMaleReplacementUNPD2012Rev http://esa.un.org/unpd/wpp/Excel-Data/population.htm
SeriesForecastPopulationBothSexesConstUNPD2010Rev http://esa.un.org/wpp/Excel-Data/population.htm
SeriesForecastPopulationBothSexesHighUNPD2010Rev http://esa.un.org/wpp/Excel-Data/population.htm
SeriesForecastPopulationBothSexesLowUNPD2010Rev http://esa.un.org/wpp/Excel-Data/population.htm
SeriesForecastPopulationBothSexesMedUNPD2010Rev http://esa.un.org/wpp/Excel-Data/population.htm
SeriesForecastYouthDependencyRatio0MigrationUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastYouthDependencyRatioConstFertUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastYouthDependencyRatioConstMortalityUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastYouthDependencyRatioHighUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastYouthDependencyRatioLowUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastYouthDependencyRatioMedUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastYouthDependencyRatioNoChangeUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesForecastYouthDependencyRatioReplacementUNPD2015Rev UNPD WPP 2015 http://esa.un.org/unpd/wpp/DVD/
SeriesLifExpect http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesLifExpectFemaleMedUNPD http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesLifExpectMaleMedUNPD http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesLifExpectMedUNPD http://esa.un.org/wpp/Excel-Data/mortality.htm
SeriesPopulation15PlusMill UNPD
SeriesPopulation15to29Mill UNPD
SeriesPopulation15to64% UNPD
SeriesPopulation15to64Mill UNPD
SeriesPopulation65Plus UNPD
SeriesPopulation65Plus% UNPD
SeriesPopulation65PlusMill UNPD
SeriesPopulationElderlyDependence% UNPD
SeriesPopulationUnder15Mill UNPD
SeriesPopulationUnder5Mill UNPD
SeriesPopulationUNFilled UNPD 2010 Rev Filled with WDI and Ifs
SeriesPopYouthBulgeBy15 UNPD
SeriesPopYouthBulgeBy30 UNPD
SeriesPopYouthBulgeByTotal UNPD
SeriesPopYouthDependency% UNPD

Instructions on pulling UNPD data

Life expectancy and TFR data

Description of Data 

Life expectancy and fertility rate data are available for 5 year intervals (e.g. 1955-1960, 1960-1965) up to latest year (2015). Since the datasets are estimates, the data is available for five year intervals up to the year 2100. For the purpose of IFs ,a simple average needs to be computed in order to arrive at a value for every 5 year interval (e.g. Average for 1955-60 value and 1960-65 value will be recorded under the year 1960 for IFS). On the basis of these 5 year intervals, IFs computes the annual values for life expectancy and TFR using an interpolation function.  

Methodology used by UNPD

The life expectancy at birth is defined by UNPD as the number of years a newborn infant could expect to live if prevailing patterns of age-specific mortality rates at the time of birth stay the same throughout the infant’s life. The life expectancy data is computed by UNPD on the basis of the estimated levels of infant and child mortality and after taking into consideration special circumstances in respective nations. For example, the mortality impact of AIDS has been factored in when computing the life expectancy at birth of Rwanda.  

The UNPD model for computation of TFR  is  probablistic and makes use of historical demographic data .The 2015 revision in the methodology, also takes into account levels of development across countries and considers cases where fertility rates may stay constant or in some cases also rise in the future. For example, the fertility rate in sub-Saharan Africa has not fallen as fast as the rate in other regions in the world on account of high infant mortality from communicable diseases and low levels of human development. 

Life expectancy and TFR in IFs

Life expectancy is driven by income levels (GDP per capita at PPP) , government spending on health and education (GDS), civilian damage from wars, population and mortality. Life expectancy shares an especially strong relationship with income as evidenced by an r square value of  0.63. TFR in IFs is primarily driven by female education , GDP per capita at PPP, population levels. The chart below shows the relationship between GDP per capita and life expectancy across all nations in 2014.


Life expectancy compared to GDP per capita at PPP in 2014

RTENOTITLE  

Source: International Futures 7.22


Since the data in IFs is calculated on the basis of assigned averages between two time periods, it must be noted that data won’t be available for the period succeeding the latest year (e.g. for the 2015 update, latest data is available for the 2010-2015 period, but no data is available for 2015-2020 period, thus the average value cannot be calculated.) For the latest period, when computing the average value, the forecast value for the future period is used. (e.g. for 2015, compute the average using 2010-2015 value and the 2015-2020 forecasted value.) While using forecasts,  note that three varieties of forecast values are available from UNPD, one with a low variant, one with a medium variant and one with a high variant. The medium variant is used when computing the average, as this is likely to be the closest to the actual value.  

Data Source

https://esa.un.org/unpd/wpp/Download/Standard/Population/ 

Series to be updated in IFs

  1. Series LifExpect
  2. Series LifExpectFemale
  3. Series LifExpectMale
  4. SeriesTFRMedUNPD

Country list to be used

IFs country list



Last updated by : Kanishka Narayan 11th October 2016


Instructions on Annualizing WPP Population Data

Several of the WPP Population series are given in averages or sums every 5 years.

To provide values for the missing years, IFs has a built in “Annualize” feature under Extended Features>Manage Country Data>Historical Data File Processing.

There are two different functions:

  1. Annualize/Spread Period Data (Use this if the raw data values represent the sum of data for all years contained in the interval. The data will then be spread across the 5 years.)
  2. Annualize/Interpolate Interval Data (Use this if the raw data values represent the data for only one given year. In this case the missing years will be interpolated across the missing years.)

Annualize-screenshot-1.jpg

In order use the Annualize functions in IFs, complete the following steps:

1. Format raw data in excel

2. Import Excel Data to an access file using IFs>Extended Features>Historical Data File Processing>Import Data

Annualize-screenshot-2.jpg

3. Copy Series Table from access file Local Disk (C:)>Users>Public>IFs>DATA>IFsDataImport and paste in Local Disk (C:)>Users>Public>IFs>DATA>IFsHistSeries

4. Copy the corresponding row from the DataDict Table in access file “Local Disk (C:)>Users>Public>IFs>DATA>IFsDataImport” and paste in “Local Disk (C:)>Users>Public>IFs>DATA>DataDict”

5. Annualize data in IFs: Extended Features>Manage Country Data>Historical Data File Processing>Annualize/Interpolate Data OR Annualize/Spread Data

     a. Select source name that matches the table you pasted in IFsHistSeries

     b. Use a unique name for the Output Data table so you can differentiate the annualized version

  • note that the Source series must be included in both IFsHistSeries and DataDict tables, otherwise it will not show up as an option for annualizing

Annualize-screenshot-3.jpg

6. Compile all annualized tables in a new access file, include data dict table, and be sure series names match