Question;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 ith individualyrseduci = years of schooling for the ith individuala_sexi = gender of the ith (1 for male, 2 for female)a_agei = age of the ith individual1. 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 wages10. Use OLS to estimate the following model. You must report both the estimated coe?cients and thecorresponding standard errors.ahei =?0 +?1yrseduci +?2a_sexi +?3a_agei +?i11. 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?
Paper#56813 | Written in 18-Jul-2015Price : $32