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.

  1. 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)

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

"Is this question part of your assignment? We can help"