How much does education affect wage rates

Assignment Help Microeconomics
Reference no: EM13926044

Background:

In your role as an economic analyst you have been asked the following question:

• How much does education affect wage rates?

The Excel data file (wage) contains 100 observations for each of the following variables:

Variable Label
wage Earning per hour
In_wage The log of earning per hour
educ Years of education
educ2 Years of education squared

Instructions:

Conduct a simple linear regression analysis to examine the relationship between 'education' (the independent variable) and 'wage' (the dependent variable). Using the Excel data file, prepare a 2000 word report using the following structure:

• Purpose
• Background
• Method
• Results
• Discussion
• Recommendations

In preparing your report you must address the following questions:

(a) Obtain summary statistics and histograms for the variables WAGE and EDUC. Discuss the data characteristics.

(b) Estimate the linear regression WAGE: β1 + β2EDUC + ε and interpret the slope.

(c) Calculate the residuals and plot them against EDUC. Are any patterns evident and, if so, what does this mean?

(d) Estimate the quadratic regression WAGE = α1 + α2EDUC2 + ε and interpret the results. Estimate the marginal effect of another year of education on wage for a person with 12 years of education, and for a person with 14 years of education. Compare these values to the estimated marginal effect of education from the linear regression in part (b).

(e) Construct a histogram of ln(WAGE). Compare the shape of this histogram to that for WAGE from part (a). Which appears to be more symmetric and bell-shaped?

(f) Estimate the log-linear regression ln(WAGE) = γ1 + γ2EDUC + ε and interpret the slope. Estimate the marginal effect of another year of education on wage for a person with 12 years of education, and for a person with 14 years of education. Compare these values to the estimated marginal effects of education from the linear regression i n part (b) and quadratic in part (d).

Attachment:- wage.xlsx

Reference no: EM13926044

Questions Cloud

Develop a stem-and-leaf chart : Develop a stem-and-leaf chart. Note: A typical row for the Stem & Leaf plot might look like 3ê0269. Where, the vertical line is obtained by using "Shift & |\" key. The line is inserted at the location of the cursor.
Different perspectives on psychology : Write a 500- to 750-word paper in which you select and describe three different perspectives on psychology, including major theoretical positions and ideas. Describe why the goals of psychology are applicable to your life, and how each perspective..
Abdomen and gi system: abdominal distention : -How long? Does it come and go? What relives it??-Other symptoms associated? Abdomen and GI System: Change in Bowel Habits
Probability of getting exactly three heads : A fair coin is tossed 6 times. What is the probability of getting exactly 3 heads in the 6 tosses?
How much does education affect wage rates : Conduct a simple linear regression analysis to examine the relationship between 'education' (the independent variable) and 'wage' (the dependent variable). Using the Excel data file, prepare a 2000 word report.
Describe what happens to q and to investment in response : Specifically, on date s, a coin will be flipped to decide whether to keep the tax rate constant or to raise it. If it is decided to raise taxes, the change will take place immediately. Describe what happens to q and to investment in response to th..
Breasts and axillae: inspect breasts abnormal findings : -marked asymmetry?-rapid changes in size of one could indicate inflammatory process or growth?-dimpling, retraction, or bulging could indicate a malignancy?-inflammation may cause surface erythema and heat
Calculate measurements of central tendency and dispersal. : Determine confidence intervals for data.
Series of studies of economic growth : In a series of studies of economic growth conducted at the National Bureau of Economic Research, economists showed that the historic rate of economic growth in GDP could not be accounted for entirely by growth in labor and capital inputs. Consensu..

Reviews

Write a Review

Microeconomics Questions & Answers

  The free rider problem

Question: Explain why the free rider problem makes it difficult for perfectly competitive markets to provide the Pareto efficient level of a public good.

  Failure of the super committee is good thing for economy

Some commentators have argued that the failure of the “Super committee” is good thing for the economy?  Do you agree?

  Case study analysis about optimum resource allocation

Case study analysis about optimum resource allocation: -  Why might you suspect (even without evidence) that the economy might not be able to produce all the schools and clinics the Ministers want? What constraints are there on an economy's productio..

  Fixed cost and vairiable cost

Questions:  :   Which of the following are likely to be fixed costs and which variable costs for a chocolate factory over the course of a month?  Explain your choice.

  Problem - total cost, average cost, marginal cost

Problem - Total Cost, Average Cost, Marginal Cost: -  Complete the following table of costs for a firm.  (Note: enter the figures in the  MC   column  between  outputs of  0 and 1, 1 and 2, 2 and 3, etc.)

  Oligopoly and demand curve problem

Problem based on Oligopoly and demand curve,  Draw and explain the demand curve facing each firm, and given this demand curve, does this mean that firms in the jeans industry do or do not compete against one another?

  Impact of external costs on resource allocation

Explain the impact of external costs and external benefits on resource allocation;  Why are public goods not produced in sufficient quantities by private markets?  Which of the following are examples of public goods (or services)? Delete the incorrec..

  Shifts in demand and movements along the demand curve

Describe the differences between shifts in demand and movements along the demand curve. What are the main factors which can shift the demand curve? Explain why they cause the demand curve to shift. Use examples and draw graphs to support your discuss..

  Article review question

Article Review Question: Read the following excerpts from the article "Fruit, veg costs surge' by Todd, Dagwell, published in the Herald on January 25th 2011 and answer questions below:

  Long-term growth, international trade & globalization

Long-term Growth, International Trade & Globalization:- This question deals with concepts such as long-term growth, international trade and globalization. Questions related to trade deficit, trade surplus, gains from trade, an international trade sce..

  European monetary union (emu) in crisis

"Does the economic bailout of Spain and Greece spell the beginning of the end for the European Monetary Union (EMU)?"

  Development game “settlers of catan”

Read the rules of the game, the overview and the almanac for the Development Game "Settlers of Catan"

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd