# economic problems

Complete problem 6.28 at the end of Chapter 6 in the text and submit to your instructor. Complete all necessary portions in Excel and submit your completed Excel workbook and paper to your Instructor for grading. Completely answer sections a through g. **6.28.** Based on the Current Population Survey (CPS) of March 1995, Paul Rudd extracted a sample of 1,289 workers, aged 18 to 65, and obtained the following information on each worker:

Wage = hourly wage in $

Age = age in years

Female = 1 if female worker

Nonwhite = 1 if a nonwhite worker

Union = 1 if a union member

Education = years of schooling

Experience = potential labor market experience in years

The full data set can be found here as Table 6-16, and on the textbook’s web site.

- 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 ln Wage = (natural logarithm of Wage)

- How do you interpret each regression coefficient?
- Which of these coefficients are statistically significant at the 5% level? Also obtain the
*p*value of each estimated*t*value. - Do union workers, on average, earn a higher hourly wage?
- Do female workers, on average, earn less than their male counterparts?
- 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.) - Is the average hourly wage of female union workers higher than the average hourly wage of female non-union workers? How do you know?