Basic Excel Homework

User Generated

Tbqmvyynonol

Business Finance

Description

merge the two excel datasets then

  • Go to the GINI coefficient dataset and delete all irrelevant columns as well as all data preceding the year 1990
  • Use the V-Look up or Match-Index combination to merge each country with its appropriate geographic region. There may be countries/country codes that are misspelled and some entries that are not countries that need to be removed. You need to take care of both issues.Feel free to remove any entries that give you a lot of trouble, but try to avoid that as much as possible.
  • Once you have every country matched with its corresponding region, create a list of GINI coefficients averaged out for each year for a given region. You can do that using filters and sorting functions. Feel free to use any other method. Ignore the missing values in the average.
  • Finally, you will end-up with a list of the world regions and a GINI coefficient average for each year. Graph that on one graph.

GRADING:

  • A sheet showing the following after the merge:(4 – 6 pages maximum) (5 pts for organization)
    • A column numbering the rows. 1,2,3,….,etc.(2 pts)
    • The country Code(2 pts)
    • The country name (abbreviated if necessary) (1 pts)
    • Region (5 pts)
    • The country data for the following years: 1990, 2000, 2010, and 2014(10 pts)
  • One sheet showing the aggregated averages over all years between 1990 – 2014 for the different World Regions. For submission, you will need to transpose this so that the Years are on the rows and the regions are the columns. (Less than 4 pages). (20 pts)
  • One sheet displaying the graph of all the trends from 1990 – 2014 for all world regions(10 pts)

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

As promised, kindly find attached. I have followed all instructions to provide high quality work.
Here it is.

No
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

Series NameSeries CodeCountry Country Code
Region
1990 [YR1990]
1991 [YR1991]
1992 [YR1992]
GINI index (World
SI.POV.GINIAfghanistanAFG
Bank estimate)
South Asia ..
..
..
GINI index (World
SI.POV.GINIAlbania
Bank estimate) ALB
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINIAlgeria
Bank estimate) DZA
Middle East..& North Africa
..
..
GINI index (World
SI.POV.GINIAngola
Bank estimate) AGO
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINIArgentina
Bank estimate) ARG
Latin America
.. & Caribbean 46.76
45.47
GINI index (World
SI.POV.GINIArmenia
Bank estimate) ARM
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINIAustralia
Bank estimate) AUS
East Asia & ..Pacific
..
..
GINI index (World
SI.POV.GINIAustria
Bank estimate) AUT
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINIAzerbaijan
Bank estimate) AZE
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINIBangladeshBGD
Bank estimate)
South Asia ..
27.57 ..
GINI index (World
SI.POV.GINIBelarus
Bank estimate) BLR
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINIBelgium
Bank estimate) BEL
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINIBelize
Bank estimate) BLZ
Latin America
.. & Caribbean
..
..
GINI index (World
SI.POV.GINIBenin
Bank estimate) BEN
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINIBhutan
Bank estimate) BTN
South Asia ..
..
..
GINI index (World
SI.POV.GINIBolivia
Bank estimate) BOL
Latin America & Caribbean
42.04 ..
49.11
GINI index (World
SI.POV.GINIBosnia
Bank estimate)
and Herzegovina
BIH
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINIBotswana
Bank estimate) BWA
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINIBrazil
Bank estimate) BRA
Latin America & Caribbean
60.49 ..
53.17
GINI index (World
SI.POV.GINIBulgaria
Bank estimate) BGR
Europe & Central
..
Asia ..
30.71
GINI index (World
SI.POV.GINIBurkina
Bank estimate)
FasoBFA
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINIBurundi
Bank estimate) BDI
Sub-Saharan.. Africa
..
33.33
GINI index (World
SI.POV.GINICabo
Bank estimate)
VerdeCPV
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINICambodia
Bank estimate) KHM
East Asia & ..Pacific
..
..
GINI index (World
SI.POV.GINICameroon
Bank estimate) CMR
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINICanada
Bank estimate) CAN
North America
..
31.15 ..
GINI index (World
SI.POV.GINICentral
Bank estimate)
African
CAFRepublicSub-Saharan.. Africa
..
61.33
GINI index (World
SI.POV.GINIChad
Bank estimate) TCD
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINIChile
Bank estimate) CHL
Latin America & Caribbean
57.25 ..
54.81
GINI index (World
SI.POV.GINIChina
Bank estimate) CHN
East Asia & ..Pacific
..
..
GINI index (World
SI.POV.GINIColombia
Bank estimate) COL
Latin America
.. & Caribbean 51.32
51.45
GINI index (World
SI.POV.GINIComoros
Bank estimate) COM
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINICongo,
Bank estimate)
Rep.COG
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINICosta
Bank estimate)
Rica CRI
Latin America & Caribbean
45.3
46.65
45.71
GINI index (World
SI.POV.GINICote
Bank estimate)
d'IvoireCIV
Sub-Saharan.. Africa
..
39.39
GINI index (World
SI.POV.GINICroatia
Bank estimate) HRV
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINICyprus
Bank estimate) CYP
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINICzech
Bank estimate)
Republic
CZE
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINIDenmark
Bank estimate) DNK
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINIDjibouti
Bank estimate) DJI
Middle East..& North Africa
..
..
GINI index (World
SI.POV.GINIDominican
Bank estimate) Republic
DOM
Latin America
.. & Caribbean
..
51.36
GINI index (World
SI.POV.GINIEcuador
Bank estimate) ECU
Latin America
.. & Caribbean
..
..
GINI index (World
SI.POV.GINIEgypt,
Bank estimate)
Arab EGY
Rep.
Middle East..& North Africa
..
..
GINI index (World
SI.POV.GINIEl
Bank estimate)
Salvador SLV
Latin America
.. & Caribbean 53.95 ..
GINI index (World
SI.POV.GINIEquatorial
Bank estimate) Guinea
GNQ
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINIEritrea
Bank estimate) ERI
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINIEstonia
Bank estimate) EST
Europe & Central
..
Asia ..
..
GINI index (World
SI.POV.GINIEthiopia
Bank estimate) ETH
Sub-Saharan.. Africa
..
..
GINI index (World
SI.POV.GINIFiji
Bank estimate) FJI
East Asia & ..Pacific
..
..

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

GINI index (World
SI.POV.GINIFinland
Bank estimate) FIN
GINI index (World
SI.POV.GINIFrance
Bank estimate) FRA
GINI index (World
SI.POV.GINIGabon
Bank estimate) GAB
GINI index (World
SI.POV.GINIGambia,
Bank estimate)
TheGMB
GINI index (World
SI.POV.GINIGeorgia
Bank estimate) GEO
GINI index (World
SI.POV.GINIGermany
Bank estimate) DEU
GINI index (World
SI.POV.GINIGhana
Bank estimate) GHA
GINI index (World
SI.POV.GINIGreece
Bank estimate) GRC
GINI index (World
SI.POV.GINIGuatemala
Bank estimate) GTM
GINI index (World
SI.POV.GINIGuinea
Bank estimate) GIN
GINI index (World
SI.POV.GINIGuinea-Bissau
Bank estimate) GNB
GINI index (World
SI.POV.GINIGuyana
Bank estimate) GUY
GINI index (World
SI.POV.GINIHaiti
Bank estimate) HTI
GINI index (World
SI.POV.GINIHonduras
Bank estimate) HND
GINI index (World
SI.POV.GINIHungary
Bank estimate) HUN
GINI index (World
SI.POV.GINIIceland
Bank estimate) ISL
GINI index (World
SI.POV.GINIIndia
Bank estimate) IND
GINI index (World
SI.POV.GINIIndonesia
Bank estimate) IDN
GINI index (World
SI.POV.GINIIran,
Bank estimate)
IslamicIRN
Rep.
GINI index (World
SI.POV.GINIIraq
Bank estimate) IRQ
GINI index (World
SI.POV.GINIIreland
Bank estimate) IRL
GINI index (World
SI.POV.GINIIsrael
Bank estimate) ISR
GINI index (World
SI.POV.GINIItaly
Bank estimate) ITA
GINI index (World
SI.POV.GINIJamaica
Bank estimate) JAM
GINI index (World
SI.POV.GINIJapan
Bank estimate) JPN
GINI index (World
SI.POV.GINIJordan
Bank estimate) JOR
GINI index (World
SI.POV.GINIKazakhstan
Bank estimate) KAZ
GINI index (World
SI.POV.GINIKenya
Bank estimate) KEN
GINI index (World
SI.POV.GINIKiribati
Bank estimate) KIR
GINI index (World
SI.POV.GINIKyrgyz
Bank estimate)
Republic
KGZ
GINI index (World
SI.POV.GINILao
Bank estimate)
PDR LAO
GINI index (World
SI.POV.GINILatvia
Bank estimate) LVA
GINI index (World
SI.POV.GINILesotho
Bank estimate) LSO
GINI index (World
SI.POV.GINILiberia
Bank estimate) LBR
GINI index (World
SI.POV.GINILithuania
Bank estimate) LTU
GINI index (World
SI.POV.GINILuxembourg
Bank estimate) LUX
GINI index (World
SI.POV.GINIMacedonia,
Bank estimate) MKD
FYR
GINI index (World
SI.POV.GINIMadagascar
Bank estimate) MDG
GINI index (World
SI.POV.GINIMalawi
Bank estimate) MWI
GINI index (World
SI.POV.GINIMalaysia
Bank estimate) MYS
GINI index (World
SI.POV.GINIMaldives
Bank estimate) MDV
GINI index (World
SI.POV.GINIMali
Bank estimate) MLI
GINI index (World
SI.POV.GINIMauritania
Bank estimate) MRT
GINI index (World
SI.POV.GINIMauritius
Bank estimate) MUS
GINI index (World
SI.POV.GINIMexico
Bank estimate) MEX
GINI index (World
SI.POV.GINIMicronesia,
Bank estimate) FSM
Fed. Sts.
GINI index (World
SI.POV.GINIMoldova
Bank estimate) MDA
GINI index (World
SI.POV.GINIMongolia
Bank estimate) MNG
GINI index (World
SI.POV.GINIMontenegro
Bank estimate) MNE
GINI index (World
SI.POV.GINIMorocco
Bank estimate) MAR

Europe & Central
..
Asia ..
..
Europe & Central
..
Asia ..
..
Sub-Saharan.. Africa
..
..
Sub-Saharan.. Africa
..
..
Europe & Central
..
Asia ..
..
Europe & Central
..
Asia ..
..
Sub-Saharan.. Africa
38.44 ..
Europe & Central
..
Asia ..
..
Latin America
.. & Caribbean
..
..
Sub-Saharan.. Africa
46.84 ..
Sub-Saharan.. Africa
..
..
Latin America
.. & Caribbean
..
..
Latin America
.. & Caribbean
..
..
Latin America & Caribbean
57.36
51.85
Europe & Central
..
Asia ..
..
Europe & Central
..
Asia ..
..
South Asia ..
..
..
East Asia & ..Pacific
..
..
Middle East & North
43.6
Africa
..
..
Middle East..& North Africa
..
..
Europe & Central
..
Asia ..
..
Middle East..& North Africa
..
Europe & Central
..
Asia ..
..
Latin America & Caribbean
41.11 ..
..
East Asia & ..Pacific
..
..
Middle East..& North Africa
..
..
Europe & Central
..
Asia ..
..
Sub-Saharan.. Africa
..
East Asia & ..Pacific
..
..
Europe & Central
..
Asia ..
..
East Asia & ..Pacific
..
Europe & Central
..
Asia ..
..
Sub-Saharan.. Africa
..
..
Sub-Saharan.. Africa
..
..
Europe & Central
..
Asia ..
..
Europe & Central
..
Asia ..
..
Europe & Central
..
Asia ..
..
Sub-Saharan.. Africa
..
..
Sub-Saharan.. Africa
..
..
East Asia & ..Pacific
..
South Asia ..
..
..
Sub-Saharan.. Africa
..
..
Sub-Saharan.. Africa
..
..
Sub-Saharan.. Africa
..
..
Latin America
.. & Caribbean
..
East Asia & ..Pacific
..
..
Europe & Central
..
Asia ..
East Asia & ..Pacific
..
..
Europe & Central
..
Asia ..
..
Middle East & North
39.2
Africa
..
..

51.83

35.5

57.46

34.31

47.65

50.95
34.32

100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
1...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags