Please use the data file called “PS3 Wage Data” (available in .csv, .txt, or .gdt, depending on which program you choose to use) on Smartsite. This file contains data on wages (w), years of schooling (ed), and years of work experience (ex) for a random sample of 1,289 individuals, taken from the 1995 Current Population Survey by the U.S. Census Bureau. The variables in this data set include, in order by column:

w (wage)

fe (female indicator variable: 1 if person i is female and 0 if male)

nw (nonwhite indicator:  1 if nonwhite and 0 if white)

ed (years of schooling)

ex (years of potential experience)

Assuming that the multiple regression assumptions MR1-MR5 hold, estimate a multiple regression model of the following form:

1.      Please estimate the equation and report your regression results (parameter estimates, standard errors, and t-statistics) in a table.

2.      Based on this regression, what is the marginal return to schooling? To experience?

3.      Your dropout friend claims that a year of schooling couldn’t have more than a \$1.25 effect on wages. Test this null hypothesis at the 95% confidence level. Will this be a one or two-tailed test? Why?

Back in 1974, an economist named Jacob Mincer proposed the following wage equation:

The Mincer equation has since become one of the most widely used equations in econometrics.

4.      Which variables will you need to transform to estimate this equation? Write the transformations you will need to do to those variables.

5.      Estimate the Mincer wage equation, and report your results in table form.

6.      In this specification, what is the interpretation of  b 1? Is it different than what you got in Question 1? Why or why not?

7.      Suppose you think there might be discrimination with respect to gender and race/ethnicity in the U.S. labor market. Write a model that you can use to test whether wages are lower for women and/or non-whites, controlling for education and experience.

31) A small airline recently sold to a private equity group for \$145 million. (4\$)

A small airline recently sold to a private equity group for \$145 million. The airline has earned profits of \$9 million last year. The new managers believe they can grow profits at 5% per year. The private equity group borrows money from wealthy individuals to invest in acquisitions. Because of the significant risk involved, lenders are promised a 12% return on their loans to the equity group. Is the purchase price of the new airline reasonable? Explain

Other Requirements: Please show work in excel file

Please use the data file called “PS3 Wage Data” (available in .csv, .txt, or .gdt, depending on which program you choose to use) on Smartsite. This file contains data on wages (w), years of schooling (ed), and years of work experience (ex) for a random sample of 1,289 individuals, taken from the 1995 Current Population Survey by the U.S. Census Bureau. The variables in this data set include, in order by column:

w (wage)

fe (female indicator variable: 1 if person i is female and 0 if male)

nw (nonwhite indicator:  1 if nonwhite and 0 if white)

ed (years of schooling)

ex (years of potential experience)

Assuming that the multiple regression assumptions MR1-MR5 hold, estimate a multiple regression model of the following form:

1.      Please estimate the equation and report your regression results (parameter estimates, standard errors, and t-statistics) in a table.

2.      Based on this regression, what is the marginal return to schooling? To experience?

3.      Your dropout friend claims that a year of schooling couldn’t have more than a \$1.25 effect on wages. Test this null hypothesis at the 95% confidence level. Will this be a one or two-tailed test? Why?

Back in 1974, an economist named Jacob Mincer proposed the following wage equation:

The Mincer equation has since become one of the most widely used equations in econometrics.

4.      Which variables will you need to transform to estimate this equation? Write the transformations you will need to do to those variables.

5.      Estimate the Mincer wage equation, and report your results in table form.

6.      In this specification, what is the interpretation of  b 1? Is it different than what you got in Question 1? Why or why not?

7.      Suppose you think there might be discrimination with respect to gender and race/ethnicity in the U.S. labor market. Write a model that you can use to test whether wages are lower for women and/or non-whites, controlling for education and experience.

31) A small airline recently sold to a private equity group for \$145 million. (4\$)

A small airline recently sold to a private equity group for \$145 million. The airline has earned profits of \$9 million last year. The new managers believe they can grow profits at 5% per year. The private equity group borrows money from wealthy individuals to invest in acquisitions. Because of the significant risk involved, lenders are promised a 12% return on their loans to the equity group. Is the purchase price of the new airline reasonable? Explain

Other Requirements: Please show work in excel file

Related Questions

[Recommended]: Economic questions...

no need to go over board some are just one to two paragrapshhistory.docxUnformatted Attachment PreviewIn an answer of at least four well-develo...

[Recommended]: PH220 Grantham WK 5 Buoyancy Submer...

Lab AssignmentWelcome to the Lab component of Physics I. This week’s lab is called “Buoyancy.” You will conduct experiments to see how su...

[Recommended]: Cultural Differences Discussion que...

Question 1.Among the Toraja people of Sulawesi, Indonesia, not all was going well with tourism. In fact, resentment became so great over the wa...

[Recommended]: CSCI421 FHSU 5 Output To Functions...

Problem Description: The student shall turn in five functions. You should use mymap1 and mymap2 in problem 3, 4, and 5 if it is needed. Howeve...

[Recommended]: Failure to use SPSS: Mass Property...

Please make sure to use SPSS to finish it !The first file is the instruction and you will need the other three excel worksheet.instruction__2_....

[Recommended]: Genetic Relatives DNA Testing Compa...

please list all references that you may useAssignment 1Now that you have read about how genetic relatives are identified by the testing compani...