User:Timeshifter/Sandbox77

This page is a scratchpad for a country list.

"Median GDP per capita" column says 2014 PPP. But not sure what year the GDP numbers are actually for. Might be 2015 numbers converted to 2014 PPP. 2016 source page linked below does not say:
 * https://www.givingwhatwecan.org/post/2016/05/giving-and-global-inequality

See a related country list that used median wealth numbers compared to mean wealth numbers: See also: Commons: Category: Median wealth and Commons: Category: Median income
 * List of countries by wealth per adult

Help:
 * Help: Table. See section on Visual Editor.
 * Commons:Create charts and graphs online
 * Commons:Convert tables and charts to wiki code or image files

Survey years are in a column on the country list on the first page linked below: Median GDP per capita is from income and consumption surveys. More info on sourcing at the above link.
 * http://www.cgdev.org/blog/world-bank-poverty-statistics-lack-median-income-data-so-we-filled-gap-ourselves-download-available

More info:
 * https://docs.google.com/spreadsheets/d/1qaHWnAKmZ2g7FtnR48bFv-AoYBwDZP0vmDstllPaxwo/edit#gid=394951178
 * http://www.gallup.com/poll/166211/worldwide-median-household-income-000.aspx

(c) = consumption survey. (i) = income survey.

Table 2

 * See: Help:Table. See its section on Visual Editor.

The numbers in the table below end up matching the numbers in the previous table. So the table below verifies the above table.

The World Bank’s Poverty Statistics Lack Median Income Data, So We Filled In the Gap Ourselves — Download Available. Center For Global Development. From the article:
 * {| class=wikitable border=1


 * we did create a dataset of median income/consumption for all countries available using the recently updated 2011 PPPs. Our median data was obtained in its entirety from the World Bank’s PovcalNet database. We use the latest survey year available and list whether the median is based on consumption or income data. We also note — as PovcalNet does — whether the data is grouped (C or I) or whether it represents unit-record data (c or i).
 * }

Link below is from the above-linked article.
 * https://www.cgdev.org/sites/default/files/country-median-data-2011-PPP-Diofasi-Birdsall.xls

Open that file with LibreOffice Calc. The daily income numbers need to be multiplied by 365 days to get yearly median income. To do so first insert a blank column on the right side of the table.

Then select the top data cell in the new blank column (labeled G). Add =f2*365 to that cell. That represents multiplying the cell to the left (f2) by 365. Go to the next cell and add =f3*365. Then drag the button down to the bottom of the column. Then all the numbers in column G are yearly income numbers instead of daily income numbers (as in F).

The LibreOffice Calc spreadsheet was copied here below, and columns moved around or deleted.