Question #2

Using the ata in the file " World Financial institution Indicators (Case Study #2). xlsx”, make a pivot stand in Surpass to answer this questions. Include your data/calculations to aid you study submitting.

For all the questions, make sure you see Excel document intended for detailed calculations information. 1 ) What are the top 5 countries in downtown population at July 2002 and September 2010?

July 2002

Amount of Human population: Urban

Year

Country Name

7/1/02

China and tiawan

481942560

India

305923036

Usa

229467379

Brazil

147734323

Russian Federation

106359373

July 2010

Sum of Population: Downtown

12 months

Country Name

7/1/10

China

600683425

India

368608912

United States

254594794

Brazil

168628697

Indonesia

128810693

2 . Which usually region experienced the highest downtown population at July 2002 and July 2010 (Regions and sub-regions are described on the second tab)?

Region

7/1/02

7/1/10

Asia

1283994067

1565203831

The Americas

670961699

761629673

The european countries

564533273

587106455

Africa

300359263

391951340

Middle section East

113031381

143274805

Oceania

22392649

25741975

Other

2470624

2983352

Grand Total

2957742956

3477891431

Since shown inside the table above, Asia got the highest downtown population in both Come july 1st 2002 and July 2010.

3. Which country acquired the greatest improvement in the life expectancy of females from September 2002 to July 2010? Which country had the highest improvement inside the life expectancy of males through the same period?

Girl

Country Term

7/1/02

7/1/10

Improvement

Cale?on

82

82

Liberia

49

57

8

Zambia

42

49

several

Malawi

forty seven

54

several

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 by July 2002 to This summer 2010.

Male

Nation Name

7/1/02

7/1/10

Improvement

Bermuda

77

77

Liberia

47

fifty-five

8

Mvuma, zimbabwe

44

51

7

Serrania Leone

forty five

47

several

Tanzania

51

57

6th

Zambia

forty two

48

six

As proven in the table...

Tags:

Essay on Diabetes Mellitus Type you

Monte Cristo Essay