Reference no: EM131338836

Complete the following in Excel: Based on the Current Population Survey (CPS) of March 1995, Paul Rudd extracted a sample of 1289 workers, aged 18 to 65, and obtained the following information on each worker:

1. Wage = hourly wage in $
2. Age = age in years
3. Female = 1 if female worker
4. Nonwhite = 1 if a nonwhite worker
5. Union = 1 if a union member
6. Education = years of schooling
7. Experience = potential labor market experience in years
8. The full data set can be found as Table 6-16 on the textbook's Web site.
9. Based on these data, estimate the following model, obtaining the usual regression statistics. 1n Wagei = B1 + B2 Age + B3 Female + B4 Nonwhite + B5 Union + B6 Education + B7 Experience + ui where 1n Wage = (natural logarithm of Wage)
10. How do you interpret each regression coefficient?
11. Which of these coefficients are statistically significant at the 5% level? Also obtain the p value of each estimated t value.
12. Do union workers, on average, earn a higher hourly wage?
13. Do female workers, on average, earn less than their male counterparts?
14. Is the average hourly wage of female nonwhite workers lower than the average hourly wage of female white workers? How do you know? (Hint: interaction dummy.)
15. Is the average hourly wage of female union workers higher than the average hourly wage of female non-union workers? How do you know?