looking for stata expert urgently

Budget

$14.00FIXED

Client

Suza India

Status

ClosedMar 28, 2018
To test Between-sector Job Polarization across EU member states I am intending to adopt a model developed in the paper, Goos et al. (2015), where they look at the regression model outlined below.

DeltaYjct=bo+b1LnCapjc+b2LnCapjc^2+ejct

Where:\u00ac
DeltaYjct = % difference between t and t-5 in the share of workers employed in each industry j in country c
LnCapjc = ICT capital intensity index of industry j in country c
Ejct= error term

We are interested in finding a U shape relationship between DeltaYj and LnCap
Hence the hypothesis to test the presence of Job Polarization is as follows: b1>0 and b2>0

For the reallocation of skilled workers (who are defined to be workers with tertiary education) a similar regression model is used, only DeltaYjct changes to % difference between t and t-5 in the share of skilled workers employed in industry j in country c

The hypothesis we are testing is b1>0 and b2>0 be insignificant
And when we set the value of b2 equal 0, b1 estimated coefficient should be positive and significant

For the reallocation of unskilled workers (who are defined to be workers with primary and secondary education), we again use the same regression model, however in this case DeltaYjct indicates the difference in share of unskilled workers
Moreover, the hypothesis is that the model will predict more positive change in the employment share for the least compared to middling ICT capital intense sectors.


All data is gathered from EUKLEMS 2017 database:

To calculate ICT capital intensity index, I have developed the following formula using 2014 dataset:

ICTCapjc=[(Total Capital Compensations)x(Nominal Gross fixed Capital Formation of ICT capital/Total Nominal Gross fixed Capital formation)]/(Gross Output)

In terms of indexes used in the EUKLEMS database:

ICTCapjc= [(Cap)x(I_IT+I_CT+I_Soft_DB)/(I_GFCF)]/(GO)

However, for some countries the Nominal Gross fixed Capital Formation of ICT capital was missing hence I have used slightly different formula. Instead of aggregating ICT capital I have deducted non-ICT capital, from Total Nominal Gross fixed Capital formation. As this can be seen in the excel spreadsheet, which contains all of the formulas for the indexes.
Due to missing data for some of the industries only the following industries would be used in the empirical model:

By using the ranking of GDP per capita I have grouped the countries of my interest in two groups.
Group 1: (Denmark, Sweden, Finland, Austria, Netherlands, Germany, France, U.K., Italy, Spain)

Group 2: (Slovenia, Portugal, Czech R., Estonia, Slovakia, Latvia, Poland, Hungary)

For the first part of the empirical analysis where we test the relationship of ICT capital intensity on Total hours worked by person engaged if we used the time period of 1995-2014, only 4 countries from Group 2 would have sufficient data (Slovenia, Portugal, Czech R., and Slovakia) as for Estonia, Latvia and Poland the data is available since 2000.

For the second part of empirical analysis, EUKLEMS has missing data for all countries during 2006 and 2007. Hence it is possible to either perform the analysis on countries for the period 2008-20014 (and data is complete for all countries)
Or test for 1995-2005 using earlier EUKLEMS data sources. However, Sweden and France from first group and Portugal, Estonia, Latvia from the second group should be dropped.

Given the data perhaps for the analysis of skilled vs unskilled employers 2008-2014 years would be more appropriate??

On the other side in the original paper, DeltaYjct, the % change in the share of the workers have been done in differences between 5-year time period, and it is done to take into account of business cycle fluctautions in the economies. But given the data perhaps a shorter time period difference should be used if the model does not suffer too much from the change?
And lastly the data are given in EUKLEMS on labour Input also contains information on the gender of workers, does that mean that the model would benefit from taking into account the gender of the workers as well or it would not change our findings?

As in the original paper the results are presented on Kernel Plots of average annual employemtn share changes by a ranking of sectors according to their ICT capital intensity in 2014 averaged across countries.

Skills & Expertise Required

software development 

Project closed for bidding!



Share this project with your friends



Similar Projects

A disk read error occured

I received the following message on my computer. Need help on removing this and access my computer

message reads

a disk read error occured
press ctrl+alt+del to restart

Hourly, $5.00

Wordpress website template

I require someone to design a Wordpress template for me and input it into my website ASAP.
The design is very simple but includes animations and it should be easily editable with content.
I...read more

Fixed, $40.00

Job for greek freelancers

I search for greek freelancers who have watched a lot of greek series and sitcom

Fixed, $350.00

IOS Mobile Application Programmer

I want to give the top IOS/Android Mobile Application Programmers an opportunity to partner up with me in my startup company. The base/source of this company is a mobile application. I want to bring a...read more

Hourly, $5.00

Optimize and Speed up website

I work with shopify. I have a godaddy domain and need to speed up my website and optimize for mobile

Hourly, $10.00

Here are our top professional picks for you to hire

MUMPS DEVELOPER
software development 
$17 /hr
India
Expert Responsive Emails, Newsletter Templates, Mailchimp, CC, CM
HTML Newsletter Email Design PSD to MailChimp 
$20 /hr
India
email marketing Lead Generation Web Scraping 
/hr
India
Full Stack Developer
Website Development software development Python Developers 
$8 /hr
India
Senior software author, and French writer
software development C++ Python 
$30 /hr
France
Content writer
Content Writing English Proofreading software development 
$10 /hr
India
Web Developer | Graphic Designer | Software Developer | Data Scientist
Website Design Responsive Web Design Website Development 
$3 /hr
India
Project Manager-IT
Project Management Process Improvement Business Process Automation 
$50 /hr
India
Software Engineer
Logo Design Business Cards Android App Development 
$7 /hr
India
To view more profile join Toogit

Get Started