Excel Data Analysis and Interactive Exercise

User Generated

Obbxvfg

Business Finance

Description

Download "Population Historical" data from the government website.

  • Select the data for each continent and their populations and group together at the top of the spreadsheet. Use only population data from the last 10 years.
  • Create an Area Chart in Excel with this data having all continents as data series, and the Years as X-Axis. (1 hour for a, b, c).

Create narratives based on the Excel Area Chartto discuss the following in a minimum of 1,400 words:

  • Interpret the historical trend in increase/decrease of population per continent.
  • Formulate a prediction on how the population would vary in the next decade. How did you arrive at this conclusion?
  • Investigate how Excel creates a forecast. Explain the steps involved.
  • Convert your area chart into a line chart in Excel, and add forecasted values. Include a screenshot in your paper.
  • Compare the forecasted output that Excel has provided with the conclusions you have arrived at in regards to the trend in the increase/decrease of population.
  • Recommend other Excel data analysis properties or chart types that could be used to demonstrate your data findings.

Format assignment consistent with APA guidelines.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Find the attached document

1
Running Head: HISTORIC POPULATION

Historic Population
Student’s Name

Institutional Affiliation

2
HISTORIC POPULATION

Interpreting the historical trend in increase/decrease of population per continent

Trends

Population size clearly increases and decreases at differing rates in differing continents.
However, Growth in population is the long-standing trend on all continents from Latin America
to Africa etc.; same case applies to individual states. Over the past decade, the global population
saw its greatest increase in known history, rising from about 1.6 billion in 1900 to over 6 billion.

This type of increase in population can be associated with a number of factors, such as low
mortality rates in many countries in the different continents, this is a s a result of things like by
improved medical advances and sanitation and as well as massive food production that is
associated with green technology. In early 2000, The UN estimated that world's population to
having an annual growth rate of 1.14%= 75 million persons. This was down from a peak in the
past decade (1980s) of peak of 88 million. By early 2000, the world had approximately 10 ten
times as many people as there had been in 1700 (Randers, 20120). In all continents, the
population growth rate has been steadily declining from its peak of 2.19% in 1970s, However
population growth remains high in; Sub Saharan Africa, Latin America, the Middle East.

There has been a decline in population growth in some continents like Europe mainly because of
low fertility rates. In years 2010 for example countries like Japan and many others in Europe
began encountering negative population growth as a result of sub replacement fertility rates.

3
HISTORIC POPULATION

United Nations In the year 2006 stated that the rate of population growth was visibly diminishing
due to an ongoing global demographic transition.In the event that the trend is encouraged that it
is possible that the rate of growth may diminish to zero by 2050.

In conclusion the slowdown to the near-global decline in fertility rates which is measured against
the average number of children born to a woman over her lifetime including continents such as
Asia and even in Africa, where the rates remain the highest. The fall is however being offset by
high numbers of children are born countries or where populations are already large. From the
data in the excel file, we can clearly see that , nine countries will account for half the world’s
population growth between now and the next few decades These countries include; Nigeria,
Pakistan, India, Tanzania, Ethiopia, Democratic Republic of Congo, The US, Uganda and even
Indonesia.

A prediction on how the population would vary in the next decade. How did you arrive at
this conclusion?

We can use an alternative scenario is given by the statistician Jorgen Randers. Randers argues
that traditional projections insufficiently take into account the downward impact of global
urbanization on fertility. Randers' "most likely scenario" reveals a peak in the world population
in the early 2040s at about 8.1 billion people, followed by decline.

Secondly, using the exponential smoothing model in our excel file , we can observe that in the
next decade there will be rapid population growth in a number of continents like Asia and Africa
and mild growth rate in Europe and Latin America in the next decade.

4
HISTORIC POPULATION

From above two perspectives we can conclude that; despite the fact that there is a continued
slowdown in the rate of population growth, the world cannot run away from the fact that it is
number of people in the globe will rise from the current 7.3 billion today to 8.7 billion in the next
decade

10 years ago, the world population was growing by 1.24% annually; today, the percentage has
dropped to 1.18% which is roughly 83 million people a year. This has meant that the overall
growth rate, peaked in the late 1960s, has all along been falling steadily since the 1970s.

There is a probability of almost 80% that the population of the world will be between 8.4 and 8.6
billion in 2030, between 9.4 and 10 billion in 2050 and between 10 and 12.5 billion in 2100 if we
go per the forecasts.

In the next five decades or so as per the forecast,, six countries that include, India, China,
Indonesia, Pakistan, Nigeria and the US, we expect a population of approximately above 300
million persons .
Africa alone is expected to drive more than half of the world’s population growth over the next
30 years. It can be forecasted that during this period the population of 28 of the continent’s
countries is expected to double. We can clearly observe from the forecast that countries like
Nigeria in the next four to five decades the population will easily surpass that of the US
(Randers, 2012). What this means is that the West African nation will most likely be world’s
third most populous country in the world.

In the event that the current birth rates trends persist, the n clearly a continent such as Africa,
which from an economic point of view contains 27 of the world’s 48 least developed countries,

5
HISTORIC POPULATION

will be the only continent that will be still experiencing substantial population growth in the next
five decades or so. Consequently, its share of the global population is forecast to rise to 25% in
2050 and 39% by 2100. Asia on the other hand will see its population growth fall to 54% in the
next five decades to about 44% in the next 8-10 decades.

Converting area charts into a line chart in Excel, and add forecasted values.

How Excel creates a forecast. The steps involved.

Exponential smoothing is an effective forecasting method similar to the weighted moving
average forecasting technique.

6
HISTORIC POPULATION

Forecast for the next period is equal to forecast for this period plus a fraction of the difference
between actual demand and forecast in this period.
F t+1 = F t +α(A t -F t )

Forecast for this period and the actual demand for this period are used to solve for the forecasting
of the next period. Alternatively one can rearrange the exponential smoothing formula is by
multiplying alpha by actual demand (At) and alpha minus 1 by Ft. Thus numerically, the
exponential formula is:
F t +1 = (1-α) F t + αA

Steps in excel
1First, let's take a look at our time series.
2On the Data tab, click Data Analysis
3. Select Exponential Smoothing and click OK.

4Click in the Input Range box and select the range B2:M2.

5. Click in the Damping factor box and type 0.9. Literature often talks about the smoothing
constant α (alpha). The value (1- α) is called the damping factor.

6. Click in the Output Range box and select cell B3.

7. Click OK.

8 Plot a graph of these values.

7
HISTORIC POPULATION

Excel data analysis properties or chart types that could be used to demonstrate your data
findings.
One can use the following other charts to try and demonstrate the data findings;
Pie charts
Pie Charts are known for displaying only one series of data. Excel uses the series identifier as
the chart title (e.g. population) and displays the values for that series as proportional slices of a
pie.
Column Charts
They effectively show the comparison of one or more series of data points. But the Clustered
Column Chart is especially useful in comparing multiple data series.
In a Column Chart, the vertical axis (Y-axis) always displays numeric values, and the horizontal
axis (X-axis) displays time or other category.
Excel has designed the chart in this manner because the number of time segments (4) is greater
than the number of series (3). Whichever has the highest quantity will be placed on the
horizontal axis (X-axis).
Line Charts

The Line Chart is especially effective in displaying trends. In a Line Chart, the vertical axis (Yaxis) always displays numeric values and the horizontal axis (X-axis) displays time or other
category.

8
HISTORIC POPULATION

We selected the Line with Markers chart for our single series chart at left. You may choose each
Line Chart type with or without markers. Markers are circles, squares, triangles, or other shapes
which mark the data points. Excel displays a unique marker - different shape and/or color - for
each data series.

Scatter Diagrams.
The purpose of a Scatter Chart is to observe how the values of two series compare over time or
other category. According to the Illinois scatter, Scatter plots are similar to line graphs in that
they use horizontal and vertical axes to plot data points (Haub, 2011). However, they have a very
specific purpose. Scatter plots show how much one variable is affected by another. The
relationship between two variables is called their correlation." The series pair has a Positive
Correlation if they increase similarly and a Negative Correlation if they both decrease in like
manner. Otherwise, they have No Correlation.

References
Randers, Jorgen (2012). 2052: A Global Forecast for the Next Forty Years. Vermont: Chelsea
Green Publishing. p. 62.
Haub, Carl (October 2011). "How Many People Have Ever Lived on Earth?". Population
Reference Bureau. Retrieved April 29, 2013
World Population to 2300" (PDF). New York: United Nations Department of Economic and
Social Affairs: Population Division. 2004: 3, 14.

9
HISTORIC POPULATION

Find the attached documents

Area Chart === nb some areas overlap.

4.500.000.000
4.000.000.000
North America

3.500.000.000

South America

3.000.000.000

Europe
2.500.000.000
Historical Population and Growth Rates in Population for Baseline Countries/Regions 1969-2014
Latin America
2.000.000.000
Former Soviet Union
1.500.000.000
Asia and Oceania
Updated: July 2015
based on latest Census Bureau data in the International Data Base
1.000.000.000
Middle east
500.000.000
Source: U.S. Census Bureau, International Data Base (http://www.census.gov/ipc/www/idb/)
Africa
0
organized into ERS/USDA Baseline
countries and regions
Contact: Dr. Kari Heerman (202-694-5250, keheerman@ers.usda.gov)

Below you can find the corresponding line chart to clearly see

Values in red are from the Census Bureau.

8.000.000.000
Population and Annual Growth Rates (right side of table)

1969

7.000.000.000

1970

1971

6.000.000.000
World
World Less US
North America

Canada
United States
Latin America
Mexico
Caribbean and Central America

Antigua and Barbuda
Bahamas
Barbados
Belize
Costa Rica
Cuba
Dominica
Dominican Republic
El Salvador
Grenada
Guatemala
Haiti
Honduras
Jamaica and Dependencies

3.613.400.327
3.412.015.327
222.833.073
21.448.073
201.385.000
276.931.152
51.110.928
40.227.487
64.475
164.012
239.321
119.183
1.687.100
8.421.048
68.689
4.298.133
3.469.177
94.867
5.151.182
4.447.122
2.685.322
1.919.615

3.688.286.119
3.765.252.925
5.000.000.000
3.484.302.119
3.558.425.925
4.000.000.000
225.733.986
228.853.400
3.000.000.000
21.749.986
22.026.400
203.984.000
206.827.000
2.000.000.000
284.162.430
291.350.844
1.000.000.000 54.406.901
52.775.158
41.072.801
0 41.937.617
65.624
66.354
170.323
174.220
238.756
240.606
122.070
124.890
1.735.523
1.785.636
8.542.746
8.669.625
69.785
70.822
4.422.755
4.546.974
3.603.907
3.710.335
95.410
96.034
5.264.207
5.384.580
4.540.576
4.584.844
2.760.666
2.855.882
1.943.787
1.967.012

Nicaragua
Panama
Puerto Rico
St Kitts and Nevis
St Lucia
St Vincent and the Grenadines
Trinidad and Tobago
South America
Argentina

Brazil
Other South America

Bolivia
Chile
Colombia
Ecuador
Guyana
Paraguay
Peru
Suriname
Uruguay
Venezuela
Europe
European Union (28)
European Union 15

Austria
Belgium-Luxembourg
Belgium
Luxembourg
Denmark
Finland
France
Germany
Greece
Ireland
Italy
Netherlands
Portugal
Spain
Sweden
United Kingdom
EU New 13 (A13)

Bulgaria
Croatia
Cyprus
Czech Republic

Estonia
Hungary

1.987.988
1.488.794
2.722.232
47.223
100.839
88.238
962.927
185.592.737
23.600.026
92.416.817
69.575.894
4.240.872
9.199.122
20.869.140
5.765.935
701.552
2.412.181
12.829.100
367.553
2.801.859
10.388.580
463.235.585
438.456.597
339.546.195
7.441.055
9.950.200
9.612.700
337.500
4.890.687
4.623.785
51.505.679
77.143.888
8.772.764
2.925.600
53.317.000
12.883.235
9.097.200
33.566.084
7.968.018
55.461.000
98.910.402
8.434.172
4.200.551
621.502
9.806.577
1.342.891
10.302.814

2.052.544
1.531.038
2.721.754
46.116
102.704
87.510
955.000
190.314.471
23.962.313
94.930.053
71.422.105
4.346.218
9.368.558
21.429.658
5.939.246
714.811
2.476.785
13.192.800
372.353
2.823.659
10.758.017
466.410.575
441.379.781
341.759.507
7.467.086
9.976.974
9.637.800
339.174
4.928.757
4.606.307
51.954.891
77.783.164
8.792.806
2.950.100
53.661.100
13.042.840
9.044.200
33.876.479
8.042.803
55.632.000
99.620.274
8.489.574
4.205.389
627.455
9.795.226
1.363.183
10.337.004

2.120.111
1.573.694
2.766.299
45.775
104.904
87.415
961.605
195.006.326
24.363.816
97.350.239
73.292.271
4.454.684
9.532.079
21.992.579
6.116.773
728.990
2.544.518
13.568.300
376.613
2.826.042
11.151.693
469.780.398
444.455.732
344.124.611
7.500.482
10.014.900
9.672.500
342.400
4.963.126
4.612.124
52.469.295
78.354.709
8.831.036
2.978.300
54.005.500
13.204.305
8.990.450
34.195.056
8.098.328
55.907.000
100.331.121
8.536.395
4.215.869
633.419
9.824.749
1.381.459
10.364.869

Latvia
Lithuania
Malta and Gozo
Poland

Romania
Slovakia
Slovenia
Other Europe
Other Western Europe

Iceland
Norway
Switzerland
Other Central Europe

Albania
Bosnia Herzegovina
Macedonia
Serbia
Former Soviet Union
Russia
Ukraine
Other Former Soviet

Armenia
Azerbaijan
Belarus
Georgia
Kazakhstan
Kyrgyzstan
Moldova
Tajikistan
Turkmenistan
Uzbekistan
Asia and Oceania
Asia
Asia less Japan
East Asia
East Asia less Japan

China
Hong Kong
Japan
South Korea
Taiwan
Other East Asia

Macau
Mongolia
Southeast Asia
Burma (Myanmar)
Cambodia (Kampuchea Khmer)

2.341.871
3.101.819
322.749
32.280.848
20.010.178
4.477.625
1.666.805
24.778.988
10.265.897
202.920
3.850.977
6.212.000
14.513.091
2.100.263
3.669.000
1.553.615
7.190.213
233.466.117
129.572.617
46.871.405
57.022.095
2.463.153
5.059.334
8.946.091
4.650.335
12.900.122
2.895.676
3.549.420
2.850.066
2.116.408
11.591.490
1.965.613.510
1.947.157.257
1.843.985.426
954.554.823
851.382.992
800.224.259
3.863.900
103.171.831
31.544.000
14.282.297
1.468.536
254.436
1.214.100
283.551.573
26.873.709
7.327.872

2.361.159
3.137.562
325.569
32.526.000
20.252.541
4.523.873
1.675.739
25.030.794
10.348.490
204.104
3.877.386
6.267.000
14.682.304
2.156.612
3.703.000
1.574.407
7.248.285
235.616.209
130.245.476
47.235.697
58.135.036
2.519.745
5.168.973
9.027.198
4.694.491
13.106.377
2.963.792
3.594.517
2.938.516
2.181.272
11.940.155
2.013.581.169
1.994.713.134
1.890.368.161
978.768.164
874.423.191
822.115.906
3.959.000
104.344.973
32.241.000
14.598.316
1.508.969
261.369
1.247.600
289.956.203
27.392.973
7.394.265

2.381.641
3.177.533
325.468
32.777.810
20.469.658
4.556.627
1.685.624
25.324.666
10.452.424
206.092
3.903.039
6.343.293
14.872.242
2.208.719
3.761.000
1.596.091
7.306.432
237.945.903
130.977.408
47.637.239
59.331.256
2.581.671
5.283.659
9.101.396
4.741.628
13.324.719
3.029.219
3.648.754
3.039.443
2.246.710
12.334.057
2.062.278.133
2.042.996.154
1.937.299.368
1.003.392.913
897.696.127
844.302.366
4.045.300
105.696.786
32.883.000
14.918.496
1.546.965
263.565
1.283.400
296.429.385
27.926.302
7.387.709

Indonesia
Malaysia
Philippines
Thailand
Vietnam
Other Southeast Asia

Brunei
Laos
Singapore
South Asia
Bangladesh
India
Pakistan
Other South Asia

Afghanistan
Bhutan
Nepal
Sri Lanka
Oceania
Australia
New Zealand
Other Oceania

Fiji
Maldives Islands
Micronesia, Federated States of
Papua New Guinea
Samoa
Solomon Islands
Tonga
Vanuatu New Hebrides
Other Asia/Oceania

Middle East
Iran
Iraq
Saudi Arabia
Turkey
Other Middle East

Bahrain
Israel
Jordan
Kuwait
Lebanon
Oman
Syria
United Arab Emirates
West Bank and Gaza
Yemen United

119.886.474
10.662.303
36.258.449
36.049.959
41.542.068
4.950.739
121.434
2.786.805
2.042.500
709.050.861
65.416.782
541.459.323
65.705.964
36.468.792
12.122.740
297.570
11.692.022
12.356.460
18.456.253
12.379.384
2.788.500
3.288.369
506.000
110.810
55.101
2.154.447
139.206
158.000
81.900
82.905
46.176.436
100.686.541
28.175.355
9.105.567
5.938.534
34.952.315
22.514.770
213.596
2.808.906
1.464.964
690.445
2.320.495
760.002
6.053.891
217.858
1.006.458
6.978.155

122.291.795
10.910.216
37.252.495
37.090.871
42.576.676
5.046.912
127.554
2.844.851
2.074.507
725.988.767
67.331.349
553.888.763
67.491.369
37.277.286
12.430.623
309.265
11.918.678
12.618.720
18.868.035
12.660.160
2.828.050
3.379.825
521.000
114.572
56.822
2.213.600
142.331
163.000
83.100
85.400
47.212.992
103.450.553
28.994.042
9.413.671
6.109.051
35.758.382
23.175.407
219.543
2.894.599
1.515.394
747.502
2.383.029
783.221
6.252.064
249.369
1.032.447
7.098.239

124.739.487
11.146.389
38.259.668
38.201.901
43.614.366
5.153.563
136.621
2.904.042
2.112.900
743.173.856
69.149.652
566.603.525
69.325.921
38.094.758
12.749.385
321.288
12.154.668
12.869.417
19.281.979
12.937.200
2.875.300
3.469.479
533.000
118.880
58.597
2.272.746
145.356
168.500
84.300
88.100
48.264.765
106.329.932
29.828.937
9.732.199
6.287.454
36.579.964
23.901.378
225.375
2.987.344
1.569.749
793.314
2.447.943
807.666
6.470.607
288.136
1.059.861
7.251.383

Africa
North Africa
Egypt
Morocco

350.634.349
68.930.972
32.966.239
15.517.155
Other North Africa
20.447.578
Algeria
13.528.304
Libya
1.922.974
Tunisia
4.996.300
Sub-Saharan Africa
281.703.377
Republic of South Africa
22.157.355
West African Community
101.303.975
Benin
2.553.162
Burkina Faso (Upper Volta)
5.242.904
Cape Verde Islands
261.602
Cote D'Ivoire
5.299.106
Gambia
469.095
Ghana
9.009.048
Guinea
3.573.863
Guinea Bissau
615.749
Liberia
1.355.941
Mali
5.424.728
Niger
4.735.173
Nigeria
53.994.532
Senegal
4.192.724
Sierra Leone
2.745.967
Togo
1.830.381
Other Sub Sahara
158.242.047
Angola
5.471.641
Botswana
571.874
Burundi
3.460.144
Cameroon
6.590.041
Central African Republic
1.794.675
Chad
3.649.335
Comoros Islands
230.087
Congo, Democratic Republic (Kinshasha)
21.178.812
Congo, Republic of (Brazzaville)
1.240.372
Djibouti
171.981
Equatorial Guinea
266.898
Eritrea
2.007.110
Ethiopia
28.962.280
Gabon
503.763
Kenya
10.887.934
Lesotho
1.043.044
Madagascar
6.615.873
Malawi
4.392.979
Mauritania
1.269.000
Mauritius
816.027

359.331.197
70.512.936
33.574.026
15.909.275
21.029.635
13.931.846
1.999.162
5.098.627
288.818.261
22.739.921
103.753.164
2.619.809
5.303.777
268.867
5.579.014
484.580
8.788.945
3.643.361
620.020
1.396.565
5.546.065
4.840.501
55.590.335
4.317.891
2.789.306
1.964.128
162.325.176
5.605.626
583.999
3.521.913
6.726.733
1.839.245
3.727.238
236.983
21.780.955
1.272.408
179.903
270.435
2.160.460
29.468.504
514.579
11.247.182
1.067.136
6.765.644
4.508.062
1.289.420
829.511

368.714.315
72.107.707
34.183.988
16.313.391
21.610.328
14.335.388
2.077.381
5.197.559
296.606.608
23.338.080
106.709.133
2.689.271
5.366.018
273.418
5.873.709
500.576
9.065.245
3.714.679
623.282
1.438.780
5.671.505
4.948.667
57.239.131
4.450.142
2.833.646
2.021.064
166.559.395
5.777.488
599.647
3.596.811
6.870.244
1.883.905
3.806.002
244.143
22.385.560
1.305.794
188.232
273.999
2.208.336
30.099.662
525.930
11.633.030
1.091.675
6.920.494
4.630.328
1.310.672
841.079

Mozambique
Namibia
Rwanda
Sao Tome and Principe
Seychelles
Sudan
Swaziland
Tanzania
Uganda
Zambia
Zimbabwe

9.092.797
744.618
3.656.796
72.722
52.508
10.740.137
443.277
13.389.543
9.449.977
4.123.000
5.352.802

9.304.375
764.683
3.769.171
73.631
54.106
11.030.727
455.145
13.806.869
9.715.336
4.240.661
5.514.536

9.539.059
792.629
3.880.225
74.860
55.615
11.329.180
467.416
14.236.867
9.952.470
4.353.856
5.684.187

World
3.613.400.327
Developed
690.984.880
Developed less US
489.599.880
Developing
2.576.470.088
Graduated Developed
57.682.283
High Income Oil Exporters
7.941.869
Developing less Graduated and Oil Exporters
2.510.845.936
Former Centrally Planned
345.945.359
Emerging Markets
1973118980

3.688.286.119
697.675.166
493.691.166
2.641.645.190
58.920.868
8.236.240
2.574.488.082
348.965.763
2019541893

3.765.252.925
704.939.721
498.112.721
2.708.122.825
60.151.124
8.538.566
2.639.433.135
352.190.379
2066572780

Population growth Per Continent
Year
North America
2005
2206
2007
2008
2009
2010
2011
2012
2013
2014

ons 1969-2014

r Soviet Union

South America

Europe

Latin America

328.379.378
331.474.679
334.631.961
337.755.696
340.727.208
343.567.742
346.202.589
348.799.083
351.407.211
354.007.841

368.583.943
373.051.507
377.405.259
381.687.990
385.895.762
390.020.413
394.079.226
398.088.519
402.043.564
405.938.368

527.231.265
529.130.288
531.342.430
533.605.132
535.319.534
536.706.839
538.114.328
539.540.740
540.969.644
542.385.243

551.912.527
558.635.365
565.305.743
571.991.667
578.674.261
585.066.434
591.589.460
598.021.012
604.324.457
610.522.143

1974

1975

1976

1977

Middle east
3.989.552.203
4.061.330.637
Asia and Oceania
3.776.210.203
3.845.865.637
Former
Soviet
Union
236.216.700
238.674.200
Latin
America
22.874.700
23.209.200
213.342.000
215.465.000
Europe
312.887.631
320.258.073
South America
59.122.839
60.678.045
North
America
44.425.895
45.394.130
67.836
68.041
185.499
189.139
245.563
247.147
133.027
135.611
1.937.413
1.991.580
9.152.866
9.290.074
73.480
73.923
4.921.761
5.048.499
3.973.004
4.072.847
96.340
95.819
5.772.854
5.910.462
4.873.993
4.973.063
2.765.159
2.857.705
2.071.146
2.104.879

4.131.782.807
3.914.219.807
241.080.500
23.517.500
217.563.000
327.653.520
62.219.964
46.420.168
68.361
193.257
248.023
138.135
2.048.557
9.420.906
74.204
5.175.585
4.176.875
95.555
6.051.261
5.076.517
2.954.566
2.133.388

4.203.014.663
3.983.254.663
243.556.400
23.796.400
219.760.000
335.174.628
63.759.976
47.422.691
68.637
197.499
249.169
140.578
2.108.457
9.537.988
74.323
5.302.800
4.285.219
94.280
6.196.604
5.182.817
3.055.680
2.156.814

corresponding line chart to clearly see this.

1972

1973

3.840.872.427
3.631.588.427
231.568.500
22.284.500
209.284.000
298.638.371
55.984.294
42.927.692
67.016
178.332
242.445
127.661
1.834.796
8.831.348
71.860
4.671.329
3.791.291
96.618
5.509.594
4.679.298
2.965.146
1.997.616

3.915.766.223
3.704.409.223
233.916.500
22.559.500
211.357.000
305.947.278
57.557.303
43.885.382
67.532
181.985
244.127
130.375
1.886.035
9.001.355
72.792
4.796.148
3.878.991
96.857
5.639.011
4.776.144
3.077.805
2.036.377

Africa

2.182.919
1.616.898
2.847.132
45.524
106.953
88.717
975.199
199.726.385
24.779.799
99.800.740
75.145.846
4.565.872
9.700.788
22.542.890
6.298.651
742.869
2.614.104
13.954.700
380.797
2.829.526
11.515.649
472.786.599
447.205.145
346.185.190
7.544.201
10.055.700
9.709.100
346.600
4.991.596
4.639.657
52.933.025
78.717.088
8.888.628
3.024.400
54.365.564
13.340.427
8.970.450
34.513.161
8.122.293
56.079.000
101.019.955
8.576.200
4.225.310
640.724
9.862.158
1.397.391
10.394.091

2.247.502
1.659.952
2.863.420
45.269
109.025
89.894
984.786
204.504.593
25.209.829
102.281.260
77.013.504
4.679.923
9.871.079
23.069.231
6.485.013
755.324
2.692.466
14.350.300
383.018
2.834.115
11.893.035
475.624.941
449.835.291
348.093.593
7.586.115
10.088.850
9.738.400
350.450
5.021.861
4.666.081
53.372.894
78.950.220
8.929.086
3.073.200
54.796.843
13.449.003
8.975.950
34.836.716
8.136.774
56.210.000
101.741.698
8.620.997
4.234.664
649.171
9.912.080
1.410.836
10.425.984

2.319.604
1.707.421
2.886.600
44.984
110.985
90.996
995.364
209.338.897
25.646.371
104.790.608
78.901.918
4.796.240
10.041.865
23.598.134
6.675.986
765.282
2.772.292
14.753.100
380.244
2.838.213
12.280.562
478.240.933
452.245.959
349.685.871
7.599.038
10.122.850
9.767.800
355.050
5.045.297
4.690.574
53.731.000
78.966.137
8.962.023
3.124.200
55.226.259
13.551.346
9.098.300
35.184.287
8.160.560
56.224.000
102.560.088
8.678.745
4.245.822
656.814
9.975.770
1.422.291
10.471.272

2.394.739
1.749.172
2.935.124
44.706
112.424
92.245
1.006.931
214.185.898
26.081.880
107.327.250
80.776.768
4.914.316
10.207.459
24.124.651
6.871.698
767.977
2.848.211
15.161.199
362.730
2.843.540
12.674.987
480.520.572
454.395.605
351.026.571
7.578.903
10.153.750
9.794.800
358.950
5.059.861
4.711.439
53.997.789
78.682.325
9.046.542
3.177.300
55.571.894
13.664.577
9.411.090
35.563.535
8.192.566
56.215.000
103.369.034
8.720.742
4.255.000
626.503
10.042.019
1.432.246
10.531.820

2.472.954
1.791.550
3.026.125
44.534
114.896
93.439
1.021.480
219.013.388
26.531.280
109.890.962
82.591.146
4.955.744
10.378.405
24.637.685
7.072.687
763.718
2.914.396
15.573.199
352.377
2.860.918
13.082.017
482.525.637
456.289.511
352.099.384
7.565.525
10.171.750
9.811.000
360.750
5.072.596
4.725.664
54.203.213
78.298.957
9.167.190
3.227.800
55.838.536
13.781.093
9.621.970
35.996.780
8.222.310
56.206.000
104.190.127
8.755.037
4.286.311
614.927
10.105.143
1.442.204
10.588.729

2.554.286
1.841.830
3.080.828
44.380
116.916
94.577
1.039.009
223.991.961
26.983.828
112.528.142
84.479.991
5.079.716
10.536.035
25.119.134
7.278.866
758.334
2.975.427
15.990.099
360.069
2.878.748
13.503.563
484.620.456
458.222.618
353.199.846
7.568.430
10.183.250
9.821.800
361.450
5.088.419
4.738.902
54.424.006
78.160.773
9.308.479
3.271.900
56.059.245
13.864.194
9.662.600
36.439.000
8.251.648
56.179.000
105.022.772
8.797.022
4.318.673
615.358
10.161.915
1.453.168
10.637.171

2.401.244
3.213.271
319.430
33.039.545
20.662.648
4.593.433
1.694.510
25.581.454
10.543.679
209.275
3.933.004
6.401.400
15.037.775
2.263.554
3.819.000
1.617.701
7.337.520
240.331.386
131.768.681
48.026.627
60.536.078
2.647.035
5.393.681
9.169.156
4.786.475
13.541.694
3.094.945
3.703.001
3.145.141
2.313.102
12.741.848
2.109.948.514
2.090.285.727
1.983.097.454
1.027.038.681
919.850.408
865.421.967
4.115.700
107.188.273
33.505.000
15.226.039
1.581.702
261.202
1.320.500
303.020.913
28.474.102
7.452.154

2.421.355
3.245.551
321.838
33.331.131
20.827.525
4.637.193
1.703.373
25.789.650
10.614.077
212.364
3.960.613
6.441.100
15.175.573
2.295.691
3.872.000
1.639.236
7.368.646
242.634.638
132.556.176
48.367.002
61.711.460
2.712.997
5.497.774
9.236.465
4.825.850
13.754.298
3.161.160
3.752.827
3.242.778
2.379.578
13.147.733
2.156.897.533
2.136.885.488
2.028.178.691
1.049.276.949
940.570.152
885.139.935
4.212.600
108.706.797
34.073.000
15.525.588
1.619.029
258.929
1.360.100
309.907.095
29.226.657
7.535.755

2.442.473
3.276.362
323.524
33.642.890
21.028.841
4.682.100
1.713.184
25.994.974
10.660.582
215.324
3.985.258
6.460.000
15.334.392
2.347.924
3.925.000
1.661.657
7.399.811
244.969.513
133.378.674
48.676.939
62.913.900
2.776.539
5.599.407
9.304.311
4.865.233
13.971.543
3.231.885
3.800.643
3.344.985
2.450.654
13.568.700
2.203.002.907
2.182.625.425
2.072.463.123
1.070.233.638
960.071.336
903.576.380
4.319.600
110.162.302
34.692.000
15.824.103
1.659.253
256.653
1.402.600
316.747.832
29.770.683
7.610.543

2.461.606
3.305.195
327.842
33.969.240
21.245.103
4.729.718
1.722.000
26.124.967
10.628.844
218.031
4.007.313
6.403.500
15.496.123
2.401.108
3.980.000
1.684.000
7.431.015
247.319.642
134.293.372
48.973.428
64.052.842
2.834.136
5.696.117
9.360.184
4.897.656
14.157.075
3.300.684
3.846.519
3.448.869
2.523.906
13.987.696
2.246.545.088
2.225.844.245
2.114.271.129
1.089.366.383
977.793.267
920.294.348
4.395.800
111.573.116
35.281.000
16.122.188
1.699.931
254.331
1.445.600
323.506.997
30.329.791
7.499.931

2.476.760
3.333.542
329.354
34.299.428
21.445.698
4.778.540
1.734.454
26.236.126
10.579.598
220.133
4.026.152
6.333.313
15.656.528
2.454.824
4.033.000
1.706.445
7.462.259
249.630.223
135.269.263
49.233.524
65.127.436
2.892.704
5.789.818
9.405.544
4.930.036
14.304.436
3.366.925
3.885.894
3.553.782
2.594.288
14.404.009
2.288.146.769
2.267.176.595
2.154.401.754
1.106.462.201
993.687.360
935.120.379
4.518.000
112.774.841
35.860.000
16.450.056
1.738.925
251.775
1.487.150
330.283.049
30.904.511
7.229.762

2.491.407
3.361.419
332.066
34.621.254
21.658.597
4.827.803
1.746.919
26.397.838
10.581.452
221.823
4.043.205
6.316.424
15.816.386
2.509.048
4.086.000
1.727.797
7.493.541
251.919.091
136.263.686
49.453.675
66.201.730
2.954.907
5.886.578
9.457.385
4.963.464
14.454.828
3.432.218
3.920.281
3.659.375
2.663.744
14.808.950
2.329.499.810
2.308.259.517
2.194.387.044
1.122.215.535
1.008.343.062
948.761.050
4.583.700
113.872.473
36.436.000
16.785.196
1.777.116
249.116
1.528.000
337.290.688
31.494.391
6.994.224

127.234.652
11.390.426
39.280.109
39.276.153
44.655.014
5.258.303
141.500
2.964.403
2.152.400
760.226.133
70.676.996
579.509.428
71.121.085
38.918.624
13.079.460
333.634
12.389.131
13.116.399
19.662.787
13.177.000
2.929.100
3.556.687
544.000
122.681
60.427
2.330.190
148.489
174.500
85.600
90.800
49.315.316
109.370.380
30.685.055
10.061.506
6.472.756
37.492.953
24.658.110
230.800
3.085.531
1.628.242
841.934
2.513.207
834.540
6.690.884
336.325
1.089.572
7.407.075

129.795.268
11.633.590
40.312.086
40.302.225
45.736.496
5.365.018
145.170
3.026.848
2.193.000
777.701.444
72.382.694
592.654.058
72.911.780
39.752.912
13.421.301
346.304
12.633.645
13.351.662
20.012.045
13.380.400
2.992.300
3.639.345
556.000
125.665
62.731
2.384.513
149.436
180.500
86.800
93.700
50.376.304
112.603.798
31.567.417
10.401.956
6.666.928
38.503.442
25.464.055
238.977
3.186.224
1.690.198
893.534
2.578.960
862.646
6.918.660
391.337
1.124.018
7.579.501

132.450.322
11.879.566
41.355.599
41.305.651
46.902.295
5.473.173
151.000
3.092.373
2.229.800
795.643.955
74.584.661
605.765.306
74.711.541
40.582.447
13.772.076
359.331
12.889.036
13.562.004
20.377.482
13.599.100
3.058.400
3.719.982
565.000
128.722
64.241
2.441.253
149.966
186.500
87.700
96.600
51.434.855
115.919.307
32.494.076
10.753.925
6.868.001
39.512.945
26.290.360
248.343
3.273.766
1.754.859
948.296
2.645.305
890.785
7.154.189
453.222
1.166.576
7.755.019

135.213.602
12.130.960
42.405.565
42.272.000
48.075.207
5.579.941
156.223
3.161.118
2.262.600
812.970.865
76.152.535
618.922.643
76.456.121
41.439.566
14.132.019
372.749
13.155.605
13.779.193
20.700.843
13.771.400
3.117.800
3.811.643
576.000
132.608
66.222
2.504.074
150.839
193.000
89.200
99.700
52.531.081
119.418.950
33.467.051
11.117.804
7.207.702
40.529.798
27.096.595
258.789
3.341.488
1.821.626
1.006.892
2.692.031
920.160
7.397.736
522.571
1.200.805
7.934.497

138.125.988
12.386.715
43.511.585
43.221.022
49.273.016
5.630.450
161.626
3.175.524
2.293.300
830.431.345
77.821.374
632.122.746
78.152.686
42.334.539
14.501.369
386.566
13.433.498
14.013.106
20.970.174
13.915.500
3.153.550
3.901.124
585.000
136.604
68.263
2.567.557
151.200
199.500
90.200
102.800
53.605.038
123.044.163
34.475.327
11.493.995
7.625.716
41.471.745
27.977.380
273.661
3.410.097
1.889.792
1.071.549
2.721.832
963.942
7.649.575
598.023
1.228.388
8.170.521

141.122.668
12.645.951
44.650.801
44.148.285
50.533.506
5.700.862
167.216
3.208.346
2.325.300
848.753.294
80.313.516
645.134.815
80.051.300
43.253.663
14.880.372
400.792
13.722.893
14.249.606
21.240.293
14.074.100
3.164.900
4.001.293
599.339
140.721
70.368
2.633.194
153.690
207.278
90.703
106.000
54.732.934
126.886.231
35.581.772
11.882.916
8.138.148
42.376.642
28.906.753
297.410
3.481.564
1.959.326
1.140.357
2.757.773
1.012.702
7.908.868
683.672
1.261.091
8.403.990

378.228.677
73.716.258
34.807.417
16.660.670
22.248.171
14.760.787
2.183.877
5.303.507
304.512.419
23.935.810
109.762.621
2.761.407
5.433.886
275.467
6.171.630
517.101
9.352.145
3.787.796
625.361
1.482.628
5.801.204
5.060.262
58.946.321
4.588.696
2.879.013
2.079.704
170.813.988
5.949.453
619.351
3.529.983
7.021.028
1.927.260
3.886.643
251.577
23.007.669
1.340.458
196.978
277.603
2.260.187
30.770.372
538.009
12.044.785
1.116.779
7.082.430
4.760.666
1.332.786
851.334

388.141.535
75.415.098
35.480.414
16.998.378
22.936.306
15.197.724
2.312.369
5.426.213
312.726.437
24.549.294
112.898.586
2.836.325
5.507.594
277.331
6.465.220
534.171
9.642.482
3.862.799
633.266
1.528.162
5.935.323
5.175.408
60.707.810
4.727.163
2.925.433
2.140.099
175.278.557
6.115.582
643.076
3.540.066
7.179.499
1.965.058
3.969.803
259.299
23.668.471
1.376.455
206.173
271.301
2.340.837
31.445.177
560.658
12.482.054
1.142.460
7.250.455
4.900.549
1.355.793
861.239

398.315.212
77.211.933
36.216.313
17.335.236
23.660.384
15.653.200
2.450.747
5.556.437
321.103.279
25.178.954
116.070.623
2.914.439
5.587.373
278.769
6.749.048
549.655
9.889.668
3.939.774
640.043
1.575.442
6.074.032
5.294.763
62.529.409
4.872.244
2.973.542
2.202.422
179.853.702
6.111.684
671.769
3.594.958
7.346.174
2.006.137
4.055.702
267.318
24.333.992
1.414.408
216.363
249.952
2.380.509
32.199.367
597.135
12.944.287
1.168.731
7.423.573
5.072.873
1.379.655
873.292

408.594.112
79.052.183
36.952.499
17.687.376
24.412.308
16.140.252
2.568.090
5.703.966
329.541.929
25.815.144
119.312.539
2.995.605
5.673.472
280.450
7.030.905
565.590
10.099.916
4.018.826
680.919
1.616.510
6.217.503
5.419.038
64.427.500
4.989.168
3.030.393
2.266.744
184.414.246
6.050.398
704.591
3.676.308
7.521.530
2.057.734
4.144.061
275.651
25.032.227
1.455.023
226.569
213.292
2.421.037
32.975.868
647.436
13.433.414
1.195.487
7.603.790
5.317.309
1.404.403
885.461

419.701.995
80.937.632
37.736.990
18.042.963
25.157.679
16.634.618
2.663.767
5.859.294
338.764.363
26.467.896
122.697.346
3.080.268
5.764.606
282.747
7.334.543
581.984
10.325.541
4.100.005
732.707
1.659.860
6.365.926
5.547.894
66.399.262
5.100.499
3.088.374
2.333.130
189.599.121
6.157.498
741.273
3.749.077
7.721.125
2.112.017
4.234.743
284.309
25.740.503
1.496.825
236.768
190.808
2.469.199
33.824.835
687.762
13.951.436
1.222.874
7.807.400
5.530.771
1.430.069
897.811

431.358.047
83.057.506
38.783.863
18.396.941
25.876.702
17.152.804
2.718.837
6.005.061
348.300.541
27.129.932
126.113.037
3.168.267
5.891.063
285.964
7.642.397
598.855
10.556.349
4.183.359
745.228
1.705.485
6.457.634
5.682.086
68.427.930
5.219.201
3.147.566
2.401.653
195.057.572
6.436.754
781.472
3.834.415
7.942.132
2.167.560
4.327.777
309.007
26.482.646
1.539.690
252.171
192.675
2.512.642
34.617.799
706.489
14.500.404
1.255.193
8.011.695
5.702.228
1.455.644
913.025

9.809.596
821.782
3.992.121
76.595
56.814
11.635.707
480.105
14.706.593
10.136.422
4.471.767
5.861.135

10.087.915
851.258
4.109.838
78.222
57.530
11.960.783
493.232
15.201.384
10.307.149
4.595.292
6.001.949

10.370.281
882.005
4.226.380
79.667
58.425
12.328.380
506.812
15.681.232
10.516.738
4.723.368
6.172.535

10.432.604
915.325
4.356.863
81.607
59.626
12.707.275
520.864
16.147.863
10.760.703
4.848.130
6.341.797

10.769.649
950.488
4.502.352
84.176
60.676
13.097.814
535.618
16.625.711
11.012.722
4.976.394
6.496.418

11.127.868
977.026
4.657.072
86.796
61.791
13.500.356
551.407
17.129.565
11.272.138
5.110.028
6.642.107

3.840.872.427
711.591.742
502.307.742
2.773.851.723
61.371.336
8.857.855
2.703.622.532
355.428.962
2112794918

3.915.766.223
717.703.667
506.346.667
2.839.481.656
62.494.746
9.198.592
2.767.788.318
358.580.900
2157937452

3.989.552.203
723.382.955
510.040.955
2.904.285.593
63.668.021
9.559.647
2.831.057.925
361.883.655
2202087040

4.061.330.637
728.791.931
513.326.931
2.967.308.252
64.781.670
10.072.337
2.892.454.245
365.230.454
2244759036

4.131.782.807
733.603.373
516.040.373
3.029.646.837
66.002.610
10.694.517
2.952.949.710
368.532.597
2285895241

4.203.014.663
738.449.171
518.689.171
3.092.754.667
67.139.203
11.439.505
3.014.175.959
371.810.825
2325879554

Former Soviet Union
Asia and OceaniaMiddle east

Africa

280.082.148
279.887.392
280.000.433
280.418.524
281.077.715
281.772.946
282.398.503
283.056.630
283.700.964
283.994.407

3.585.680.910
3.624.631.399
3.662.866.545
3.700.608.936
3.738.246.385
3.775.101.304
3.811.590.237
3.847.931.311
3.884.090.445
3.919.977.747

262.325.250
267.249.663
272.165.095
277.093.726
282.039.579
286.990.273
291.921.026
296.836.753
301.557.917
305.755.267

890.890.756
912.818.454
935.345.091
958.348.080
981.939.465
1.005.892.148
1.029.951.554
1.054.864.196
1.080.708.451
1.106.852.580

1978

1979

1980

1981

1982

1983

4.274.135.360
4.052.040.360
246.131.300
24.036.300
222.095.000
342.760.655
65.295.990
48.384.959
68.608
201.499
250.145
142.937
2.192.367
9.634.028
74.366
5.431.308
4.399.428
92.535
6.345.655
5.288.765
3.168.347
2.179.441

4.347.811.568
4.123.244.568
248.843.900
24.276.900
224.567.000
350.531.912
66.825.878
49.366.549
68.519
206.150
251.145
145.205
2.259.714
9.710.150
74.238
5.562.270
4.511.750
91.354
6.495.749
5.396.136
3.279.238
2.207.245

4.419.054.562
4.191.829.881
251.817.981
24.593.300
227.224.681
358.224.898
68.347.479
50.173.611
68.546
209.760
251.966
144.416
2.299.124
9.652.975
73.887
5.696.855
4.570.410
90.164
6.649.593
5.507.700
3.402.468
2.228.803

4.501.372.335
4.271.906.621
254.365.714
24.900.000
229.465.714
366.094.573
69.930.971
51.033.862
68.264
213.447
252.361
149.207
2.357.285
9.711.975
73.519
5.831.714
4.519.721
92.354
6.828.684
5.622.870
3.543.061
2.258.368

4.580.818.872
4.349.154.414
256.866.358
25.201.900
231.664.458
374.115.801
71.567.658
51.903.197
68.008
217.129
253.475
153.296
2.424.367
9.789.224
73.813
5.968.735
4.479.917
92.414
6.982.721
5.740.421
3.670.043
2.298.309

4.661.233.076
4.427.441.082
259.248.294
25.456.300
233.791.994
382.326.383
73.257.049
52.887.683
65.620
220.857
254.847
156.846
2.494.353
9.881.149
74.286
6.105.818
4.526.713
92.526
7.188.649
5.862.293
3.796.140
2.306.386

2.608.303
1.874.971
3.117.884
44.103
119.025
95.717
1.055.527
229.079.706
27.440.272
115.283.675
86.355.759
5.204.622
10.685.889
25.575.428
7.489.432
755.889
3.037.492
16.414.399
365.277
2.896.507
13.930.824
486.593.942
460.008.765
354.260.202
7.562.305
10.191.800
9.829.700
362.100
5.104.247
4.752.528
54.649.382
78.066.074
9.429.959
3.314.000
56.240.143
13.947.172
9.698.780
36.861.034
8.275.778
56.167.000
105.748.563
8.803.281
4.349.242
618.672
10.212.894
1.463.533
10.673.300

2.687.394
1.917.594
3.168.446
43.817
120.396
97.012
1.073.027
234.339.485
27.901.971
118.157.191
88.280.323
5.326.981
10.838.422
26.071.592
7.703.577
757.400
3.101.728
16.848.699
362.861
2.913.946
14.355.117
488.612.165
461.839.954
355.369.414
7.549.425
10.200.200
9.837.200
363.000
5.116.800
4.764.690
54.885.793
78.081.292
9.548.258
3.368.200
56.367.710
14.040.749
9.724.560...


Anonymous
Just what I needed. Studypool is a lifesaver!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags