AIS Case Study

Question #2
Using the ata in the file “World Bank Indicators (Case Study #2).xlsx”, create a pivot table in Excel to answer the following questions. Include your data/calculations in your case study submission.

For all the questions, please see Excel document for detailed calculation information.
1. What are the top 5 countries in urban population at July 2002 and July 2010?

July 2002

Sum of Population: Urban
Year
Country Name
7/1/02
China
481942560
India
305923036
United States
229467379
Brazil
147734323
Russian Federation
106359373

July 2010

Sum of Population: Urban
Year
Country Name
7/1/10
China
600683425
India
368608912
United States
254594794
Brazil
168628697
Indonesia
128810693

2. Which region had the highest urban population at July 2002 and July 2010 (Regions and sub-regions are defined on the second tab)?

Region
7/1/02
7/1/10
Asia
1283994067
1565203831
The Americas
670961699
761629673
Europe
564533273
587106455
Africa
300359263
391951340
Middle East
113031381
143274805
Oceania
22392649
25741975
Other
2470624
2983352
Grand Total
2957742956
3477891431

As shown in the table above, Asia had the highest urban population at both July 2002 and July 2010.

3. Which country had the greatest improvement in the life expectancy of females from July 2002 to July 2010? Which country had the greatest improvement in the life expectancy of males during the same period?

Female

Country Name
7/1/02
7/1/10
Improvement
Bermuda 82
82
Liberia
49
57
8
Zambia
42
49
7
Malawi
47
54
7
Ethiopia
54
60
6
Tanzania
52
58
6

As shown in the table above, Liberia had the greatest improvement in the life expectancy of females from July 2002 to July 2010.

Male

Country Name
7/1/02
7/1/10
Improvement
Bermuda 77
77
Liberia
47
55
8
Zimbabwe
44
51
7
Sierra Leone
40
47
7
Tanzania
51
57
6
Zambia
42
48
6

As shown in the table