Assignment:
Download the dataset regarding the "Economic Value of a Year of Education" available following this link. The dataset contains cross-sectional data for approximately 3,000 individuals for the following variables:
ahei = average hourly wage for the i
th individual
yrseduci = years of schooling for the i
th individual
a_sexi = gender of the i
th (1 for male, 2 for female)
a_agei = age of the i
th individual
1. Plot an histogram of the distribution of hourly wages.
2. Create a new categorical variable degi that takes the value 0 for individuals who did not ?nish high school (less than 12 years of schooling), the value 1 for who ?nished high school but not college (at least 12 and less than 16 years of schooling), and the value 2 for individuals who completed college (at least 16 years of schooling).
3. What proportion of individuals falls into each of these categories?
4. What is the average hourly wage for individuals in each of these categories?
5. Make a box-plot showing the distribution of hourly wages for these di?erent categories of individuals. What can you tell from this box-plot?
6. What is the proportion of females in the sample?
7. What is the average hourly wage for males and females?
8. Make a box-plot showing the distribution of hourly wages for males and females. What can you tell from this box-plot?
9. Plot a scaterplot of years of schooling vs. hourly wages
10. Use OLS to estimate the following model. You must report both the estimated coe?cients and the
corresponding standard errors.
ahei = β0 + β1yrseduci + β2a_sexi + β3a_agei + εi
11. With 95% con?dence, which regressors have a statistically signi?cant e?ect on hourly wages? [justify your answer]
12. What is the value of the adjusted R¯2 coe?cient? What does this number tell you for this particular model?
13. What is the estimated average e?ect of years of schooling on hourly wages?
14. According to the estimated model, what would be the average hourly wage of a 30 years old female who completed a 2-years master degree after ?nishing college?
15. According to the estimated model, what is the average e?ect over hourly wages of attending college?