ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
QuantityValueNotesColor Code
2
Growth due to internet accessEmpirical Measurement
3
GDP/capita 2000635
https://data.worldbank.org/indicator/NY.GDP.PCAP.CD?locations=ZG
Calculated Number
4
GDP/capita 20201501Est. from Literature
5
Increase in GDP/capita866My estimate - can be changed
6
% increase1.363779528OP number
7
% growth per year0.0439515618Calculated number from another BOTEC
8
9
% Internet penetration 20000.0005
https://data.worldbank.org/indicator/IT.NET.USER.ZS?locations=ZG
10
% Internet penetration 20200.2897
11
% increase0.2892
12
13
IMF est. of GDP/capita growth per percentage increase internet use
0.10.4
https://www.imf.org/en/News/Articles/2020/06/15/na061520-digitalizing-sub-saharan-africa-hopes-and-hurdles
14
Increase in GDP/capita from internet0.028920.11568
15
% of growth from internet0.021205773670.08482309469
16
17
Increase per year0.3
Taking 3% yearly growth due to internet access
18
Compound initial GDP/capita over 10 years654.3092432
19
Percentage that had internet for ~10 years0.1451
I'm assuming internet increased linearly. This isn't true, obviously, but it made compounding avg. growth over 20 years easier - I compounded growth for half the end population over 10 years.
20
Increase due to internet94.94027119
Percentage with internet * amount they gained due to internet - that is, the average person gained this amount if the average person had 28% of the average gains from internet
21
% of overall increase from internet0.1096307981
22
23
Growth due to cell coverage
24
% cell coverage in 19990.1
https://sites.tufts.edu/jennyaker/files/2010/09/aker_mobileafrica.pdf
25
% cell coverage in 20200.884
https://www.itu.int/en/ITU-D/Statistics/Documents/facts/FactsFigures2020.pdf
26
Delta cell coverage0.784
27
Percent income increase w/ cell coverage0.17
28
Avg. income increase from increase in cell coverage0.13328
29
Fraction of observed GDP increase0.09772840647
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
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