A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Data: Income Mountains — v2 | Free data from www.gapminder.org | id | version | ||||||||||
2 | Updated: Maj 4, 2018 | CC BY 4.0 LICENCE | incm | v2 | ||||||||||
3 | Indicator: | Population by income | Are you seeing this offline? Please make sure you use the latest version. Here's the permalink: | |||||||||||
4 | Description: | The number of people in different income brackets ($/day in constant PPP$ 2011) | gapm.io/dataincm | |||||||||||
5 | Unit: | Number of people | ||||||||||||
6 | Version: | v2 | ||||||||||||
7 | Download: | Excel file » | ||||||||||||
8 | ||||||||||||||
9 | About this file | Example Charts | ||||||||||||
10 | This file contains the data for estimating the number of people on different income across the world during the past 200 years. The next couple of sheets have the data for world, regions and west and rest. The country data was too large to publish in this online spreadsheet, but it can be downloaded in this large excel file called: "Detailed Data - Income Mountains-by-Gapminder-v2-20180504" here: www.gapm.io/detailed_incm | These charts show data from the other sheets in this workbook. | ||||||||||||
11 | The income brackets are increasing on higher income, so that they can be plotted on logarithmic scale. On linear scale the shape looks like a L, as most people are sqeezed together on incomes below the average Swedish income, and a few richer individuals stretch out on higher incomes. The reasons we are not using linear scale is further explained here: www.gapm.io/why_log | |||||||||||||
12 | Data source summary | |||||||||||||
13 | Please see the documentation here: | |||||||||||||
14 | gapm.io/ddocincm | |||||||||||||
15 | This data is FAR FROM EXACT, and should only be used to give the big picture of global development. The mountains show number of people on different levels income, measured as mean household income (or consumption) per person per day, in dollars adjusted for inflation over time and price differences in year 2011 (PPP 2011). The global curve is constructed by stacking all countries bell-curves on top each other. Each country’s bell-curve is drawn using three numbers: 1. Mean income which determines where the curve is positioned on the x-axis; 2. Gini: Which determines the width of the curve, 3. Population: determining the height of the curve. The World Bank has data for Ginis and Income for countries for the year 2013 in their income database called PovcalNet, which they use for estimating the number of people below the extreme poverty line. In addition to the years when PovcalNet has data for these three input indicators, Gapminder has gathered data from a wide range of historic sources as documented for each of the three indicators in each of the latest versions of our datasets for: Gini v2, Household Income v1 and Population v5. | |||||||||||||
16 | ||||||||||||||
17 | Files and formulas for generating the shapes | |||||||||||||
18 | This data is very rough. It is only useful to give a big picture of the incomes of the world population. Even if it has detailed data for each country, those are based on very rough assumptions and shouldn't be used for numeric analysis. | |||||||||||||
19 | The data is generated by assuming a simple bell curve distribution of income in each country based on mean income, population size and gini coefficient. | |||||||||||||
20 | This gives us a rough way to estimate how many people in the world lived below a specific income in a given year, which is one of the inputs in Gapmidner's long historic trend for the global rate of extreme poverty: | |||||||||||||
21 | The next sheet has a data dictionary describing the content of columns in the other sheets where the actual data is. | |||||||||||||
22 | ||||||||||||||
23 | The method is described here: | |||||||||||||
24 | www.gapm.io/doc_incm | |||||||||||||
25 | ||||||||||||||
26 | The data was calculated using two other Excel files as described here: | |||||||||||||
27 | www.gapm.io/d_incm | |||||||||||||
28 | ||||||||||||||
29 | THE CURVES FOR CHINA, INDONESIA & INDIA, ARE BASED ON THREE DIFFERENT SHAPES EACH. | |||||||||||||
30 | These three countries are divided into three different populations, and all three must be included in order to generate the total mountain. | |||||||||||||
31 | The underlying data can be found in the file called: "Three countries split in rural urban - Income Mountains-by-Gapminder-v2-20180504" here: | |||||||||||||
32 | www.gapm.io/drive_incm | |||||||||||||
33 | ||||||||||||||
34 | Data Version | |||||||||||||
35 | Author of this version: Ola Rosling | |||||||||||||
36 | Permalink to this version: v2 | |||||||||||||
37 | gapm.io/d_incm_v2 | |||||||||||||
38 | For previous versions, see the list at the bottom of the documentation page: | |||||||||||||
39 | gapm.io/ddocincm | |||||||||||||
40 | ||||||||||||||
41 | Feedback | |||||||||||||
42 | If you find a problem or have a question: | |||||||||||||
43 | Please give feedback here | |||||||||||||
44 | ||||||||||||||
45 | Gapminder's Data License | |||||||||||||
46 | Creative Common License CC BY 4.0 | |||||||||||||
47 | We produce free data, and most (not all!) sheets here are provided under the open license. You can use, copy, and spread this data, as long as you mention the following: | |||||||||||||
48 | Free data from Gapminder.org: gapm.io/d_incm_v2 | |||||||||||||
49 | ||||||||||||||
50 | ||||||||||||||
51 | ||||||||||||||
52 | ||||||||||||||
53 | Technical stuff | |||||||||||||
54 | These spreadsheets are part of Gapminder's data production and publishing, but there' more to it. Please follow this link to get the bigger picture of our data processes. | |||||||||||||
55 | gapm.io/dataworks | |||||||||||||
56 | Formulas | The formulas in this workbook may be referring to other spreadsheets online, by their named ranges, and not by sheet names. If a spreadsheet is broken in the tree of formulas, we avoid other formulas to get broken, by always linking to the output data sheets, which are manually copied and pasted form the formula outputs in the sheets to the right of DATA_PREP sheet. | ||||||||||||
57 | Formulas | If you like to integrate Gapmidner's data into your product, it's better if you integrate | ||||||||||||
58 | Source id | GM_INCM_V2 | ||||||||||||
59 | Dataset id | incm | ||||||||||||
60 | This G doc id | 1939CzZ5HHoLreb0YyopaWfNjJ9mnN27IhywI6-TuwZs | ||||||||||||
61 | ||||||||||||||
62 | used sources | WITHOUT VERSION | ||||||||||||
63 | No sources | |||||||||||||
64 | ||||||||||||||
65 | ||||||||||||||
66 | ||||||||||||||
67 | ||||||||||||||
68 | ||||||||||||||
69 | ||||||||||||||
70 | ||||||||||||||
71 | ||||||||||||||
72 | ||||||||||||||
73 | ||||||||||||||
74 | WITH VERSION | |||||||||||||
75 | ||||||||||||||
76 | ||||||||||||||
77 | ||||||||||||||
78 | ||||||||||||||
79 | ||||||||||||||
80 | ||||||||||||||
81 | ||||||||||||||
82 | ||||||||||||||
83 | ||||||||||||||
84 | ||||||||||||||
85 | ||||||||||||||
86 | ||||||||||||||
87 | ||||||||||||||
88 | ||||||||||||||
89 | ||||||||||||||
90 | ||||||||||||||
91 | ||||||||||||||
92 | ||||||||||||||
93 | ||||||||||||||
94 | ||||||||||||||
95 | ||||||||||||||
96 | ||||||||||||||
97 | ||||||||||||||
98 | ||||||||||||||
99 | ||||||||||||||
100 |