In Progress

Generate Descriptive Statistics and Simple Data Transformation for ~10 Tables

I need to replicate some statistics involving basic transformations/computation done for a previous study on a different set of countries. This is for a robustness check for a separate study, and I need it done relatively quickly. If you know how to work with patent (USPTO) data, I believe it should not take too much time (even if you have not worked with patents, they are not overly complicated to figure out if you're familiar with data analysis/database use). US patents are publicly available and downloadable from multiple sites, several of which are listed here: [url removed, login to view] . There are also two tables (GDP and exports) that require basic macroeconomic data from EIU or World Bank.

For all tables, I need to use the years 1980 - 2015. I need the raw .csv data to check for all patents, and ideally all output tables generated in LaTeX. For Tables 1-4, please use the countries listed below. Time frames should be adjusted to 1980-84...2010-14 (7 balanced periods of five-year intervals).

Armenia

Azerbaijan

Belarus

Estonia

Georgia

Kazakhstan

Kyrgyzstan

Latvia

Lithuania

Moldova

Tajikistan

Turkmenistan

Ukraine

Uzbekistan

China

Poland

Yugoslavia

Czech Republic

Slovakia

Slovenia

Bosnia and Herzegovina

Croatia

Macedonia

Montenegro

Serbia

Romania

Bulgaria

Hungary

Germany

Russia

Please replicate Table 5 with no changes required. Table 6 can be skipped. For Tables 7-9 using the chi-squared index (a relatively simple transformation), I need to use the same time intervals as above for Poland and the Soviet Union.

Prior to 1991, patents from former Soviet republics will probably be labelled "SU". If this is the case, please check if distinguishing by republic is possible based on address. If so, please use the following three countries or sets in lieu of SU: Russia, Baltic States (Latvia, Lithuania, Estonia), and Ukraine. If it is not possible to distinguish, simply compute SU and Poland for patent recipients for 1980-84 and 1985-89. From 1990-94...2010-14, use the following sets: Poland, Baltic States (Latvia, Lithuania, Estonia), Russia and Ukraine.

Finally, please calculate and output the top 50 patent holders for the same groups as above in a similar manner to Tables 11-16, but break the time periods into the following intervals: 1980-89, 1990-99, 2000-09. If the type of organization is apparent from the patenting information, please include this (and also replicate Table 10). But if not, that component isn't critical.

Skills: LaTeX, Patents, Research, Statistical Analysis

See more: arcsine transformation percentage data, how to back transform log data, data transformation statistics, data transformation statistics pdf, table presentation of data, arcsine transformation table, back transformation statistics, when to use square root transformation, simple linear regression descriptive statistics, simple data statistics, generate preliminary descriptive statistics stata, interpret descriptive statistics wage data, descriptive statistics data interpretation sales, simple data mining, excel simple data entry

About the Employer:
( 1 review ) Singapore, Singapore

Project ID: #16546636

Awarded to:

tiagobarreira

A proposal has not yet been provided

$300 USD in 7 days
(2 Reviews)
1.8

6 freelancers are bidding on average $379 for this job

Valuesolutions

Hello, i have read the details provided..please contact me to discuss more on the project deadline and some other few things

$250 USD in 10 days
(12 Reviews)
4.7
healthmonkey

Hi, I am a very experienced statistical programmer, with background in Economics & Quantitative Finance. I think I am the right person for this job. Please contact me to discuss the details. Philipp

$500 USD in 7 days
(2 Reviews)
3.3
thisistitus

A proposal has not yet been provided

$333 USD in 5 days
(0 Reviews)
0.0
$555 USD in 10 days
(0 Reviews)
0.0
hemajois

A proposal has not yet been provided

$333 USD in 15 days
(0 Reviews)
0.0