David Autor

Acemoglu and Autor (2011)

Under Construction

Skills, Tasks and Technologies: Implications for Employment and Earnings [contains color figures: not B&W printer friendly]
Daron Acemoglu and David H. Autor
Handbook of Labor Economics Volume 4, Orley Ashenfelter and David E. Card (eds.), Amsterdam: Elsevier, forthcoming
[Optional: Black and white version of paper for non-color printers]

Downloads

Prep Files:

Census/ACS

Cleaned .dta files

May/ORG

Cleaned .dta files

1973 1979 1985 1991 1997 2003 2009

1974 1980 1986 1992 1998 2004

1975 1981 1987 1993 1999 2005

1976 1982 1988 1994 2000 2006

1977 1983 1989 1995 2001 2007

1978 1984 1990 1996 2002 2008

March CPS

Cleaned .dta files

1962 1969 1975 1981 1987 1993 1999 2005

1964 1970 1976 1982 1988 1994 2000 2006

1965 1971 1977 1983 1989 1995 2001 2007

1966 1972 1978 1984 1990 1996 2002 2008

1967 1973 1979 1985 1991 1997 2003 2009

1968 1974 1980 1986 1992 1998 2004

Task Measure Construction

Figures:

Figure 1 - Composition Adjusted College/High-School Log Weekly Wage Ratio, 1963-2008

Figure 2 - College/High-School Log Relative Supply, 1963-2008

Figure 3a/b - College/High-School Log Relative Supply, 1963-2008 0-9 Years Experience/20-29 Years Experience

Figure 4a/b - Real, Composition-Adjusted Log Weekly Wages for Full-Time Full-Year Workers, 1963-2008 M/F

Figure 5a/b - Predicted Log Hourly Wages by Years of Education, Education Quadratic M/F

Figure 6a/b - Predicted Log Hourly Wages by Years of Education, Education Dummies M/F

Figure 7a/b/c - Cumulative Log Change in Real Weekly Earnings at the 90th, 50th and 10th Wage Percentiles, 1963-2008 MF/M/F

Figure 8a/b/c - Cumulative Log Change in Real Hourly Earnings at the 90th, 50th and 10th Wage Percentiles, 1963-2008 MF/M/F

Figure 9a/b/c - Change in Log Hourly Wages by Percentile Relative to the Median MF/M/F

Figure 10 - Smoothed Changes in Employment by Occupational Skill Percentile 1979-2007

Figure 11 - Change in Employment Shares by Occupation 1993-2006 in 16 European Countries

Figure 12 - Percent Change in Employment by Occupation, 1979-2009

Figure 13a/b/c - Employment Shares by Major Occupation Groups, 1959-2007 MF/M/F

Figure 14a/b - Changes in Employment Shares 1959-2007 in Major Occupations by Educational Category M/F

Figure 15 - U.S. and European Union Occupation Percentages, Age 39 or Less

Figure 16a/b - Change in Employment Shares of Young Workers (Age<40) by Country, 1992-2008 M/F

Figure 17a/b - Partial R-Squared Net of Experience Quartic, 1959-2007 (Education, Occupation, Industry) M/F

Figure 18a/b - Partial R-Squared Net of Experience Quartic, 1959-2007 (Education, Occupation, Task) M/F

Figure 19 - Katz-Murphy Prediction Model for the College/High-School Wage Gap

Figure 20 - Detrended Changes in College/High-School Relative Supply and Relative Wages

Figure 21a/b - Log College/High-School Weekly Wage Ratio, 1963-2008 0-9 Years Experience/20-29 Years Experience

Tables:

Table 1a/b - Changes in Real, Composition-Adjusted Log Weekly Wages for Full-Time Full-Year Workers, 1963-2008: By Educational Category and Sex/By Experience and Educational Category, by Sex

Table 2 - Employment and Wages in Ten Broad Occupations, 1959-2007

Table 3a/b - Employment Shares in Four Broad Occupational Categories (%), 1959-2007; Mean Log Full-Time, Full-Year Weekly and All Hourly Earnings in Four Broad Occupation Categories, 1959-2007 (Census) and 1973-2009 (May/ORG)

Table 4 - Education Distribution by Occupation and Gender in 1979 (Census Data)

Table 5a/b - Means and Standard Deviations of DOT and O*NET Task Measures for Four Broad Occupational Groups in 1979 Census / By Education Level

Table 6 - Decomposition of Changes in the Share of Employment in Four Occupational Categories by Decade due to Changes in Industry Shares and Changes in Occupational Shares within Industries, 1959-2007

Table 7 - Partial R-Squared Values of DOT and O*NET Task and Offshorability Measures, Net of Quartic in Potential Experience

Table 8 - Regression Models for the College/High-School Log Wage Gap, 1963-2008

Table 9 - Regression Models for the College/High-School Log Wage Gap by Potential Experience Group, 1963-2008

Table 10 - OLS Stacked First-Difference Estimates of the Relationship between Demographic Group Occupational Distributions in 1959 and Subsequent Changes in Demographic Groups' Means Log Wages by Decade, 1959-2007