ABCDEFGHIJKLMN
1
Data: Income Mountains — v2
Free data from www.gapminder.orgidversion
2
Updated: Maj 4, 2018
CC BY 4.0 LICENCEincmv2
3
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
8
9
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
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
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
44
45
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
FormulasThe 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
FormulasIf you like to integrate Gapmidner's data into your product, it's better if you integrate
58
Source idGM_INCM_V2
59
Dataset idincm
60
This G doc id1939CzZ5HHoLreb0YyopaWfNjJ9mnN27IhywI6-TuwZs
61
62
used sourcesWITHOUT 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