Provide a descriptive analysis of the two variables

Reference no: EM132774631

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:

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 1500 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 of 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 the 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:- Linear regression analysis.rar

Reference no: EM132774631

Questions Cloud

How much would it be willing to lend the business owner : If the bank is charging customers 7.5 percent APR, how much would it be willing to lend the business owner?

What is the activity method for swifty corporation : What is the Activity method for 2020, assuming that machine usage was 830 hours? Swifty Corporation purchased a new machine for its assembly process on August 1

What is the price of the bond now : What is the price of the bond now at 8% ytm? What prices for the bond at these new yields would be predicted by the duration rule and the duration-with-convexit

Determine the proper allowance for uncollectibles one year : Why did you approve the accounting for new acquisitions of plant and equipment that were not supported by adequate underlying documentation?

Provide a descriptive analysis of the two variables : Develop a scatter diagram with education as the independent variable. What does the scatter diagram indicate about the relationship between the two variables?

Which statements is true concerning intangible assets : Which statements is true concerning intangible assets? Intangible assets are listed in the Stockholders' Equity section of the balance sheet

How irene will be taxed on the lump sum she receives : Basil dies in year two of his contract. Which of the following statements correctly describes how Irene will be taxed on the lump sum she receives?

Which would not appear on an income statement : Which would not appear on an income statement? Which of the following includes only current assets? Cash, land, accounts receivable, inventory

What are the motives of a reputable bank to expand : What are the motives of a reputable bank to expand its subsidiaries outside its home country? Please elaborate and give and example for each motive/strategy.

User Account

All Pages