+61-413 786 465

info@mywordsolution.com

## Economics

 Basic Economics Macroeconomics Microeconomics Business Economics Econometrics International Economics Managerial Economics Game Theory Public Economics

Economics and Quantitative Analysis Linear Regression Report Assignment -

Background - In your role as an economic analyst, you have been asked the following question: how much does education influence wages?

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

 Variable Label Wage Earnings per hour Educ Years of education

Instructions -

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

Purpose - In this section, the purpose of the report needs to be clearly and concisely stated.

Background - In this section, write a brief overview on the association between education and earnings. Why would economists be interested in this particular issue?

Method - In this section, provide an overview of the empirical approach used to examine the association between education and wages.

Results - In this section, you need to present and summarize the results from your statistical analysis. In particular, the result sections must:

• Provide a descriptive analysis of the two variables (e.g., mean, standard deviation, minimum and maximum).
• Develop a scatter diagram with education as the independent variable. What does the scatter diagram indicate about the relationship between the two variables?
• Estimate a regression equation that can be used to predict the wages given the level of education.
• State the estimated regression equation and interpret the meaning of the slope coefficient.
• Is there a statistically significant association between education and wages? What is your conclusion?
• Did the regression equation provide a good fit? Explain.
• Calculate the predicted wages for a person with 12 and 14 years of education, respectively. What is the difference in hourly wage rate?

Discussion - In this section, provide a brief overview of the results. What are the key strengths and limitations of this analysis? (e.g., data, method, etc.). How do the results from this analysis compare with other studies? (e.g., are the findings consistent?). Do these findings have clear policy implications?

6. Recommendations - In this section, you should present three well-considered recommendations.

Attachment:- Assignment Files.rar

Econometrics, Economics

• Category:- Econometrics
• Reference No.:- M93121257

Have any Question?

## Related Questions in Econometrics

### Economics and quantitative analysis linear regression

Economics and Quantitative Analysis Linear Regression Report Assignment - Background - In your role as an economic analyst, you have been asked the following question: how much does education influence wages? The Excel d ...

### Question - consider the following regression model for i 1

Question - Consider the following regression model for i = 1, ..., N: Yi = β1*X1i + β2*X2i + ui Note that there is no intercept in this model (so it is assumed that β0 = 0). a) Write down the least squares function minim ...

### Monte carlo exercisein order to illustrate the sampling

Monte Carlo Exercise In order to illustrate the sampling theory for the least squares estimator, we will perform a Monte Carlo experiment based on the following statistical model and the attached design matrix y = Xβ + e ...

### Basic econometrics research report group assignment -this

Basic Econometrics Research Report Group Assignment - This assignment uses data from the BUPA health insurance call centre. Each observation includes data from one call to the call centre. The variables describe several ...

• 13,132 Experts

## 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.

### 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