country information data compile

Completed Posted Oct 24, 2012 Paid on delivery
Completed Paid on delivery

This project is creating one universal data-set from seven (7)

sources. It will require using provided excel or tab files of single

country data (GDP, Allies, etc) to create new indexes for a dyad of

countries (1 set of 2 countries paired together). Each line of coding

is based on the dyad year from 1900 to 2011.

## Deliverables

This project is creating one universal data-set from seven (7)

sources. It will require using provided excel or tab files of single

country data (GDP, Allies, etc) to create new indexes for a dyad of

countries (1 set of 2 countries paired together). Each line of coding

is based on the dyad year from 1900 to 2011.

Coding Instructions: In each directive below, I use the terms Country

A and Country B as examples of relationships such as between India and

Pakistan, or Kosovo and Serbia. These are what I mean when I refer to

"a country Dyad" - two countries as one unit of analysis. Each line

of coding will be based upon the "dyad year." An example excel sheet

is provided for what the final product must look like.

Variable 1: Bilateral Trade between dyad countries. This variable is

interested in calculating how connected two country's economies are in

a particular year. One dataset provided has every country year's GDP.

Another dataset provided has every country year's exports and imports

from other countries. This index will take combined imports and

exports between country A and Country B as a percent of both A and B

GDP.

BiLateral Trade = (exports of A to B + exports of B to A) +(

IMPORTS of A from B + Imports of B from A) / GDP of A x GDP of B

(per year)

Variable 2: Multilateral Trade. This variable is interested in

calculating the total value of global trade for the dyad for each

year. Based on the dataset provided, take country A total exports +

Country A total imports as a percent of country A GDP and add it to

country B total exports + country B total imports as a percent of

country B GDP.

Multilateral Trade = (Exports of A + Imports of A / GDP of A) +

(Exports of B + Imports of B /GDP of B ) (per year)

Variable 3: Allies Shared. This variable is interested in calculating

how many allies two countries share in a particular year. You will

calculate this by taking the allies dataset and counting how many

allies country A and country B have total combined in a given year.

Then you will calculate how many of those allies are shared between

the two countries and input the percentage shared.

Allies Shared of A+B / Total Allies of A + B (per year)

Variable 4: Dyadic Alliance? This variable is to determine whether or

not two countries are allies with one another in a given year. The

allies data set that is provided will indicate three levels of

alliance between two countries. Input the alliance as it is in the file, 0,1,2,3.

Variable 5: Co-membership in international organizations. This

variable is intended to reveal how many international organization

memberships a dyad shares out of their total membership per dyad year.

This is simply calculated by taking the international organization

dataset and counting how many total organizations country A and

country B are members of in a given year. Then you will calculate how

many of those organizations are shared between the two countries and

input the percentage shared.

Co-membership in Ios AB / total IO membership AB (per year)

Variable 6: Co-Treaty Signature. This variable is intended to

calculate how many international treaties a country dyad has in common

in a given year. This is simply calculated by taking the international

treaties dataset and counting how many total treaties country A and

country B are signatory to in a given year. The data-set indicates

both ratification (coded as 2) and signature (coded as 1). You will

count your input dichotomously (1 for either sign 0 for none: ignore

ratification variable). Then you will calculate how many of those

treaties are shared between the two countries and input the percentage

shared.

Co-signature treaties AB / total-signed treaties AB (per year)

Variable 7: UN Co-vote. The final variable is intended to calculate

how many times the dyad votes the same way at the United Nations in a

given year. This is calculated by taking the UN voting dataset and

counting how many total votes country A and country B execute in a

given year in the General Assembly. Then you will calculate how many

of those votes are shared between the two countries and input the

percentage shared.

Co-General Assembly votes AB / Total General Assembly votes AB (per year)

Data Entry Engineering Software Architecture Software Testing Statistics

Project ID: #2787687

About the project

5 proposals Remote project Active Oct 26, 2012

Awarded to:

stat3

See private message.

$51 USD in 7 days
(67 Reviews)
5.4

5 freelancers are bidding on average $75 for this job

sabinacreative

See private message.

$95 USD in 7 days
(2 Reviews)
1.2
JackOmond

See private message.

$70.55 USD in 7 days
(0 Reviews)
0.0
tlindeman

See private message.

$80 USD in 7 days
(0 Reviews)
0.6
zeshanhvw

See private message.

$80.75 USD in 7 days
(1 Review)
0.0