Provide a descriptive analysis of the two variables

Assignment Help Econometrics

Reference no: EM131837688

Assignment: Economics and Quantitative Analysis- Linear Regression Report

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.

Reference no: EM131837688

Questions Cloud

What is important about the staffing of fusion centers : What is different and important about the staffing of Fusion Centers that proponents say make them effective?

Owner of bleckie investment and real estate company : Tim Bleckie is the owner of Bleckie Investment and Real Estate Company. The com- pany recently purchased four tracts of land in Holly Farms Estates

Expansion project that requires initial fixed asset : Down Under Boomerang, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2.67 million.

Real exchange rate of euros to the dollar : Suppose that Australia's price level is 140, the Euro price level is 100, and the nominal exchange rate of pounds to the dollar

Provide a descriptive analysis of the two variables : Provide a descriptive analysis of the two variables. State the estimated regression equation and interpret the meaning of the slope coefficient.

Main effects of immigrant worker on us economy : What are the three main effects of immigrant worker on US economy? (Both positive and negative)

Define cost-benefit analysis and do library research : Define cost-benefit analysis and do library or Internet research to provide a real-world example. Include a reference or a link for information on your example.

Search for additional funds to the government : As Lord Commander of the Kings Guard under King Joffrey Barathon, Jaime was paid a a large weekly salary and set his own hours.

Project total nominal cash flow from assets for each year : What is the project’s total nominal cash flow from assets for each year?

User Account

All Pages