Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Microeconomics Expert

Economics


Home >> Microeconomics

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 (2 marks)
- Background (2 marks)
- Method (4 marks)
- Results (4 marks)
- Discussion (5 marks)
- Recommendations (3 marks)

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 in part (b) and quadratic in part (d)

Attachment:- data.xlsx

Microeconomics, Economics

  • Category:- Microeconomics
  • Reference No.:- M91598856

Have any Question?


Related Questions in Microeconomics

Question a explain how an amplification mechanism may have

Question: a) Explain how an amplification mechanism may have been created from mortgage losses to the effect on the economy. What three factors may have contributed? Explain each. b) Explain the process of a financial cr ...

Question in the monopolistic competition model with trade

Question: In the Monopolistic competition model with trade, all firms are identical, so all firms export. In reality, only about 20% of the US firms are exporters. Describe a way to account for this by extending the mono ...

Question some economists studying the effects of the

Question: Some economists studying the effects of the minimum wage law have found that it tends to reduce the employment of black teenagers relative to white teenagers. Does the graph in the Making the Connection help yo ...

Question - what is the maximum amount you would pay for an

Question - What is the maximum amount you would pay for an asset that generates an income of $ 100,000 at the end of each of the four years of the opportunity cost of using funds is 10 percent?

Question explain the following theoriesa what is the coase

Question: Explain the following theories: A. What is the Coase Theorem, and when is it likely to be helpful in leading a market with externalities to provide the socially efficient level of output? B. In the theory of co ...

Question explaini what economic factors have been

Question: Explain (i) what economic factors have been responsible for China's economic performance in those 30 years to outperform most "Western" capitalist economies. 300 word (ii) Do you then conclude that Socialism wi ...

Question engineering economythe abc corporation has an

Question: Engineering Economy: The ABC Corporation has an investment opportunity that costs $125,000 and 7 years later pays a lump-sum amount of $215,000. What percent interest rate per year would be earned on this inves ...

Question 1 is gdp a good way to measure a countys wellbeing

Question: 1) Is GDP a good way to measure a county's wellbeing? In other words, if a country has a large GDP, should one conclude the residents of that country generally have a high quality of life? 2) What causes "rich" ...

Question 1 given the current state of the economy what

Question: 1. Given the current state of the economy, what should Fed. Do with monetary policy and why? 2. Compare the pros and cons of independent central bank? 3. Compare pros and cons of monetary rule and discretionary ...

Question historically wages in the united states have been

Question: Historically, wages in the United States have been high relative to wages elsewhere. Does the chapter shed light on this phenomenon? Explain. The response must be typed, single spaced, must be in times new roma ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved