Create a correlation matrix of all the variables

Reference no: EM13864827

Need to download Eviews software. a free version is available at Eviews.com

Please follow all the instructions, or your problem set will receive no points. Answer all questions neatly and in order on separate sheets of paper. (You do not need a separate sheet for each question, but must present your answers in order.) All answers must be typed. No hand written work will be accepted. Place your name and "Econ 140-02 PS 1" or "Econ 140-03 PS1," whichever is appropriate for your section number in the upper right hand corner of each page and number all pages. Staple all pages together. Note that that neatness and presentation is important. Prepare this assignment as though it were a resume and job application. If you submit something that looks like scratch paper or rubbish, I will treat it as such. Problem sets are due at the beginning of lecture and will not be accepted late. While I encourage you to form study groups and work together, your submitted work must be your own. Problem sets that are identical (in whole or in substantial part) to another student's problem set will receive a zero. Problem sets should NOT be left in my Economics Department mailbox or under my office door. I am not responsible for problem sets turned in any way other than to me at the beginning of lecture. No electronic submissions will be accepted.

You will perform the steps below in Eviews, using the data set you constructed for Problem Set 4. (I have posted this data to the course web page. If you were unable to match the summary statistics, you should go through your data in detail and try to figure out why they don't match.) You should create and save a work file as we will build on the steps below in the next couple of problem sets. Cut and paste key output into a Word document and also include any explanations called for in your final submission.

Do the following:

a. Picking your independent variable first, create a scatterplot of WAGE_RATE and YEARS_EDUCATION and of WAGE_RATE and TENURE. What patterns do you observe? Include the first scatterplot in your final submission.

b. Repeat part a, but using WAGES instead of WAGE_RATE

c. Create a correlation matrix of all the variables in your data set including the dummy variables. What are the correlation coefficients between the variables you plotted in part b? Do you see any indications of multi-collinearity in the correlation matrix? Explain.

d. Run a regression with WAGE RATE as the dependent variable and AGE, FEMALE, WHITE, TENURE, YEARS OF COMPLETED EDUCATION, MARRIED, BACHELORS and GRADUATE as explanatory variables. Include Eviews output and also report your results in equation form and briefly discuss. What key results do you see? Interpret these results.

e. Suppose you think the returns to years of education differ depending on gender. Modify your model to account for this. Explain what you have done and why. Report your results in equation form and comment.

Attachment:- 140_PS5_Data.xlsx

Reference no: EM13864827

Questions Cloud

Expense will be in consolidated financial statements : Red Co. acquired 100% of Green, Inc. on January 1, 2012. On that date, Green had inventory with a book value of $42,000 and a fair value of $52,000. This inventory had not yet been sold at December 31, 2012. How much total expense will be in the cons..

What is the likely effect of an exogenous decrease : Question is: What is the likely effect of an exogenous decrease in the price of oil on the Canadian economy? Explain how the Bank of Canada would respond to such shock

Compute the combined tax liability of the two corporations : Avis's taxable income for the year is $300,000 and Best's taxable income for the year is $425,000. For each of the scenarios provided, state if a control group has been created and, if so, define the controlled and compute the combined tax liability ..

Equity in subsidiary earnings : Cashen Co. paid $2,400,000 to acquire all of the common stock of Janex Corp. on January 1, 2010. Janex's reported earnings for 2010 totaled $432,000, and it paid $120,000 in dividends during the year. On the consolidated financial statements for 2010..

Create a correlation matrix of all the variables : Create a correlation matrix of all the variables in your data set including the dummy variables. What are the correlation coefficients between the variables you plotted in part b? Do you see any indications of multi-collinearity in the correlation ma..

The issuance of stock dividend : The issuance of a stock dividend will

Claim bad debt deduction : Sharon is an orthopedic surgeon. She performed a surgery 2 years ago and billed $10000 to her patient. After 2 years of attempting to collect the money, it is clear that she will not be albe to collect anything. Sharon reports income on her tax retur..

Prepays insurance coverage-considered product-period costs : A manufacturing company prepays its insurance coverage for a three-year period. The premium for the three years is $3,330 and is paid at the beginning of the first year. Ninety percent of the premium applies to manufacturing operations and ten percen..

Tax-deductible entertainment expense : Grace is self-employed sales consultant who spends significant time entertaining potential customers. She keeps all the appropriate records to substantiate her entertainment. She has the following expenses in the current year: What is the tax-deducti..

User Account

All Pages